Need help in code

Question

My execute query is not executing inside loop. foreach(DataRowrow1 indt.Rows)
{
EmpNo = (row1["EmpNo"].ToString());
EmpName = (row1["EmpName"].ToString());
command.CommandText = "insert into table(id,EmpNo,EmpName) values("+ id+ ","+ EmpNo + ",'"+ EmpName + "')";
command.ExecuteNonQuery();
}
please help me

Shweta Lodha · Accepted Answer

Hi Nithika,
I am assuming that you are opening connection object before Foreach loop.
Such things happen, when you are trying to insert some symbols as part of your SQL statement. Here I would suggest you to use parameters as:
command.Parameters.AddWithValue("EmpName", EmpName);
For more information on parameters, please checkout this below link:
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters.aspx
If still it doesn't resolve your issue, please paste the code of your entire method.

Shweta Lodha · Answer

Glad to hear that your issue is resolved.

Nithika · Answer

Thanks Shweta Lodha. You pointed out correctly, issue was because of apostrophe symbol I was passing in EmpName.