Click here to Skip to main content
11,703,631 members (67,371 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#2.0
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);
 
           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 1-Dec-12 17:03pm
Comments
Sergey Alexandrovich Kryukov at 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

Rate this: bad
good
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.
  Permalink  
Comments
Mithlesh Shaw at 1-Dec-12 23:48pm
   
I hv tried
SELECT EmployeeLogin.[EmpId], EmployeeLogin.[Password]FROM EmployeeLogin
bt i am getting the same error
Abhinav S at 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
0 Maciej Los 570
1 OriginalGriff 500
2 Sergey Alexandrovich Kryukov 410
3 F-ES Sitecore 165
4 Andy Lanng 159
0 OriginalGriff 8,519
1 Sergey Alexandrovich Kryukov 7,667
2 CPallini 4,987
3 Maciej Los 4,686
4 Mika Wendelius 3,566


Advertise | Privacy | Mobile
Web03 | 2.8.150819.1 | Last Updated 1 Dec 2012
Copyright © CodeProject, 1999-2015
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