更新和删除参数查询 [英] update and delete parameter query

问题描述

以下是插入查询，我想更新和删除参数查询..

following is the insert query ,i want update and delete parameter query..

Dim cmdtext As String
        cmdtext = "insert into emp1([no],name,[phone],city) values (@no,@name,@phone,@city)"
        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 = "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()

这篇关于更新和删除参数查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！