booksearchresult.aspx.cs

一个使用ASP。net和SQLServer2005开发的图书管理系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MyLibrary.BusinessLogicLayer;
using MyLibrary.DataAccessLayer;
using System.Data.SqlClient;

public partial class BookManage_BookSearchResult : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            GridViewBind();
        }
    }
//查询数据，绑定到GridView控件
    private void GridViewBind()
    {
        SqlParameter[] Params = new SqlParameter[4];
        DataBase DB = new DataBase();
        Params[0] = DB.MakeInParam("@Classify", SqlDbType.VarChar, 50, Session["Classify"].ToString());       //分类
        Params[1] = DB.MakeInParam("@Type", SqlDbType.VarChar, 50, Session["Type"].ToString());               //字段名
        Params[2] = DB.MakeInParam("@Content", SqlDbType.VarChar, 50, Session["Content"].ToString());         //字段值
        Params[3] = DB.MakeInParam("@Mode", SqlDbType.Int, 4, int.Parse(Session["Mode"].ToString()));         //查询模式   

        DataSet ds = DB.GetDataSet("Proc_BookConditionQuery", Params);
        ds.CaseSensitive = false;
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
}