cmd.Parameters["@TBName"].Value = strTBName; try {
using(SqlDataAdapter ad = new SqlDataAdapter(cmd)) {
DataSet ds = new DataSet(); ad.Fill(ds);
dg.DataSource = ds.Tables[0].DefaultView; dg.DataBind(); } }
catch(Exception Error) {
string strError = Error.ToString(); } finally {
if( con != null || con.State == ConnectionState.Open ) { con.Close(); } }
lblPaging.Text = GetlblPagingBind(Request.QueryString["Page"],parameterPageCount.Value.ToString()); }
public string GetlblPagingBind(string strParameter,string strPageCount) {
string strPage = string.Empty;
if( strParameter == null ) { strPage = "1"; } else
{ strPage = strParameter; }
//设置页码
string strPageBar="";
if (dg.AllowPaging.ToString() == "False" ) {
strPageBar+="<nobr>\n";
strPageBar+="[当前页]:"+(int.Parse(strPage)).ToString()+"/"+strPageCount+" \n";
if (strPage == "1") {
14 / 19