62,243
社区成员




<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
OnRowDataBound="GridView1_RowDataBound">
<AlternatingRowStyle BackColor="LightSteelBlue"/>
<PagerSettings Visible="False" />
<Columns>
<asp:TemplateField HeaderText="标题">
<ItemTemplate>
<%#Eval("id")%>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="内容">
<ItemTemplate>
<%#Eval("content")%>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
protected void fillGridView()// 填充GridView
{
//DataSet ds = new DataSet();
//ds = GetCusData(whereSql);
//GridView1.DataSource = ds;
//GridView1.DataBind();
//getRefSet(ds);
}
//分页设置
protected void getRefSet(DataSet ds)
{
lblCurrentIndex.Text = "第 " + (GridView1.PageIndex + 1).ToString() + " 页";
lblPageCount.Text = "共 " + GridView1.PageCount.ToString() + " 页";
if (ds.Tables[0].Rows.Count == 0)
{
lnkbtnFirst.Visible = false;
lnkbtnPre.Visible = false;
lnkbtnNext.Visible = false;
lnkbtnLast.Visible = false;
lblCurrentIndex.Visible = false;
lblPageCount.Visible = false;
}
else if (GridView1.PageCount == 1)
{
lnkbtnFirst.Visible = false;
lnkbtnPre.Visible = false;
lnkbtnNext.Visible = false;
lnkbtnLast.Visible = false;
}
lnkbtnFirst.CommandArgument = "1";
lnkbtnPre.CommandArgument = (GridView1.PageIndex == 0 ? "1" : GridView1.PageIndex.ToString());
lnkbtnNext.CommandArgument = (GridView1.PageCount == 1 ? GridView1.PageCount.ToString() : (GridView1.PageIndex + 2).ToString());
lnkbtnLast.CommandArgument = GridView1.PageCount.ToString();
}
//分页跳转
protected void lnkbtnJumpPage_Click(object sender, EventArgs e)
{
GridView1.PageIndex = int.Parse(txtJumpPage.Text) - 1;
lblCurrentIndex.Text = "第 " + (GridView1.PageIndex + 1).ToString() + " 页";
fillGridView();
GridView1.DataBind();
}
protected void PagerButtonClick(object sender, EventArgs e)
{
GridView1.PageIndex = Convert.ToInt32(((LinkButton)sender).CommandArgument) - 1;
fillGridView();
GridView1.DataBind();
}
//鼠标事件
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
e.Row.Attributes["onmouseover"] = "ItemOver(this)";
}
public void Button1_Click(object sender, EventArgs e)
{
string whereSql = Request.Form["xm"];
string strSql = "select t.username,s.custid,s.name as 姓名 ,s.position,s.address as 地址 ,s.position,s.phone as 电话 from sys_custm t,sys_cust s where s.name=" +"'"+ whereSql +"'";
DataSet ds = new DataSet();
try
{
ds = sqlHelper.getDataSet(strSql);
}
catch (Exception ex)
{
Response.Write("数据库错误,错误原因:" + ex.Message);
Response.End();
}
GridView1.DataSource = ds;
GridView1.DataBind();
}