An exception of type System Data SqlClient SqlException occurred in System Data dll

Question

When I execute my code below  this error message occurs    quot An exception of type  System Data SqlClient SqlException  occurred in System Data dll but was not handled in user code Additional information  Incorrect syntax near       quot   And this is the code  string position   SqlConnection con   new SqlConnection  quot server free-pc  FATMAH  Integrated Security True  database Workflow   quot    con Open    SqlCommand cmd   new SqlCommand  quot SELECT EmpName FROM Employee WHERE EmpID  quot    id Text  con    SqlDataReader Read   cmd ExecuteReader     if  Read Read    true        position   Read 0  ToString        Response Write  quot User Registration successful quot      else       Console WriteLine  quot No Employee found  quot       Read Close      What is causing this  and how can I resolve it

User · Answer

An unhandled exception of type  System Data SqlClient SqlException  occurred in System Data dll      private const string strconneciton    Data Source   Initial Catalog Employees Integrated Security True       SqlConnection con   new SqlConnection strconneciton        private void button1 Click object sender  EventArgs e                 con Open            SqlCommand cmd   new SqlCommand  insert into EmployeeData  Name S O Address Phone CellNo CNICNO LicenseNo LicenseDistrict LicenseValidPhoto ReferenceName ReferenceContactNo  values        textName Text           textSO Text           textAddress Text           textPhone Text           textCell Text           textCNIC Text           textLicenseNo Text           textLicenseDistrict Text           textLicensePhoto Text           textReferenceName Text           textContact Text          con           cmd ExecuteNonQuery            con Close

User · Answer

There are some problems with your code  First I advise to use parametrized queries so you avoid SQL Injection attacks and also parameter types are discovered by framework  var cmd   new SqlCommand  quot SELECT EmpName FROM Employee WHERE EmpID    id quot   con   cmd Parameters AddWithValue  quot  id quot   id Text    Second  as you are interested only in one value getting returned from the query  it is better to use ExecuteScalar  var name   cmd ExecuteScalar     if  name    null       position   name ToString       Response Write  quot User Registration successful quot      else       Console WriteLine  quot No Employee found  quot       The last thing is to wrap SqlConnection and SqlCommand into using so any resources used by those will be disposed of  string position   using  SqlConnection con   new SqlConnection  quot server free-pc  FATMAH  Integrated Security True  database Workflow   quot        con Open       using  var cmd   new SqlCommand  quot SELECT EmpName FROM Employee WHERE EmpID    id quot   con           cmd Parameters AddWithValue  quot  id quot   id Text          var name   cmd ExecuteScalar           if  name    null               position   name ToString           Response Write  quot User Registration successful quot              else               Console WriteLine  quot No Employee found  quot

User · Answer

Try this  SqlCommand cmd   new SqlCommand  SELECT EmpName FROM Employee WHERE EmpID  id   con   cmd Parameters AddWithValue  id   id Text

User · Answer

I think your EmpID column is string and you forget to use     in your value   Because when you write EmpID     id Text  your command looks like EmpID   12345 instead of EmpID    12345    Change your SqlCommand to  SqlCommand cmd   new SqlCommand  SELECT EmpName FROM Employee WHERE EmpID      id Text       con     Or as a better way you can  and should  always use parameterized queries  This kind of string concatenations are open for SQL Injection attacks   SqlCommand cmd   new SqlCommand  SELECT EmpName FROM Employee WHERE EmpID    id   con   cmd Parameters AddWithValue   id   id Text     I think your EmpID column keeps your employee id s  so it s type should some numerical type instead of character

User · Answer

using  var cmd   new SqlCommand  SELECT EmpName FROM  Employee  WHERE EmpID    id   con     put    around table name

User · Answer

use try-catch to see real error occurred on you   try       Your insert code here   catch  System Data SqlClient SqlException sqlException      System Windows Forms MessageBox Show sqlException Message

[c#] An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

Examples related to c#

Examples related to .net

Examples related to sql

Examples related to sql-server

Examples related to visual-studio-2013