programerinfonet
چهارشنبه 14 اسفند 1392, 18:17 عصر
سلام دوستان
مشکل این کد چیه که خطای incurrect syntax near ","رو میده ؟
string sql = "";
for (int i = 0; i < dtshoraka.Rows.Count; i++)
{
sql = sql + "insert into tbl_shoraka (moshtari_id,flname,sahmosherke,shomaremeli,tavalo d,semat,shenasname,sodour,pedar,reg_type) values('" + strmoshtariid + "'," +dtvkhshoraka.Rows[i]["flname"].ToString().Trim() + "','" + dtvkhshoraka.Rows[i]["sahmosherke"].ToString().Trim() + "','" + dtvkhshoraka.Rows[i]["shomaremeli"].ToString().Trim() +"','" + dtvkhshoraka.Rows[i]["tavalod"].ToString().Trim() + "','" + dtvkhshoraka.Rows[i]["semat"].ToString().Trim() + "','" + dtvkhshoraka.Rows[i]["shenasname"].ToString().Trim() +"','" + dtvkhshoraka.Rows[i]["sodour"].ToString().Trim() + "','" +dtvkhshoraka.Rows[i]["pedar"].ToString().Trim() + "''مسئولیت محدود صورتجلسه مجمع')";
}
SqlCommand cmd_shoraka = new SqlCommand(sql, cn);
cmd_shoraka.ExecuteNonQuery();
مشکل این کد چیه که خطای incurrect syntax near ","رو میده ؟
string sql = "";
for (int i = 0; i < dtshoraka.Rows.Count; i++)
{
sql = sql + "insert into tbl_shoraka (moshtari_id,flname,sahmosherke,shomaremeli,tavalo d,semat,shenasname,sodour,pedar,reg_type) values('" + strmoshtariid + "'," +dtvkhshoraka.Rows[i]["flname"].ToString().Trim() + "','" + dtvkhshoraka.Rows[i]["sahmosherke"].ToString().Trim() + "','" + dtvkhshoraka.Rows[i]["shomaremeli"].ToString().Trim() +"','" + dtvkhshoraka.Rows[i]["tavalod"].ToString().Trim() + "','" + dtvkhshoraka.Rows[i]["semat"].ToString().Trim() + "','" + dtvkhshoraka.Rows[i]["shenasname"].ToString().Trim() +"','" + dtvkhshoraka.Rows[i]["sodour"].ToString().Trim() + "','" +dtvkhshoraka.Rows[i]["pedar"].ToString().Trim() + "''مسئولیت محدود صورتجلسه مجمع')";
}
SqlCommand cmd_shoraka = new SqlCommand(sql, cn);
cmd_shoraka.ExecuteNonQuery();