天天看点

ado.net中的parameters

 Const STR_SQL_USER_DELETE As String = "DELETE FROM tblUser WHERE [email protected]"

......

            ' 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")

帮我看看

我觉得是不必要的

能不能具体说说原因(需要或不需要)

先谢谢