Click here to Skip to main content
13,042,630 members (80,230 online)
Rate this:
Please Sign up or sign in to vote.
See more:
when i m exuting the code i got the messg "syntax error in insert statemnt"
where i am doing mistak?
 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);
            dap.Fill(ds, "EmployeeLogin");
            DataRow dr = ds.Tables["EmployeeLogin"].NewRow();
            dr[0] = txtCode.Text;
            dr[1] = txtPasswrd.Text;
                dap.Update(ds, "EmployeeLogin");
            catch (Exception eee)
Posted 1-Dec-12 17:03pm
Please don't re-post; it cannot help you, can only give you down-votes or abuse reports...
I removed one redundant question.

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Why don't you take the query from the stored procedure and check if the syntax within that query is correct.
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)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 1 Dec 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100