saeedhushmand
دوشنبه 02 آبان 1390, 18:12 عصر
وقتی برای اطلاعات توی grid view یک tab ویرایش می زارم وقتی button ویرایش میزنه ستون مورد نظر ویرایش می شه ولی ستون های دیگه رو هم تغییر میده و همه ستون ها مثل هم میشن
اینم کدم ...
SqlConnection myConn;
SqlCommand myComm;
StrConn = "SERVER=.;DATABASE=laberator;Integrated Security=True";
StrQury = "Update docter Set [code docter]=@code,[name docter]=@name,tarefe=@address,telephone1=@telephone,telep hone2=@telephone2,mobile=@mobile,address=@A,toziha t=@tozihat";
myConn = new SqlConnection(StrConn);
myComm = new SqlCommand();
myComm.Connection = myConn;
myComm.CommandType = CommandType.Text;
myComm.CommandText = StrQury;
myComm.Parameters.Add("code ", SqlDbType.NVarChar, 50).Value = this.textBox15.Text;
myComm.Parameters.Add("address", SqlDbType.NVarChar, 50).Value = this.comboBox4.Text;
myComm.Parameters.Add("name", SqlDbType.NVarChar, 50).Value = this.textBox17.Text;
myComm.Parameters.Add("telephone", SqlDbType.NVarChar, 50).Value = this.textBox18.Text;
myComm.Parameters.Add("telephone2", SqlDbType.NVarChar, 50).Value = this.textBox19.Text;
myComm.Parameters.Add("mobile", SqlDbType.NVarChar, 50).Value = this.textBox20.Text;
myComm.Parameters.Add("tozihat", SqlDbType.NVarChar, 50).Value = this.textBox22.Text;
myComm.Parameters.Add("A", SqlDbType.NVarChar, 50).Value = this.textBox21.Text;
myConn.Open();
myComm.ExecuteNonQuery();
myConn.Close();
show1();
textBox15.Text = ""; textBox17.Text = ""; textBox18.Text = ""; textBox19.Text = "";
textBox20.Text = ""; textBox21.Text = ""; textBox22.Text = ""; comboBox4.Text = "";
groupBox1.Enabled = false;
textBox15.Text = "";
textBox15.Focus();
MessageBox.Show("ویرایش اطلاعات با موفقیت انجام شد", "ویرایش اطلاعات ");
}
private void show1()
{
SqlDataAdapter myDA;
DataSet myDS;
StrConn = "SERVER=.;DATABASE=laberator;Integrated Security=True";
StrQury = "Select * From docter";
myDA = new SqlDataAdapter(StrQury, StrConn);
myDS = new DataSet();
myDA.Fill(myDS, "docter");
this.dataGridView1.DataSource = myDS;
this.dataGridView1.DataMember = "docter";
this.dataGridView1.AutoGenerateColumns = true;
this.dataGridView1.RightToLeft = RightToLeft.Yes;
this.dataGridView1.Refresh();
اینم کدم ...
SqlConnection myConn;
SqlCommand myComm;
StrConn = "SERVER=.;DATABASE=laberator;Integrated Security=True";
StrQury = "Update docter Set [code docter]=@code,[name docter]=@name,tarefe=@address,telephone1=@telephone,telep hone2=@telephone2,mobile=@mobile,address=@A,toziha t=@tozihat";
myConn = new SqlConnection(StrConn);
myComm = new SqlCommand();
myComm.Connection = myConn;
myComm.CommandType = CommandType.Text;
myComm.CommandText = StrQury;
myComm.Parameters.Add("code ", SqlDbType.NVarChar, 50).Value = this.textBox15.Text;
myComm.Parameters.Add("address", SqlDbType.NVarChar, 50).Value = this.comboBox4.Text;
myComm.Parameters.Add("name", SqlDbType.NVarChar, 50).Value = this.textBox17.Text;
myComm.Parameters.Add("telephone", SqlDbType.NVarChar, 50).Value = this.textBox18.Text;
myComm.Parameters.Add("telephone2", SqlDbType.NVarChar, 50).Value = this.textBox19.Text;
myComm.Parameters.Add("mobile", SqlDbType.NVarChar, 50).Value = this.textBox20.Text;
myComm.Parameters.Add("tozihat", SqlDbType.NVarChar, 50).Value = this.textBox22.Text;
myComm.Parameters.Add("A", SqlDbType.NVarChar, 50).Value = this.textBox21.Text;
myConn.Open();
myComm.ExecuteNonQuery();
myConn.Close();
show1();
textBox15.Text = ""; textBox17.Text = ""; textBox18.Text = ""; textBox19.Text = "";
textBox20.Text = ""; textBox21.Text = ""; textBox22.Text = ""; comboBox4.Text = "";
groupBox1.Enabled = false;
textBox15.Text = "";
textBox15.Focus();
MessageBox.Show("ویرایش اطلاعات با موفقیت انجام شد", "ویرایش اطلاعات ");
}
private void show1()
{
SqlDataAdapter myDA;
DataSet myDS;
StrConn = "SERVER=.;DATABASE=laberator;Integrated Security=True";
StrQury = "Select * From docter";
myDA = new SqlDataAdapter(StrQury, StrConn);
myDS = new DataSet();
myDA.Fill(myDS, "docter");
this.dataGridView1.DataSource = myDS;
this.dataGridView1.DataMember = "docter";
this.dataGridView1.AutoGenerateColumns = true;
this.dataGridView1.RightToLeft = RightToLeft.Yes;
this.dataGridView1.Refresh();