bookquery.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class bookquery : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            DataBind();
        }
    }
    public void DataBind()
    {
        DataSet ds = new DataSet();
        using (SqlConnection sqlconn = DB.con())
        {
            SqlDataAdapter sqld = new SqlDataAdapter("select * from book order by beijie desc", sqlconn);
            sqld.Fill(ds);
        }

        string[] key = { "no" };
        gvbook.DataKeyNames = key;
        //GridView绑定数据源
        gvbook.DataSource = ds.Tables[0].DefaultView;//指定GridView的数据源
        gvbook.DataBind();
    }
    protected void gvbook_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvbook.PageIndex = e.NewPageIndex;
        DataBind();
    }
    protected void btnselect_Click(object sender, EventArgs e)
    {
        int i = dro1.SelectedIndex;
        if (i == 0)
        {
            if (txtselect.Text == "")
            {
                DataBind();
            }
            else
            {
                DataSet ds = new DataSet();
                using (SqlConnection sqlconn = DB.con())
                {
                    SqlDataAdapter sqld = new SqlDataAdapter("select * from book where no='" + txtselect.Text + "' order by beijie desc", sqlconn);
                    sqld.Fill(ds);
                }

                string[] key = { "no" };
                gvbook.DataKeyNames = key;
                //GridView绑定数据源
                gvbook.DataSource = ds.Tables[0].DefaultView;//指定GridView的数据源