ASP.NET 调用存储过程 【小试牛刀】

 

  /// <summary>
        /// 使用存储过程
        /// </summary>
        /// <param name="userid"></param>
        /// <returns></returns>
        public DataSet GetDataSet1(string userid)
        {
            Open();
            SqlCommand selectcmd = new SqlCommand();
            selectcmd.Connection = Connection;
            selectcmd.CommandType = CommandType.StoredProcedure;
            selectcmd.CommandText = "sss_user";
            SqlParameter param = new SqlParameter("@userid", SqlDbType.VarChar, 40);
            //selectcmd.Parameters.Add("@userid", SqlDbType.VarChar, 40, "UserID");
            param.Direction = ParameterDirection.Input;//输入参数
            param.Value = userid;
            selectcmd.Parameters.Add(param);
            SqlDataAdapter adapter = new SqlDataAdapter();
            adapter.SelectCommand = selectcmd;
            DataSet dataSet = new DataSet();
            adapter.Fill(dataSet);
            Close();
            return dataSet;
        }
      

 

调用上面的GetDataSet1方法，

public void LoadData1(string userId)
        {
            DataBase db = new DataBase();
            DataSet dataset = db.GetDataSet1(userId);
            if (dataset.Tables[0].Rows.Count > 0)
            {
                this.userId = dataset.Tables[0].Rows[0]["UserID"].ToString();
                this.c_name = dataset.Tables[0].Rows[0]["C_Name"].ToString();
                this.e_name = dataset.Tables[0].Rows[0]["E_Name"].ToString();
                this.updateTime = dataset.Tables[0].Rows[0]["UpdataDate"].ToString();
                this.qq = dataset.Tables[0].Rows[0]["QQ"].ToString();
            }
        }

 

 

自己建的一个小的存储过程

create proc sss_user
(
 @userid  varchar(40)
)
AS
BEGIN
 select * from Demo_User where UserID = @userid
END