C#中调用SQL存储过程实现登录认证代码

存储过程如下：

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() ;

       &