cmdtext = "update emp1 set name=@name,[phone]=@phone,city=@city where [no]=@no"
cmd = New SqlCommand(cmdtext, cn)
cmd.Parameters.Add(New SqlParameter("@no", TextBox1.Text))
cmd.Parameters.Add(New SqlParameter("@name", TextBox2.Text))
cmd.Parameters.Add(New SqlParameter("@phone", TextBox3.Text))
cmd.Parameters.Add(New SqlParameter("@city", TextBox4.Text))
cmd.ExecuteNonQuery()
cmdtext = "delete from emp1 where [no]=@no"
cmd = New SqlCommand(cmdtext, cn)
cmd.Parameters.Add(New SqlParameter("@no", TextBox1.Text))
cmd.ExecuteNonQuery()