1、shiyusingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.Ul.WebControls;usingSystem.Web.Ul.WebControls.WebParts;usingSystem.Web.Ul.HtmIControls;usingSystem.Data.SqlClient;usingSystemO;publicpartialc

2、lassGridView:System.Web.Ul.PageprotectedstringconnString=ConfigurationSettings.AppSettings"Connectionstring"protectedintrowCount=0;protectedintpageCount=0;protectedintpageSize=0;protectedintpageNow=0;protectedvoidPage_Load(objectsender,EventArgse)if(!Page.lsPostBack)/connString=Configurati

3、onSettings.AppSettings"ConnectionString"/獲取記錄的總條數(shù)SqlConnectioncon=newSqlConnection();con.ConnectionString=connString;con.Open();SqlCommandcmd=newSqlCommand();修改其中的數(shù)據(jù)表名稱修改其中的數(shù)據(jù)表名稱*cmd.CommandText="selectcount(*)fromBMSK_GB"cmd.Connection=con;rowCount=Convert.Tolnt32(cmd.ExecuteSca

4、lar();con.Close();/設(shè)置和獲取每頁顯示幾條記錄DropDownList1.Items.Clear();for(inti=1;i<=rowCount;i+)DropDownList1.ltems.Add(i.ToString();if(rowCount<5)DropDownListl.Selectedlndex=rowCount-1;elseDropDownList1.SelectedIndex=4;pageSize=Convert.Tolnt32(DropDownList1.SelectedValue);if(rowCount%pageSize)=0)pageCo

5、unt=Convert.ToInt32(rowCount/pageSize);elsepageCount=Convert.ToInt32(rowCount/pageSize)+1;/獲取跳轉(zhuǎn)到哪一頁的信息DropDownList2tems.Clear();for(intj=1;j<=pageCount;j+)DropDownList2.ltems.Add(j.ToString();Label1.Text=rowCount.ToString();Label3.Text=pageCount.ToString();/保存控件數(shù)據(jù)ViewState"RowCount"=row

6、Count;ViewState"PageSize"=pageSize;ViewState"PageCount"=pageCount;當前頁pageNow=1;ViewState"PageNow"=pageNow;rowCount=Convert.ToInt32(ViewState"RowCount");pageCount=Convert.ToInt32(ViewState"PageCount");pageSize=Convert.ToInt32(ViewState"PageSize&q

7、uot;);pageNow=Convert.ToInt32(ViewState"PageNow");if(pageCount<0|rowCount<0)Response.Write("發(fā)生錯誤");Response.End();if(pageNow<=1)pageNow=1;btnFirst.Enabled=false;btnPrevious.Enabled=false;Label2.Text=pageNow.ToString();if(!Page.lsPostBack)BindData();/進行數(shù)據(jù)綁定publicvoidBindD

8、ata()類型,SFWXas是否危險fromBMSK_GB"/*彳修改其中的數(shù)據(jù)表名*Stringsql="selectSKBMas水庫編碼,SKMCas水庫名稱,SZSas所在市,SZXas所在縣,LXasSqlConnectioncon=newSqlConnection();con.ConnectionString=connString;con.Open();SqlDataAdapterda=newSqlDataAdapter(sql,con);DataSetds=newDataSet();修改其中的數(shù)據(jù)表名稱*da.Fill(ds,(pageNow-1)*pageSi

9、ze,pageSize,"BMSK_GB");GridViewl.DataSource=ds;GridView1.DataBind();ds.Clear();con.Close();Label2.Text=pageNow.ToString();protectedvoidDropDownList1_SelectedlndexChanged(objectsender,EventArgse)pageSize=Convert.ToInt32(DropDownList1.SelectedValue);if(Convert.Tolnt32(rowCount%pageSize)=0)pa

10、geCount=Convert.ToInt32(rowCount/pageSize);elsepageCount=Convert.ToInt32(rowCount/pageSize);DropDownList2tems.Clear();for(inti=1;i<=pageCount;i+)DropDownList2.ltems.Add(i.ToString();Label3.Text=pageCount.ToString();ViewState"PageSize"=pageSize;ViewState"PageCount"=pageCount;if

11、(pageNow>pageCount)pageNow=1;ViewState"PageNow"=pageNow.ToString();btnFirst.Enabled=true;btnPrevious.Enabled=true;btnNext.Enabled=true;btnLast.Enabled=true;if(pageNow=1)btnFirst.Enabled=false;btnPrevious.Enabled=false;if(pageNow=pageCount)btnNext.Enabled=false;btnLast.Enabled=false;Bind

12、Data();protectedvoidDropDownList2_SelectedlndexChanged(objectsender,EventArgse)pageNow=Convert.ToInt32(DropDownList2.SelectedValue);ViewState"PageNow"=pageNow.ToString();BindData();顯示第一頁privatevoidmoveFirst()pageNow=1;ViewState"PageNow"=pageNow.ToString();BindData();btnFirst.Enab

13、led=false;btnPrevious.Enabled=false;btnNext.Enabled=true;btnLast.Enabled=true;/顯示上一頁privatevoidmovePrevious()pageNow=pageNow-1;ViewState"PageNow"=pageNow.ToString();BindData();if(pageNow=1)btnFirst.Enabled=false;btnPrevious.Enabled=false;btnNext.Enabled=true;btnLast.Enabled=true;/顯示下一頁priv

14、atevoidmoveNext()pageNow=pageNow+1;ViewState"PageNow"=pageNow.ToString();BindData();btnFirst.Enabled=true;btnPrevious.Enabled=true;if(pageNow=pageCount)btnNext.Enabled=false;btnLast.Enabled=false;/顯示尾頁privatevoidmoveLast()pageNow=pageCount;ViewState"PageNow"=pageNow.ToString();Bi

15、ndData();btnFirst.Enabled=true;btnPrevious.Enabled=true;btnNext.Enabled=false;btnLast.Enabled=false;protectedvoidbtnFirst_Click(objectsender,EventArgse)moveFirst();protectedvoidbtnPrevious_Click(objectsender,EventArgse)movePrevious();protectedvoidbtnNext_Click(objectsender,EventArgse)moveNext();prot

16、ectedvoidbtnLast_Click(objectsender,EventArgse)moveLast();/將頁面數(shù)據(jù)導出到excel表格中去publicvoidExportToExcel(stringFileType,stringFileName)Response.Charset="GB2312"Response.ContentEncoding=System.Text.Encoding.Default;Response.AppendHeader('Content-Disposition","attachment;filename=&q

17、uot;HttpUtility.UrlEncode(FileName,System.Text.Encoding.UTF8).ToString();Response.ContentType=FileType;this.EnableViewState=false;StringWritertw=newStringWriter();HtmlTextWriterhw=newHtmlTextWriter(tw);GridView1.RenderControl(hw);Response.Write(tw.ToString();Response.End();/導出到ExcelprotectedvoidbtnE

18、xport_Click(objectsender,EventArgse)ExportToExcel("application/ms-excel"，"水庫信息.xls");/這個事件必須加publicoverridevoidVerifyRenderingInServerForm(Controlcontrol)/base.VerifyRenderinglnServerForm(control);/導出到WordprotectedvoidbtnWord_Click(objectsender,EventArgse)ExportToExcel("appl

19、ication/ms-word","水庫信息.doc");-iaix|蠢丈件冊NWJ找團叩牯式如）工jl怕碗護它口叩刪I同堆調(diào)査）觀驟肖產(chǎn)_晞犧剛I-#XJ2»/晁電ZJllMAtJEii”的鈔：w.'*廚生正丈”禾訃五宅回旦”疋、住畫壬隹”|扌三”三*主主時”山-AXfJC,G=id巾“巾令貝砂岀苗搭dr-r>G=id巾“巾令貝砂岀苗搭dr-r>11碼所在市»aa類璋«te腎ODOOISUjt000002廈于;IttUlLD00003肖山iE：LQD0D04畫洪甸穴安鉢1Q00005瀕口Wt042I*魚函”y自誼團形0、口應(yīng)呻聞國二！業(yè)”三蘭斗.甲頁國.1亦IMfl.L/1ir.L4UL=