SQLException Unhandled Syntax error near ')'

who cares

Following is the code snippet i wrote for taking values from all the rows of a dataGridView and insert them into a table. The table name is stored in a string variable subtable.

During debugging an exception occurs at the y.ExecuteNonQuery() line saying:

SQLException Unhandled

Syntax error near ')'

x = new SqlConnection("Data Source= AHSUYA ;initial catalog=master;integrated security=sspi;");

x.Open();

for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)

{

y = new SqlCommand("Insert into " + subtable + "values(@a,@b,@c)",x);

y.Parameters.AddWithValue("@a", dateTimePicker1.Value.Date.ToShortDateString());

y.Parameters.AddWithValue("@b", dataGridView1.Rows[i].Cells[0].Value.ToString());

y.Parameters.AddWithValue("@c", dataGridView1.Rows[i].Cells[1].Value.ToString());

y.ExecuteNonQuery();

}

x.Close();

I cannot determine whats wrong with the code ... please help me out !!!

6 Replies

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

Pankaj Kumar Choudhary11y ago
hello use this query

x = new SqlConnection("Data Source= AHSUYA ;initial catalog=master;integrated security=sspi;");
x.Open();
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
y = new SqlCommand("Insert into " + subtable + " values(@a,@b,@c)",x);
/* I think this error was occur because Query was not in correct format, space b/w table name
and values */
y.Parameters.AddWithValue("@a", dateTimePicker1.Value.Date.ToShortDateString());
y.Parameters.AddWithValue("@b", dataGridView1.Rows[i].Cells[0].Value.ToString());
y.Parameters.AddWithValue("@c", dataGridView1.Rows[i].Cells[1].Value.ToString());

y.ExecuteNonQuery();
}
x.Close();
0
Manoj Bhoir11y ago
Hi,

Your code is perfect just You forget to add Space between Table Name and keyword Values.

Change this line

y = new SqlCommand("Insert into " + subtable + "values(@a,@b,@c)",x);

To this

y = new SqlCommand("Insert into " + subtable + " values(@a,@b,@c)",x);
0
who cares11y ago
since the table that i'm using has only 3 columns so i don't think mentioning column name is necessary!
0
who cares11y ago
subtable is a variable as i mentioned before ... so i'll have to concatenate it with the string ..
0
Khargesh Rajput11y ago
use like

y = new SqlCommand("Insert into subtable values(@a,@b,@c)",x); if you have 3 columns

or if you want to insert only 3 columns

use
y = new SqlCommand("Insert into subtable (a,b,c) values(@a,@b,@c)",x); // if columnname are a,b,c
0
Rajeesh Menoth11y ago
Hi,

check this line ..

y = new SqlCommand("Insert into " + subtable + "values(@a,@b,@c)",x);

write like this

y = new SqlCommand("Insert into subtable(CustomerName,Address,City) values(@a,@b,@c)",x);
//provide the column name then insert value..
0