Insert values into MS Access Database table

[kareemaffan]

Hello Everyone

I want to insert values into MS Access database through VB.NET in Visual Studio 2005 . I have used the following code which is not working.

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim con As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLED B.4.0;Data Source=DSA.mdb")
con.Open()
Dim cmd As New OleDb.OleDbCommand("insert into users lname='" & TextBox2.Text & "' and lpwd='" & TextBox3.Text & "'" & "and Username='" & TextBox4.Text, con)

Please help me

[kenobewan]

What error message are you receiving? Looks like you don't have your quotations right, suggest you debug. HTH.

[kareemaffan]

What error message are you receiving? Looks like you don't have your quotations right, suggest you debug. HTH.

Thanks for the reply
The error I am facing is "syntax error in INSERT INTO statement"
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim con As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLED B.4.0;Data Source=DSA.mdb")
con.Open()
Dim cmd As New OleDb.OleDbCommand("insert into users lname='" & TextBox2.Text & "' and lpwd='" & TextBox3.Text & "'" & "and Username='" & TextBox4.Text, con)


Can U please provide the above statement with correct quotes.

I have even tried
Dim con As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLED B.4.0;Data Source=E:\Visual Studio 2005\Projects\image\WindowsApplication1\DSA.mdb")
con.Open()
Dim cmd As New OleDb.OleDbCommand("insert into users values '" & TextBox2.Text & "' '" & TextBox3.Text & "' '" & TextBox1.Text, con)
Dim dr As OleDb.OleDbDataReader = cmd.ExecuteReader(CommandBehavior.SingleResult)

[Vijith]

Dim cmd As New OleDb.OleDbCommand("insert into users(Field names seperated by comma) values( '" & TextBox2.Text & "' '" & TextBox3.Text & "' '" & TextBox1.Text & "' )", con)


You should complete the single quote for the last parameter.
Also specify field names of the table.

[barathkumar]

Hi Friends
I Am New To Vb.net Pls Help Me Out In For Connecting Msaccess And Sql Databases And Coding For It And Coding For Inserting,deleting,updating,next,previous First And Next Pls

[barathkumar]

how can we able to update ,insert,rows using asp.net.
I am new to dotnet pls help me out pls also specify for oracle and access

[kareemaffan]

Dim cmd As New OleDb.OleDbCommand("insert into users(Field names seperated by comma) values( '" & TextBox2.Text & "' '" & TextBox3.Text & "' '" & TextBox1.Text & "' )", con)


You should complete the single quote for the last parameter.
Also specify field names of the table.

Thanks a lot for your response.
I am extremely thankful for your interest in solving my problem.