SqlDataAdapter与存储过程

protected void Page_Load(object sender, EventArgs e)
    {
        //放置用户代码以初始化页面
        if (!Page.IsPostBack)
        {
            if (!object.Equals(Request.QueryString["BookId"], null))
            {
                //获取页面传递过来的图书id
                int book_id = Convert.ToInt32(Request.QueryString["BookId"]);
                //或取数据库连接字符串
                string strconn = ConfigurationManager.ConnectionStrings["connectionStr"].ToString();
                //连接数据库
                SqlConnection conn = new SqlConnection(strconn);
                conn.Open();
                //建立适配器对象,执行存储过程SearchBook
                SqlDataAdapter da = new SqlDataAdapter("SearchBook", conn);
                //设置执行sql命令的类型是存储过程
                da.SelectCommand.CommandType = CommandType.StoredProcedure;
                //为存储过程添加参数
                da.SelectCommand.Parameters.Add(new SqlParameter("@BookId", SqlDbType.Int));
                //为存储过程的参数赋值
                da.SelectCommand.Parameters["@BookId"].Value = book_id;
                //建立数据集对象
                DataSet ds = new DataSet();
                //填充数据集
                da.Fill(ds, "bookInfo");
                Repeater1.DataSource = ds.Tables["bookInfo"];
                Repeater1.DataBind();

 

            }
        }

转载于:https://www.cnblogs.com/gyweiUSTC/articles/1886470.html