Error near objCommand.ExecuteNonQuery();

Prudhvi Raj

9y1.3kLearn iOS Programming

Error:

Exception thrown: 'System.Data.SqlClient.SqlException' in System.Data.dll

Additional information: Incorrect syntax near the keyword 'Table'.

CODE:

string ConnectionString = "Data Source=LocalHost;Initial Catalog=radiant;Integrated Security=True;Pooling=False";

SqlConnection objconnection = new SqlConnection(ConnectionString);

objconnection.Open();

// fire the command object

string strInsertCommand = "Insert into table [Table ] Values('"

+ tbun.Text + "','"

+ cbcountry.Text + "','"

+ gender + "','"

+ hobbies + "',"

+ rbmarried.Checked + ")";

SqlCommand objCommand = new SqlCommand(strInsertCommand, objconnection);

objCommand.ExecuteNonQuery();

objconnection.Close();

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jitendra Shekhawat9y ago
write your right table name
Red word

string ConnectionString = "Data Source=LocalHost;Initial Catalog=radiant;Integrated Security=True;Pooling=False";
SqlConnection objconnection = new SqlConnection(ConnectionString);
objconnection.Open();
// fire the command object
string strInsertCommand = "Insert into table [Table ] Values('"+ tbun.Text + "','"+ cbcountry.Text + "','"+ gender + "','"+ hobbies + "',"+ rbmarried.Checked + ")";
SqlCommand objCommand = new SqlCommand(strInsertCommand, objconnection);
objCommand.ExecuteNonQuery();
objconnection.Close();
Catcher Wong9y ago
Hi ,

I suggest you to use the string.Format so that you can easy to find out what's wrong with you sql.

Here is the sample code :
string ConnectionString = "Data Source=LocalHost;Initial Catalog=radiant;Integrated Security=True;Pooling=False";
SqlConnection objconnection = new SqlConnection(ConnectionString);
objconnection.Open();

// try the following code
string strInsertCommand = string.Format(@"Insert into table [Table ]
Values ('{0}','{1}','{2}','{3}','{4}')",
tbun.Text, tbun.Text, cbcountry.Text, gender, hobbies, rbmarried.Checked);

SqlCommand objCommand = new SqlCommand(strInsertCommand, objconnection);
objCommand.ExecuteNonQuery();
objconnection.Close();
Hope this way can help you!
Rafnas T P9y ago
hi,

pleae check your insert statement there is a gap in Table and end you have to close single quote as you can see in red
string strInsertCommand = "Insert into table [Table ] Values('"
+ tbun.Text + "','"
+ cbcountry.Text + "','"
+ gender + "','"
+ hobbies + "',"
+ rbmarried.Checked + ")";
it should be
string strInsertCommand = "Insert into table [Table] Values('"
+ tbun.Text + "','"
+ cbcountry.Text + "','"
+ gender + "','"
+ hobbies + "',"
+ rbmarried.Checked + "')";
Manas Mohapatra9y ago
Debug below line and see what is the value in strInsertCommand variable. Itt is mostly error in SQL query. Secondly there is a space in [Table ], try to remove and see the result.

tring strInsertCommand = "Insert into table [Table ] Values('"
+ tbun.Text + "','"
+ cbcountry.Text + "','"
+ gender + "','"
+ hobbies + "',"
+ rbmarried.Checked + ")";
Dharmraj Thakur9y ago
Your insert query is incorrect...
string ConnectionString = "Data Source=LocalHost;Initial Catalog=radiant;Integrated Security=True;Pooling=False";
            SqlConnection objconnection = new SqlConnection(ConnectionString);
            objconnection.Open();
            // fire the command object
            string strInsertCommand = "Insert into tableName values('"+ tbun.Text + "','"+ cbcountry.Text + "','"+ gender + "','"+ hobbies + "',"+ rbmarried.Checked + ")";
            SqlCommand objCommand = new SqlCommand(strInsertCommand, objconnection);
            objCommand.ExecuteNonQuery();
            objconnection.Close();