手动绑定SQLDataSource到GridView后分页的问题

转载

沐雪编程人生 2022-08-22 11:57:52 博主文章分类：Asp.net

由于GridView的数据源是后台CS文件中代码绑定的。所以程序运行时，点击分页数后没有反应。解决办法如下：

using System;
using System.Data;
using System.Configuration;
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 System.Data.SqlClient;public partial class _Default : System.Web.UI.Page 
{
    SqlDataSource source = new SqlDataSource();    protected void Page_Load(object sender, EventArgs e)
    {    }
    private void DBind()
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConfigurationManager.ConnectionStrings["TransportConnectionString"].ConnectionString;
        source.ConnectionString = ConfigurationManager.ConnectionStrings["TransportConnectionString"].ConnectionString;
        string sql = "SELECT * from Customer where id<>'' ";        if (this.客户名称.Text != "")
        {
            sql = sql + " and 客户编码 LIKE '%" + this.客户名称.Text + "%' ";
        }
        source.SelectCommand = sql;
        GridView1.DataSourceID = "";
        GridView1.DataSource = "";
        GridView1.DataSource = source;
        GridView1.DataBind();  
    }
    
    
    protected void SearchButton_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConfigurationManager.ConnectionStrings["TransportConnectionString"].ConnectionString;
        source.ConnectionString = ConfigurationManager.ConnectionStrings["TransportConnectionString"].ConnectionString;
        string sql = "SELECT * from Customer where id<>'' ";        if (this.客户名称.Text != "")
        {
            sql = sql + " and 客户编码 LIKE '%" + this.客户名称.Text + "%' ";
        }
        source.SelectCommand = sql;
        GridView1.DataSourceID = "";
        GridView1.DataSource = "";
        GridView1.DataSource = source;
        GridView1.DataBind(); 
    } protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex=e.NewPageIndex;
        DBind();
    }
}