mohsen622001
یک شنبه 27 تیر 1389, 01:30 صبح
var ObjupConnection = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=forshgah;Integrated Security=True;Pooling=False");
var Objupcommand = new SqlCommand("Update Set cod,Name,ghkharid,ghforosh,tedadkh Values @code,@Name,@ghkharid,@ghforosh,@tedadkh Where ID="+edit.tx, ObjupConnection);
ObjupConnection.Open();
Objupcommand.Parameters.AddWithValue(@"@cod", textcod.Text);
Objupcommand.Parameters.AddWithValue(@"@name", textname.Text);
Objupcommand.Parameters.AddWithValue(@"@ghkharid", mony.Text);
Objupcommand.Parameters.AddWithValue(@"@ghforosh", monyforosh.Text);
Objupcommand.Parameters.AddWithValue(@"@tedadkh", tedad.Text);
Objupcommand.ExecuteNonQuery();
ObjupConnection.Close();
اگه درسته پس چرا این ایراد می گیرد
Incorrect syntax near the keyword 'Set'.
'cod' is not a recognized SET option.
var Objupcommand = new SqlCommand("Update Set cod,Name,ghkharid,ghforosh,tedadkh Values @code,@Name,@ghkharid,@ghforosh,@tedadkh Where ID="+edit.tx, ObjupConnection);
ObjupConnection.Open();
Objupcommand.Parameters.AddWithValue(@"@cod", textcod.Text);
Objupcommand.Parameters.AddWithValue(@"@name", textname.Text);
Objupcommand.Parameters.AddWithValue(@"@ghkharid", mony.Text);
Objupcommand.Parameters.AddWithValue(@"@ghforosh", monyforosh.Text);
Objupcommand.Parameters.AddWithValue(@"@tedadkh", tedad.Text);
Objupcommand.ExecuteNonQuery();
ObjupConnection.Close();
اگه درسته پس چرا این ایراد می گیرد
Incorrect syntax near the keyword 'Set'.
'cod' is not a recognized SET option.