存储过程如下：
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER
procedure [dbo].[security_check](@user_sort int,@userID nchar(16),@userPWD nchar(16) )
as
declare @uid nchar(16);
declare @pwd nchar(16);
declare @state bit;
set @state=0;
if( @user_sort=1)
begin 
     declare  cursor_temp cursor local for   --定义游标
               select 学号,密码   from 学生表  where 学号 = @userID and 密码 = @userPWD;  
     open cursor_temp;      --打开游标
      fetch cursor_temp into @uid,@pwd;    --推进游标
      close cursor_temp;                   --关闭游标
 end
if( @uid =@userID and @pwd=@userPWD )
        begin
                set @state=1; 
                return @state;
        end;
else
        begin
        set @state=0;
        return @state;
end;                 
----------------------------------------------------------------------------------------------------------------------------------------------
C#代码如下：
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace 密码验证
{
    class security
    {
        public static DataSet  check(string uid)
        {
            SqlConnection mySqlConnection = new SqlConnection("server=.\SqlExpress;database=XSXK;integrated security=SSPI");
            mySqlConnection.Open();
            SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
            mySqlCommand.CommandText = "select * from 学生表 where 学号 =" + uid;
            SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();
            DataSet myDataSet = new DataSet() ;
       &