ado.net中的parameters

最新推荐文章于 2023-01-12 11:22:53 发布

aoxiang09

最新推荐文章于 2023-01-12 11:22:53 发布

阅读量802

点赞数

文章标签： parameters delete command string user sql

本文链接：https://blog.csdn.net/aoxiang09/article/details/393045

版权

Const STR_SQL_USER_DELETE As String = "DELETE FROM tblUser WHERE Id=@Id"
......

            ' Add Delete command parameters
            cmmUserDelete.Parameters.Add("@FirstName", SqlDbType.VarChar, 50, "FirstName")
            cmmUserDelete.Parameters.Add("@LastName", SqlDbType.VarChar, 50, "LastName")
            cmmUserDelete.Parameters.Add("@LoginName", SqlDbType.VarChar, 50, "LoginName")
            cmmUserDelete.Parameters.Add("@Password", SqlDbType.VarChar, 50, "Password")

prmSQLDelete = dadUserMan.DeleteCommand.Parameters.Add("@Id", SqlDbType.Int, Nothing, "Id")

为什么要 cmmUserDelete.Parameters.Add("@FirstName", SqlDbType.VarChar, 50, "FirstName")
            cmmUserDelete.Parameters.Add("@LastName", SqlDbType.VarChar, 50, "LastName")
            cmmUserDelete.Parameters.Add("@LoginName", SqlDbType.VarChar, 50, "LoginName")
            cmmUserDelete.Parameters.Add("@Password", SqlDbType.VarChar, 50, "Password")
帮我看看

我觉得是不必要的

能不能具体说说原因（需要或不需要）

先谢谢