inseting data to ms access error

[becool20082008]

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:

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?

[jmcilhinney]

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.

[Hack]

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.