GridView的使用

最新推荐文章于 2022-10-13 19:34:08 发布

陈善强

最新推荐文章于 2022-10-13 19:34:08 发布

阅读量398

点赞数 1

分类专栏： ASP.NET 文章标签： gridview

本文链接：https://blog.csdn.net/chenshanqiang/article/details/51958278

版权

ASP.NET 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

前台代码：

</html>

后台代码：

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Text;
public partial class GridView1 : System.Web.UI.Page
{
string str = ConfigurationManager.ConnectionStrings["DataConnectStr"].ConnectionString;
string sqlstr = "select * from person2";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind();
}
}
public void bind()
{
//将数据部署到GridView中
string sqlstr = "select * from person2";
SqlConnection con = new SqlConnection(str);
SqlDataAdapter ad = new SqlDataAdapter(sqlstr, con);
DataSet ds = new DataSet();
ad.Fill(ds, "person2");
GridView2.DataSource = ds;
GridView2.DataBind();
lblPageCount.Text = "共 " + this.GridView2.PageCount.ToString() + " 页";
lblRecordCount.Text = "总共 " + ds.Tables[0].Rows.Count + " 条";
}
//编辑
protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView2.EditIndex = e.NewEditIndex;
bind();
}
//删除
protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string sqlstr = "delete from person2 where ID='" + GridView2.DataKeys[e.RowIndex].Value.ToString() + "'";

SqlConnection sqlcon = new SqlConnection(str);
SqlCommand sqlcom = new SqlCommand(sqlstr, sqlcon);
sqlcon.Open();
sqlcom.ExecuteNonQuery();
sqlcon.Close();
bind();
}
//取消
protected void GridView2_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView2.EditIndex = -1;
bind();
}
//更新
protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
SqlConnection sqlcon = new SqlConnection(str);
string sqlstr = "update person2 set name='"
+ ((TextBox)(GridView2.Rows[e.RowIndex].Cells[2].Controls[0])).Text + "',pwd='"
+ ((TextBox)(GridView2.Rows[e.RowIndex].Cells[3].Controls[0])).Text + "',age='"
+ ((TextBox)(GridView2.Rows[e.RowIndex].Cells[4].Controls[0])).Text + "',sex='"
+ ((TextBox)(GridView2.Rows[e.RowIndex].Cells[5].Controls[0])).Text + "', ph='"
+ ((TextBox)(GridView2.Rows[e.RowIndex].Cells[6].Controls[0])).Text + "'where ID=" +
Convert.ToInt32(GridView2.DataKeys[e.RowIndex].Value);
SqlCommand sqlcom = new SqlCommand(sqlstr, sqlcon);
sqlcon.Open();
sqlcom.ExecuteNonQuery();
sqlcon.Close();
GridView2.EditIndex = -1;
bind();
}
//排序
//在这里，接收两个参数,分别是sortExpression和direction,然后构成dataview进行排序。
protected void GridView2_Sorting(object sender, GridViewSortEventArgs e)
{
if (ViewState["SortDirection"] == null)
ViewState["SortDirection"] = "DESC";
if (ViewState["SortDirection"].ToString() == "ASC")
ViewState["SortDirection"] = "DESC";
else
ViewState["SortDirection"] = "ASC";
ViewState["SortExpression"] = e.SortExpression;
this.bindgrid();
}
protected void bindgrid()
{
string sqlconnstr = ConfigurationManager.ConnectionStrings["DataConnectStr"].ConnectionString;
DataSet ds = new DataSet();
using (SqlConnection sqlconn = new SqlConnection(sqlconnstr))
{
SqlDataAdapter sqld = new SqlDataAdapter("select * from person2", sqlconn);
sqld.Fill(ds, "person2");
}
//判断是否已经进行排序，如果是则按照ViewState中存储的信息生成排序后的DataView对象
if (ViewState["SortDirection"] == null)
GridView2.DataSource = ds.Tables["person2"].DefaultView;
else
{
DataView SortedDV = new DataView(ds.Tables["person2"]);
SortedDV.Sort = ViewState["SortExpression"].ToString() + " " +
ViewState["SortDirection"].ToString();
GridView2.DataSource = SortedDV;
}
GridView2.DataBind();
}

//第几页
protected void lnkbtnJumpPage_Click(object sender, EventArgs e)
{

GridView2.PageIndex = int.Parse(txtJumpPage.Text) - 1;
if (GridView2.PageIndex < GridView2.PageCount)
{
lblCurrentIndex.Text = "第 " + (GridView2.PageIndex+1).ToString() + " 页";
}
else
{

lblCurrentIndex.Text = "不存在";
}
bind();

}
//点击数据表中的1、2、3、......发生的变化
protected void GridView2_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView2.PageIndex = e.NewPageIndex;
bind();
}
//鼠标到行的颜色变化
protected void GridView2_Bianhua(object sender, GridViewRowEventArgs e)
{
int i;
//执行循环，保证每条数据都可以更新
for (i = 0; i < GridView2.Rows.Count + 1; i++)
{
//首先判断是否是数据行
if (e.Row.RowType == DataControlRowType.DataRow)
{
//当鼠标停留时更改背景色
e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#00A9FF'");
//当鼠标移开时还原背景色
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c");
}
}

}
//首页
protected void lbnFirst_Click(object sender, EventArgs e)
{
this.GridView2.PageIndex = 0;
bind();

}
//上一页
protected void lbnPrev_Click(object sender, EventArgs e)
{
if (this.GridView2.PageIndex > 0)
{
this.GridView2.PageIndex = this.GridView2.PageIndex - 1;
bind();
}
}
//下一页
protected void lbnNext_Click(object sender, EventArgs e)
{
if (this.GridView2.PageIndex < this.GridView2.PageCount)
{
this.GridView2.PageIndex = this.GridView2.PageIndex + 1;
bind();
}
}
//尾页
protected void lbnLast_Click(object sender, EventArgs e)
{
this.GridView2.PageIndex = this.GridView2.PageCount;
bind();
}
}