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

nbsp;    mySqlDataAdapter.SelectCommand = mySqlCommand  ;
           
            mySqlDataAdapter.Fill (myDataSet ,"学生表");

            mySqlConnection.Close();

            return myDataSet;

        }

        public static bool secuirty_check(int user_select, string uid, string pwd)
        {
            int result = 0;
          
            SqlConnection mySqlConnection = new SqlConnection("server=.\\SqlExpress;database=XSXK;integrated security=SSPI");

            SqlCommand mySqlCommand = new SqlCommand( "security_check",mySqlConnection );

            mySqlCommand.CommandType = CommandType.StoredProcedure;

            //-----------------------------------------//关键部分！！ ----------------------------------------

            SqlParameter param = new SqlParameter(); 

            param.Direction = System.Data.ParameterDirection.ReturnValue;

            mySqlCommand.Parameters.Add(param);   
    
            //------------------------------------------------------------------------------------------------
            mySqlCommand.Parameters.Add( "@user_sort",SqlDbType .Int ).Value = user_select ;

            mySqlCommand.Parameters.Add("@userID",SqlDbType.NChar ,16 ).Value = uid ;

            mySqlCommand.Parameters.Add("@userPWD",SqlDbType.NChar,16 ).Value = pwd ;

            //mySqlCommand.Parameters["@state"].Direction = ParameterDirection.ReturnValue ;

            mySqlConnection.Open();

            mySqlCommand.ExecuteScalar();
           
            mySqlConnection.Close();