Click here to Skip to main content
15,896,606 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
when i m exuting the code i got the messg "syntax error in insert statemnt"
where i am doing mistak?
C#
OleDbConnection connection = new OleDbConnection();

           ConnectionClass cc = new ConnectionClass();
           connection.ConnectionString = cc.GetConnection();



           DataSet ds = new DataSet();

           OleDbDataAdapter dap = new OleDbDataAdapter("Select * from EmployeeLogin", connection);

           OleDbCommandBuilder cmdBuilder = new OleDbCommandBuilder(dap);

           connection.Open();
           dap.Fill(ds, "EmployeeLogin");
           DataRow dr = ds.Tables["EmployeeLogin"].NewRow();
           dr[0] = txtCode.Text;
           dr[1] = txtPasswrd.Text;

           try
           {
               ds.Tables[0].Rows.Add(dr);
               dap.Update(ds, "EmployeeLogin");
           }
           catch (Exception eee)
           {
               MessageBox.Show(eee.Message);
           }
Posted
Comments
Sergey Alexandrovich Kryukov 2-Dec-12 1:23am    
Please don't re-post; it cannot help you, can only give you down-votes or abuse reports...
I removed one redundant question.
--SA

1 solution

Why don't you take the query from the stored procedure and check if the syntax within that query is correct.
 
Share this answer
 
Comments
Mithlesh Shaw 1-Dec-12 23:48pm    
I hv tried
SELECT EmployeeLogin.[EmpId], EmployeeLogin.[Password]FROM EmployeeLogin
bt i am getting the same error
Abhinav S 2-Dec-12 23:00pm    
That is not an insert statement, that is just a simple select statement.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900