what is syntax error for the insert into qyery!! in c#

Jul 31 2010 1:59 AM
 string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Samples\\login.mdb";
               String uname, pass;
                uname = textBox1.Text;
                
                pass = textBox2.Text;
                OleDbConnection myConnection = new OleDbConnection(connectionString);
                myConnection.Open();
               
                String query = "insert into LOGIN_TABLE (UserName, Password) VALUES ('" + textBox1.Text.ToString() + "','" + textBox2.Text.ToString() + "') ";

                
                

                OleDbCommand myCommand = new OleDbCommand(query, myConnection);
                //myCommand.CommandText = query;
                OleDbParameter myParm = myCommand.Parameters.Add("@uname", OleDbType.VarChar, 50);
                myParm.Value = textBox1.Text;

                myParm = myCommand.Parameters.Add("@pass", OleDbType.VarChar, 50);
                myParm.Value = textBox2.Text;

                myCommand.ExecuteNonQuery();
                myConnection.Close();


Answers (4)