GridView 分页导航

// 计算生成分页页码,分别为："首 页" "上一页" "下一页" "尾 页"
btnFirst.CommandName = "1";
btnPrev.CommandName = (GridView1.PageIndex == 0 ? "1" : GridView1.PageIndex.ToString());

btnNext.CommandName = (GridView1.PageCount == 1 ? GridView1.PageCount.ToString() : (GridView1.PageIndex 2).ToString());
btnLast.CommandName = GridView1.PageCount.ToString();
//

this.ddlCurrentPage.Items.Clear();
for (int i = 1; i <= this.GridView1.PageCount; i )
...{
this.ddlCurrentPage.Items.Add(i.ToString());
}
this.ddlCurrentPage.SelectedIndex = this.GridView1.PageIndex;

}
catch (Exception ex)
...{
Response.Write("数据库错误，错误原因：" ex.Message);
Response.End();
}
}
protected void PagerButtonClick(object sender, EventArgs e)
...{
GridView1.PageIndex = Convert.ToInt32(((LinkButton)sender).CommandName) - 1;
GridViewBind("");
}

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
...{
e.Row.Attributes["onmouseover"] = "ItemOver(this)";
}

protected void Button1_Click(object sender, EventArgs e)
...{
Response.Write(Request.Form.Get("RadioName"));
}
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
...{
string sql = "";

if (ViewState["DataConnectionString"] == null || ViewState["DataConnectionString"].ToString().CompareTo("") == 0)
...{
ViewState["DataConnectionString"] = " desc";
}
else
ViewState["DataConnectionString"] = "";

sql = " order by " e.SortExpression ViewState["DataConnectionString"];
GridViewBind(sql);

//DataFormatString="{0:yyyy年MM月dd日 hh时mm分ss秒}"
}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
...{
this.GridView1.PageIndex = this.ddlCurrentPage.SelectedIndex;
GridViewBind("");
}

private bool CheckAddClientInfoForm()
...{
int Tag = 0;

if (Tag == 1)
...{

Response.Write("<script>alert('请将带*项填写!')</script>");
return false;
}
if (Tag == 2)
...{

Response.Write("<script>alert('两次输入密码不同')</script>");
return false;
}
else
...{
return true;
}
}

public string GetClientVisitInfoShowAnchorStr(object StfId, object StfName)
...{
string AnchorStr = "<a href='#'><Div onclick='javascript:window.open("TManageModify.aspx?StfId=" StfId "&StfName=" StfName "","","height=280,Width=600,scrollbars=yes,resizable=yes,status=no")'>修改</Div></a>";
return AnchorStr;
}
public string GetClientVisitInfoShowCmpMoney(object StfId, object StfName)
...{
string AnchorStr = "<a href='#'><Div onclick='javascript:window.open("StfCmpMoneyInfo.aspx?StfId=" StfId "&StfName=" StfName "","","height=250,Width=500,scrollbars=yes,resizable=yes,status=no")'>充值</Div></a>";
return AnchorStr;
}
protected void Button3_Click(object sender, EventArgs e)
...{
string str = "";
string[] ckb = null;

str = Request.Form.Get("checkboxname");
ckb = str.Split(new char[] ...{ ',' });
for (int i = 0; i < ckb.Length; i )
...{ //帐户和信息同时删除
string StrSql = " Delete TStafferInfo where StfId ='" ckb[i] "'";
String StrSql_d = " Delete TCmpMoneyInfo where StfId ='" ckb[i] "'";
SqlConnection Conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings.Get("DataConnectionString"));
SqlCommand Cmd = new System.Data.SqlClient.SqlCommand(StrSql, Conn);
SqlCommand Cmd_d = new System.Data.SqlClient.SqlCommand(StrSql_d, Conn);

Conn.Open();
SqlTransaction Trans = Conn.BeginTransaction();
try
...{
Cmd.Transaction = Trans;
Cmd_d.Transaction = Trans;
Cmd.ExecuteNonQuery();
Cmd_d.ExecuteNonQuery();
Trans.Commit();

文章整理：西部数码--专业提供域名注册、虚拟主机服务
http://www.west263.com
以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢!