编辑“︁C Sharp 存储过程调用”︁（章节）

=== 用户登录验证 ===
创建存储过程：
<syntaxhighlight lang="sql">
CREATE PROCEDURE usp_ValidateLogin
    @Username NVARCHAR(50),
    @Password NVARCHAR(50),
    @IsValid BIT OUTPUT
AS
BEGIN
    IF EXISTS (SELECT 1 FROM Users WHERE Username = @Username AND Password = HASHBYTES('SHA2_256', @Password))
        SET @IsValid = 1
    ELSE
        SET @IsValid = 0
END
</syntaxhighlight>

C#调用代码：
<syntaxhighlight lang="csharp">
bool ValidateUser(string username, string password)
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        SqlCommand command = new SqlCommand("usp_ValidateLogin", connection);
        command.CommandType = CommandType.StoredProcedure;
        
        command.Parameters.AddWithValue("@Username", username);
        command.Parameters.AddWithValue("@Password", password);
        
        SqlParameter isValidParam = new SqlParameter("@IsValid", SqlDbType.Bit);
        isValidParam.Direction = ParameterDirection.Output;
        command.Parameters.Add(isValidParam);
        
        connection.Open();
        command.ExecuteNonQuery();
        
        return (bool)isValidParam.Value;
    }
}
</syntaxhighlight>