farhad85
پنج شنبه 17 بهمن 1392, 23:14 عصر
سلام
دوستان من با کد زیر تما م تکس های از قبل ذخیره شده یک رکوردمو ویرایش میکنم حالا میخوام عکس همین رکوردو ویرایش کنم.ممنونم
Dim my_da4 As New SqlDataAdapter("Select * from moshakhasat", my_cn)
Dim my_ds4 As New DataSet
Dim my_cb4 As New SqlCommandBuilder(my_da4)
Dim my_cm4 As New SqlCommand("update moshakhasat set family=N'" & TextBox3.Text & "',code_meli=N'" & _
TextBox1.Text & "',name=N'" & TextBox2.Text & "',n_p=N'" & TextBox4.Text & _
"',sh_sh=N'" & TextBox5.Text & "',t_t=N'" & MaskedTextBox1.Text & "',m_sodur=N'" & _
TextBox6.Text & "',tahsilat=N'" & ComboBox1.Text & "',RESHTE=N'" & TextBox7.Text & _
"',SHOGHL=N'" & ComboBox2.Text & "',TAAHOL=N'" & ComboBox3.Text & "',T_KHANEVADE=N'" & _
TextBox8.Text & "',SOKUNAT=N'" & ComboBox4.Text & "',OSTAN=N'" & ComboBox5.Text & _
"',SHAHRESTAN=N'" & ComboBox6.Text & "',bakhsh=N'" & TextBox9.Text & "',dehestan=N'" & TextBox10.Text & _
"',rusta=N'" & TextBox11.Text & "',m_khadamat=N'" & TextBox12.Text & "',n_shora=N'" & TextBox13.Text & _
"',h_shora=N'" & TextBox14.Text & "',n_dehyar=N'" & TextBox15.Text & "',h_dehyar=N'" & TextBox16.Text & _
"',sh_hesab=N'" & TextBox17.Text & "',sh_cart=N'" & TextBox18.Text & "',h_keshavarz=N'" & TextBox19.Text & _
"',code_posti=N'" & TextBox20.Text & "',t_sabtename=N'" & MaskedTextBox2.Text & "',m_sabt=N'" & TextBox21.Text & _
"',email=N'" & TextBox22.Text & "',adres=N'" & TextBox23.Text & "',toz=N'" & TextBox24.Text & "' where code='" & TextBox36.Text & "'", my_cn)
my_cn.Open()
my_cm4.ExecuteNonQuery()
my_da4.Fill(my_ds4, "moshakhasat")
DataGridView1.DataSource = (my_ds4)
DataGridView1.DataMember = "moshakhasat"
my_cn.Close()
دوستان من با کد زیر تما م تکس های از قبل ذخیره شده یک رکوردمو ویرایش میکنم حالا میخوام عکس همین رکوردو ویرایش کنم.ممنونم
Dim my_da4 As New SqlDataAdapter("Select * from moshakhasat", my_cn)
Dim my_ds4 As New DataSet
Dim my_cb4 As New SqlCommandBuilder(my_da4)
Dim my_cm4 As New SqlCommand("update moshakhasat set family=N'" & TextBox3.Text & "',code_meli=N'" & _
TextBox1.Text & "',name=N'" & TextBox2.Text & "',n_p=N'" & TextBox4.Text & _
"',sh_sh=N'" & TextBox5.Text & "',t_t=N'" & MaskedTextBox1.Text & "',m_sodur=N'" & _
TextBox6.Text & "',tahsilat=N'" & ComboBox1.Text & "',RESHTE=N'" & TextBox7.Text & _
"',SHOGHL=N'" & ComboBox2.Text & "',TAAHOL=N'" & ComboBox3.Text & "',T_KHANEVADE=N'" & _
TextBox8.Text & "',SOKUNAT=N'" & ComboBox4.Text & "',OSTAN=N'" & ComboBox5.Text & _
"',SHAHRESTAN=N'" & ComboBox6.Text & "',bakhsh=N'" & TextBox9.Text & "',dehestan=N'" & TextBox10.Text & _
"',rusta=N'" & TextBox11.Text & "',m_khadamat=N'" & TextBox12.Text & "',n_shora=N'" & TextBox13.Text & _
"',h_shora=N'" & TextBox14.Text & "',n_dehyar=N'" & TextBox15.Text & "',h_dehyar=N'" & TextBox16.Text & _
"',sh_hesab=N'" & TextBox17.Text & "',sh_cart=N'" & TextBox18.Text & "',h_keshavarz=N'" & TextBox19.Text & _
"',code_posti=N'" & TextBox20.Text & "',t_sabtename=N'" & MaskedTextBox2.Text & "',m_sabt=N'" & TextBox21.Text & _
"',email=N'" & TextBox22.Text & "',adres=N'" & TextBox23.Text & "',toz=N'" & TextBox24.Text & "' where code='" & TextBox36.Text & "'", my_cn)
my_cn.Open()
my_cm4.ExecuteNonQuery()
my_da4.Fill(my_ds4, "moshakhasat")
DataGridView1.DataSource = (my_ds4)
DataGridView1.DataMember = "moshakhasat"
my_cn.Close()