behnam.m
سه شنبه 03 خرداد 1390, 15:38 عصر
سلام
از این تکه کد پایین این خطا ظاهر میشود .' )' Incorrect syntax near
private void btnEdit_Click(object sender, EventArgs e)
{
SqlCommand c1 = new SqlCommand();
c1.CommandText = "UPDATE phonBook SET (Name = @p2,Family= @p3, Address= @p4)";
c1.CommandType = CommandType.Text;
c1.Connection = conn;
c1.Parameters.AddWithValue("p2", txtname.Text);
c1.Parameters.AddWithValue("p3", txtfamily.Text);
c1.Parameters.AddWithValue("p4", txtaddress.Text);
c1.ExecuteNonQuery();
setbinding("");
}
لطفا کمکم کنید
از این تکه کد پایین این خطا ظاهر میشود .' )' Incorrect syntax near
private void btnEdit_Click(object sender, EventArgs e)
{
SqlCommand c1 = new SqlCommand();
c1.CommandText = "UPDATE phonBook SET (Name = @p2,Family= @p3, Address= @p4)";
c1.CommandType = CommandType.Text;
c1.Connection = conn;
c1.Parameters.AddWithValue("p2", txtname.Text);
c1.Parameters.AddWithValue("p3", txtfamily.Text);
c1.Parameters.AddWithValue("p4", txtaddress.Text);
c1.ExecuteNonQuery();
setbinding("");
}
لطفا کمکم کنید