I have an mdf file in the vb.net 3.5 project I am working on. I wanted to write an stored procedure that will create a back up of the db in a selected location. How can I take a back up of the database from my application? I want the user to take a back up of the database manually.
View 4 Replies
I am working on an application that ties into a SQL database on the back end. Currently the main form contains a series of combo boxes (Graph type, data format, location, and customer), two date pickers, and a button to launch the selections in a new form. Everything works just fine except there are a couple of things I can't seem to accomplish.
Example Data:
[CODE]...........
Case Select (with commented out lines for variations attempted):
[CODE]..........
1) I would like to be able to use some sort of case statement to color the bars in my chart based on value. I have tried approaching this in a couple of different ways but neither of the options seem to work. First, I tried this (the If Not is used because depending on what values are passed to the stored procedure in SQL, different columns will be returned):
[CODE]..........
Only one series is created with this method, so I can see how/why a Select Case would set all bars the same color. I have also tried creating a series for each row in the returned dataset but it results in 22 bars of different colors, for each of the rows (484 bars):
[CODE]..........
So is there any way to modify the second set of code there to only select the value from the "Percent TMHB" cell that corresponds with Row(i), rather than ALL values from the "Percent TMHB" column for EACH Row(i)?
2) Since I am drawing/creating these graphs in a new window, is there any way to also create a new timer on the "newFrm" and have the tick refresh the data? I've struggled with this but I feel like it should be easy. Say someone chooses a "TMHB", "Percentage", "Chicago", "All" (Graph type, data format, location, customer) and launches the graph, which opens in a new window, then they want to do "TMHB", "Percentage", "LA", "All" and have both windows up, refreshing automatically throughout the day. Can I somehow store the SelectCommand.Parameters values in the new form/timer so that it will query the database again every 5 minutes?
Example code for the StoredProcedure and creating the new form:
If combo_GraphType.SelectedItem = "TMHB" Then
Dim newFrm As New Form
Dim newChart As New Chart
[CODE]..................
can anyone teach me how to save data in microsoft access database and retrieving it back from database?[code]so, how do i save it in that and how do i load their data by typing their ic no only..
View 5 Replieshow to get back application 3.5 to 2.0 i set my apps to 3.5 almost done... but i want dontnet 2.0 to use.
View 1 Repliesi have a form and i want to have my form to have a button thatwhen i click the button a backup of database will firedo you have any solution or idea for this
View 7 Replies[code]So both methods seem to step through fine but don't commit the changes back to the database. This function is my only 'edit' function. It needs to look for the datarow which is to be edited. Edit it and then save the changes to the database.My other two functions create datarows and work fine. This one I just can't work out. I have a dataset with two datatables. This is running as a web service. Database is MSSQL.
View 1 RepliesI am strugling to get a value back from an access database, what i am using is,
Public Shared Function ReturnTimes(ByVal DateValue As Date) As DataTable
Dim cmd As OleDbCommand = New OleDbCommand()
With cmd
.Connection = Database.conn
[Code]...
How can i take back up on Every minute and hourly and complete whole day backup using VB.NET i.e i want to know the coding example
View 5 RepliesI want to make application which will go back and go forward on internet browser in program.
I want: When I will click button1 then internet browser go back and go forward and so on all time. Click(button1) --> GoBack Browser - here must be break - 15 seconds --> GoForward Browser --> do it all again and again.
I do only it:
Public Class Form1
Private Sub WebBrowser1_DocumentCompleted(ByVal sender As System.Object, ByVal e As System.Windows.Forms.WebBrowserDocumentCompletedEventArgs) Handles WebBrowser1.DocumentCompleted
End Sub
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
[Code] .....
I am trying to create a back button for a Windows Application to go from one form to it's previous form.
I know how to go to the next form, just can't figure out the other way.
I am developing and application for playing back recorded clips from dvr. There will be 10 persons reviewing the recorded clips all the time. When the person want to review a particular camera recorded clip, he will send a command through COM to my application. Then my application will read the data from COM and connect to dvr and send data to the dvr. If only 1 person is doing the operation my application works fine. If 10 persons continuously working, then my application is getting very slow and the response time back to the person is high which will make the person frustrated to use the software.
Now, when ever I receive data from COM I'm adding into arraylist and I'm processing one by one. I've 10 forms in my application and when ever I receive data from person1 I'll send that data to form1 and person2's data will be send to form2 and so on for processing. What could be the better way to write my application in order to make the response time to the user faster so that, they'll get the recorded clips faster?
been banging my head on this, i need to get the applications path, then go up 1 folder then into another. As i have a main app and sub apps.
So were Application.StartupPath()is for example:"C: Main app folderSub app folder"How do i then go up a folder to"C: Main app folder"I Know it needs some string removal using on it but i can seem to get it right, after which i could then use Application.StartupPath() 'string removal here" & " ools"to navigate to another sub apps folder etc.
experts is it possible to roll back insert or update operation in ms access database..
View 1 RepliesI have an xbap application that connects to a webservice to run different stored procedure. The webmethod loads the data into a data table and returns it to my xbap application. My program gives the user the option to manipulate the data. What is the best option for saving the data back to the database?
View 6 RepliesI think my problem in my code is the savefiledialog1. I tried running the code without it and it works. There's no error.
I also remove the if condition in the .ShowDialog and it worked. But when I press the cancel button, the code still runs.
vb
Private Sub butBackup_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles butBackup.Click
With SaveFileDialog1
[Code].....
I loaded a dataset (just one table) from the database. Then I modified f.e. the rows from 5 to the end and add 4 new rows. Now, I would like to write back the dataset into the database.
View 2 RepliesI am having a problem with an application that displays data in datagridview depending on a selection from a combo box.The problem occurs when I want to write the data back to the database.
I get the following error:"Update unable to find TableMapping['Product'] or DataTable 'Product'."
Is this because the table in the dataset is filled in a private sub? If so how do I make it public?
Any ideas what is wrong. Code is as follows:
[Code]...
I was hoping that I could get some guidance from some of you guys on Object Design with Database back ends. I am trying to build what could be considered to be my first full scale application, which is a student tracker (simplification). While I have a reasonable idea of how I would go about designing the classes for the system, the bit that I don't know how to do is, how I would go about getting the data to and from the database.
For example with my other applications, I have done a couple of things;
1) Gathered all the data when the application started up, creating the objects then. Then when the application closed sending the data back to the database.
2) Have the code which deals with getting the data in the specific class, so the student class for example would take only one constructor argument which would be the studentID, then the class code would connect to the database and populate the object fields as appropriate.
3) Variations of the above. I have also looked into LINQ, which seems like it would be very useful if you don't expect your classes to deal with any business logic and just data, but I suppose it would be possible to create a wrapper class that would include the business logic.
[Code]....
I was hoping that I could get some guidance from some of you guys on Object Design with Database back ends.I am trying to build what could be considered to be my first full scale application, which is a student tracker (simplification). While I have a reasonable idea of how I would go about designing the classes for the system, the bit that I don't know how to do is, how I would go about getting the data to and from the database
View 3 RepliesIw ould like to know how to make it so every time you click on a button a different outcome can happen from the opens i gave the application.such as: when i click button 1.i will want it to either close the application or show a textbox but the outcome should be random out of the two.Like a dice if you get 1, 2, 3 the application will execute command "Me.close()" but if it rolls 4, 5, 6 it will execute the command "textbox1. show()"
View 1 RepliesI am using MS Access 2003 and vb.net to develop a windows application of inventory management.
I have used datagridview in the form and using FillBytoolstrip option, can filter data using type.
But i have no idea as to how can i update the database to reflect the latest changes in the gridview.
following is the code I have used.
Private Sub BOM_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.PartnoTableAdapter.Fill(Me.HemDatabase1DataSet3.partno)
End Sub
[Code].....
I am using VB.net 2003. I am working on a stand alone windows program that stores data in an Access database via ADO.net via MS jet 4.0 OLEDb. I have progressed to the point that I would now like to provide the end user the oportunity to back-up the data they have stored and re-install if they choose. I am envisioning a menu item for "maintenance" with sub-items for "back-up" and "restore"
View 1 RepliesI just need to edit one field on a datarow and save the changes back to the database. My database is SQL Compact 3.5
I tried many methods but change is not saved to database.
Me.taSet.Fill(Me.Dsset.tblQuestions)
Dsset.tblQuestions.Rows(1).BeginEdit()
Dsset.tblQuestions.Rows(1).Item("ExamID") = "EDITED"
Dsset.tblQuestions.Rows(1).AcceptChanges()
taSet.Update(Dsset.tblQuestions)
private
void bindingNavigatorDeleteItem_Click(object
sender, EventArgs e)
{
[Code]....
code does not make chages to database when i reopen the application the records exists as earlier.
In my project,I used the wizard in VB.NET2008 Express to connect to my database. I have a data connector, adapter, and dataset controls on my form. I have been able to load the information into the dataset, and used the datCustomers.Customers.AddCustomersRow to add a new row to the dataset with information.
I now want to save the updated dataset to the database. I have tried using the adapterCustomers.Update(datCustomers) command to no avail. how to save the dataset to the database?
i am using VB2008 and i need to work out how to search a database. it probably will be very easy but i cant understand it and havent been able to find any tutorials that are for VB 2008, only for other things that wont work, mainly because i dont understand much of what is been written/said/coded.
But the search button (btnsearch) isnt doing anything when the code is tested.
Public Class Form4
Inherits System.Windows.Forms.Form
Dim Con As New OleDb.OleDbConnection
[Code].....
VB.NET i have only one colum in back end database that is roll. .. Now i want to update a particular data .. the data types is integer.. i has a data like 12 and i ant to update it 13 how can i do..
[Code]...
I've already finished the program and the last task was to add a password for my MS Access database. I've created the password in Ms Access and I've already modified the connection and saved the password but when I run the program all codes like this
Me.Table1TableAdapter.Fill(Me.Database1DataSet.Table1)got an error message says Not a valid password.
I would like to try and implement a feature wherby once you have logged into an application (straightforward winforms application) and had your credetials verified the application would then force you to log on again if no activity had been detected in the application for a certain number of minutes. In essence I want to provide some extra security for those occasions when users get up and wander away from their machines for prolonged periods.
I have all the logic for logging into the application, it's just the checking for no activity over a given period and then forcing the user to log back in again that I'm not having much luck with.
I am Developing one designing tool..in this i have to implement Bring to front and sent to back properties.
View 3 Replies
