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:
  1. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
  2. Dim dbconnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "data source=C:\Users\becool\Desktop\customer list\New Farahnet\FarahnetCustomers.mdb"
  3.  
  4. 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')"
  5.  
  6. Dim DataAdapterTest As New OleDb.OleDbDataAdapter(dbcommand, dbconnection)
  7.  
  8. Dim customersDataSet As New DataSet()
  9.  
  10. [U]DataAdapterTest.Fill(customersDataSet)[/U]
  11.  
  12. Dim dtcustomers As DataTable = customersDataSet.Tables(0)
  13.  
  14. End Sub
but i get an error on the underlined line above.can anyone please tell me if there is anything wrong with it?