omidparkour
سه شنبه 06 خرداد 1393, 16:51 عصر
سلامدستور زیر رو برای آپدیت کردن نوشتم اما ارور میدهمشکل چیه؟؟
SqlConnection objcon = new SqlConnection();
objcon.ConnectionString = "data source=localhost;initial catalog=Restaurant;integrated security=true";
SqlCommand objcom = new SqlCommand();
objcom.Connection = objcon;
objcom.Parameters.AddWithValue("@ChefCode", textBox1.Text);
objcom.Parameters.AddWithValue("@Name", textBox2.Text);
objcom.Parameters.AddWithValue("@Fname", textBox3.Text);
objcom.Parameters.AddWithValue("@FatherName", textBox4.Text);
objcom.Parameters.AddWithValue("@Shsh", textBox5.Text);
objcom.Parameters.AddWithValue("@Tt", textBox6.Text);
objcom.Parameters.AddWithValue("@WorkExperiense", textBox7.Text);
objcom.Parameters.AddWithValue("@Salary", textBox8.Text);
objcom.Parameters.AddWithValue("@Tel", textBox9.Text);
objcom.Parameters.AddWithValue("@TelMob", textBox10.Text);
objcom.Parameters.AddWithValue("@Address", textBox11.Text);
objcom.CommandText = "update Chef Set Name=@Name And Fname=@Fname And FatherName=@FatherNamer And Shsh=@Shsh And Tt=@Tt And WorkExperiense=@WorkExperiense And Salary=@Salary And Tel=@Tel And TelMob=@TelMob And Address=@Address where ChefCode=@ChefCode";
objcon.Open();
objcom.ExecuteNonQuery();
objcon.Close();
MessageBox.Show("ویرایش اطلاعات با موفقیت انجام شد.");
SqlConnection objcon = new SqlConnection();
objcon.ConnectionString = "data source=localhost;initial catalog=Restaurant;integrated security=true";
SqlCommand objcom = new SqlCommand();
objcom.Connection = objcon;
objcom.Parameters.AddWithValue("@ChefCode", textBox1.Text);
objcom.Parameters.AddWithValue("@Name", textBox2.Text);
objcom.Parameters.AddWithValue("@Fname", textBox3.Text);
objcom.Parameters.AddWithValue("@FatherName", textBox4.Text);
objcom.Parameters.AddWithValue("@Shsh", textBox5.Text);
objcom.Parameters.AddWithValue("@Tt", textBox6.Text);
objcom.Parameters.AddWithValue("@WorkExperiense", textBox7.Text);
objcom.Parameters.AddWithValue("@Salary", textBox8.Text);
objcom.Parameters.AddWithValue("@Tel", textBox9.Text);
objcom.Parameters.AddWithValue("@TelMob", textBox10.Text);
objcom.Parameters.AddWithValue("@Address", textBox11.Text);
objcom.CommandText = "update Chef Set Name=@Name And Fname=@Fname And FatherName=@FatherNamer And Shsh=@Shsh And Tt=@Tt And WorkExperiense=@WorkExperiense And Salary=@Salary And Tel=@Tel And TelMob=@TelMob And Address=@Address where ChefCode=@ChefCode";
objcon.Open();
objcom.ExecuteNonQuery();
objcon.Close();
MessageBox.Show("ویرایش اطلاعات با موفقیت انجام شد.");