C#绑定GridView后，分页效果不起作用
答案:1 悬赏:30 手机版
解决时间 2021-03-03 12:42
- 提问者网友：了了无期
- 2021-03-03 07:51
C#绑定GridView后，分页效果不起作用
最佳答案
- 五星知识达人网友：長槍戰八方
- 2021-03-03 08:46
string scon = ConfigurationManager.AppSettings["connertionstr"].ToString();
SqlConnection mycon = new SqlConnection(scon);
mycon.Open();
SqlCommand mycom = new SqlCommand(sqlselect, mycon);
SqlDataReader dr = mycom.ExecuteReader();
if (dr.Read()){mycon.Close();
mycon.Open();
SqlDataAdapter ds = new SqlDataAdapter(sqlselect, mycon);
DataSet dy = new DataSet();
DataTable dt = new DataTable();
l_number.Text = dt.Rows.Count.ToString();
ds.Fill(dy, "GoodsInformation");
GridView1.DataSource = dy.Tables["GoodsInformation"];
GridView1.DataBind();}}protected void gvGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{ //分页操作
SqlConnection mycon = new SqlConnection(scon);
mycon.Open();
SqlCommand mycom = new SqlCommand(sqlselect, mycon);
SqlDataReader dr = mycom.ExecuteReader();
if (dr.Read()){mycon.Close();
mycon.Open();
SqlDataAdapter ds = new SqlDataAdapter(sqlselect, mycon);
DataSet dy = new DataSet();
DataTable dt = new DataTable();
l_number.Text = dt.Rows.Count.ToString();
ds.Fill(dy, "GoodsInformation");
GridView1.DataSource = dy.Tables["GoodsInformation"];
GridView1.DataBind();}}protected void gvGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{ //分页操作
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯