Click here to Skip to main content
12,064,812 members (40,111 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C#2.0 C#
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 18:03pm
Comments
   
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 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.160204.4 | Last Updated 1 Dec 2012
Copyright © CodeProject, 1999-2016
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