inseting data to ms access error
hi i'm new to vb.net. i'm using visual studio 2005 windows application vb.net language. i'm doing a company project and using MS access database.
i want the user to add data about the new customer and save it to the database.i used the followinf code:
vb.net Code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim dbconnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "data source=C:\Users\becool\Desktop\customer list\New Farahnet\FarahnetCustomers.mdb"
Dim dbcommand As String = "INSERT into customers (Fname, Lname, IP, Telephone, Email, Location, TypeocConnection, Download, Upload, StartDate, StoppedDate) " & " VALUES ('Textbox1.text','Textbox2.text','Textbox3.text','Textbox 4.text','Textbox5.text','Textbox6.text','Textbox7.text','Textbox8.text','Textbox9.text','Textbox10.text','Textbox11.text')"
Dim DataAdapterTest As New OleDb.OleDbDataAdapter(dbcommand, dbconnection)
Dim customersDataSet As New DataSet()
[U]DataAdapterTest.Fill(customersDataSet)[/U]
Dim dtcustomers As DataTable = customersDataSet.Tables(0)
End Sub
but i get an error on the underlined line above.can anyone please tell me if there is anything wrong with it?
Re: inseting data to ms access error
The Fill method retrieves data from the database; it doesn't save data. Follow the Database FAQ link in my signature and check out the .NET section for resources. The second link in that section is my own ADO.NET code examples that show you how to implement the most common scenarios.
Re: inseting data to ms access error
In addition, when you get an error in your code, it is always beneifical to explicity state what that error is when asking for assistance.
Thanks.