کد update

[soniarose]

سلام ممکنه کسی کد update رو کامل برام بزاره ممنون

[shocraneh]

dim cn As New SqlClient.SqlConnection
dim cmd As New SqlClient.SqlCommand
cmd.connection= cn
cmd.CommandText = "update ostad set codeostad =@t1 , name =@t2 , famili =@t3,list=@t5 where codeostad='" + DataGridViewX1.CurrentRow.Cells(0).Value.ToString. Trim + "'"
cmd.Parameters.AddWithValue("@t1", TextBox1.Text)
cmd.Parameters.AddWithValue("@t2", Me.TextBox2.Text)
cmd.Parameters.AddWithValue("@t3", Me.TextBox3.Text)
'cmd.Parameters.AddWithValue("@t4", start.Trim)
cmd.Parameters.AddWithValue("@t5", list.Trim)
cmd.ExecuteNonQuery()