public
partial
class
Controls_UserControl : System.Web.UI.UserControl
... {
protected void Page_Load(object sender, EventArgs e)
...{
gopagecount(1);
}
protected void gopagecount(int nowpagecount)
...{
CDAL dal1 = new CDAL();
DataSet ds1 = new DataSet();
int count1 = nowpagecount * 10+1;
int count2 = (nowpagecount - 1)*10;
string sql1 = "select a.employeeno,a.employeename,Identity(int,1,1) as pagecount into temptable1 from tblsysusersecurity as a where employeeno like 'F%'";
string sql2 = "select * from temptable1 where pagecount<"+count1+" and pagecount>"+count2;
string sql3 = "drop table temptable1";
string sql4 = sql1 + ";" + sql2 + ";" + sql3;
ds1 = dal1.ExecDataset(sql4);
GridView dg = (GridView)Parent.FindControl("GridView1");
dg.DataSource = ds1.Tables[0];
dg.DataBind();
}
protected void Button5_Click(object sender, EventArgs e)
...{
string str1 = TextBox1.Text.Trim();
int pagecount = Convert.ToInt32(str1);
gopagecount(pagecount);
}
}
... {
protected void Page_Load(object sender, EventArgs e)
...{
gopagecount(1);
}
protected void gopagecount(int nowpagecount)
...{
CDAL dal1 = new CDAL();
DataSet ds1 = new DataSet();
int count1 = nowpagecount * 10+1;
int count2 = (nowpagecount - 1)*10;
string sql1 = "select a.employeeno,a.employeename,Identity(int,1,1) as pagecount into temptable1 from tblsysusersecurity as a where employeeno like 'F%'";
string sql2 = "select * from temptable1 where pagecount<"+count1+" and pagecount>"+count2;
string sql3 = "drop table temptable1";
string sql4 = sql1 + ";" + sql2 + ";" + sql3;
ds1 = dal1.ExecDataset(sql4);
GridView dg = (GridView)Parent.FindControl("GridView1");
dg.DataSource = ds1.Tables[0];
dg.DataBind();
}
protected void Button5_Click(object sender, EventArgs e)
...{
string str1 = TextBox1.Text.Trim();
int pagecount = Convert.ToInt32(str1);
gopagecount(pagecount);
}
}