GridView用法.docx

1、GridView用法GridView用法详解1. 前台页面：Default.aspx GridView用法 info.aspx 用户详细信息 用户编号： 性别： 邮箱： 2. 后台页面：Default.aspx.csusing System;using System.Collections.Generic;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using System.Data.SqlClient;public partial class _Default :

2、 System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) if (!IsPostBack) ViewStateSortOrder = 用户编号; ViewStateOrderDir = DESC; dataBind(); / / 绑定数据库中的数据到GridView控件中 / protected void dataBind() string conStr = System.Configuration.ConfigurationManager.ConnectionStringsConStr.ToString(

3、); SqlConnection conn = new SqlConnection(conStr); if (conn.State = ConnectionState.Closed) conn.Open(); / string strSql = select userId,userName from tabUserInfo; string strSql = select userId as 用户编号,userName as 用户名 from tabUserInfo; SqlDataAdapter da = new SqlDataAdapter(strSql, conn); DataSet ds

4、 = new DataSet(); da.Fill(ds, tabUserInfo); string sort = (string)ViewStateSortOrder + + (string)ViewStateOrderDir; DataView view = ds.TablestabUserInfo.DefaultView; view.Sort = sort; gvUserInfo.DataSource = view; gvUserInfo.DataKeyNames = new string用户编号; gvUserInfo.DataBind(); /对特定数据用特定的显示方式 for (i

5、nt i = 0; i gvUserInfo.Rows.Count; i+) DataRowView myDrv = ds.TablestabUserInfo.DefaultViewi; string id = myDrv用户编号.ToString(); if (Convert.ToInt32(id) 5) gvUserInfo.Rowsi.Cells4.BackColor = System.Drawing.Color.Red; if (conn.State = ConnectionState.Open) conn.Close(); / / 实现分页功能 / / / protected voi

6、d gvUserInfo_PageIndexChanging(object sender, GridViewPageEventArgs e) gvUserInfo.PageIndex = e.NewPageIndex; dataBind(); / / 删除GridView中数据 / / / protected void gvUserInfo_RowDeleting(object sender, GridViewDeleteEventArgs e) SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationM

7、anager.ConnectionStringsConStr.ToString(); string strSql = delete from tabUserInfo where userId= +gvUserInfo.DataKeyse.RowIndex.Value.ToString()+ ; conn.Open(); SqlCommand cmd = new SqlCommand(strSql, conn); if (cmd.ExecuteNonQuery() 0) Response.Write(alert(删除成功!); else Response.Write(alert(删除失败!);

8、conn.Close(); dataBind(); / / 编辑GridView中的数据 / / / protected void gvUserInfo_RowEditing(object sender, GridViewEditEventArgs e) gvUserInfo.EditIndex = e.NewEditIndex; dataBind(); / /更改数据并提交到数据库 / / / protected void gvUserInfo_RowUpdating(object sender, GridViewUpdateEventArgs e) string conStr = Syst

9、em.Configuration.ConfigurationManager.ConnectionStringsConStr.ToString(); SqlConnection conn = new SqlConnection(conStr); string strSql = update tabUserInfo set userName= + (TextBox)(gvUserInfo.Rowse.RowIndex.Cells4.Controls0).Text.ToString().Trim() + where userId= + gvUserInfo.DataKeyse.RowIndex.Va

10、lue.ToString() + ; / conn.Open(); SqlCommand cmd = new SqlCommand(strSql, conn); cmd.ExecuteNonQuery(); Response.Write(alert(更改成功！); conn.Close(); gvUserInfo.EditIndex = -1; dataBind(); / / 取消对GridView中数据的编辑 / / / protected void gvUserInfo_RowCancelingEdit(object sender, GridViewCancelEditEventArgs

11、e) gvUserInfo.EditIndex = -1; dataBind(); / / RowDataBound事件 / / / protected void gvUserInfo_RowDataBound(object sender, GridViewRowEventArgs e) /高亮显示鼠标指定行数据 if (e.Row.RowType = DataControlRowType.DataRow) e.Row.Attributes.Add(onMouseOver, Color=this.style.backgroundColor;this.style.backgroundColor=

12、lightblue); e.Row.Attributes.Add(onMouseOut, this.style.backgroundColor=Color;); / / 排序代码 / / / protected void gvUserInfo_Sorting(object sender, GridViewSortEventArgs e) string strPage = e.SortExpression; if (ViewStateSortOrder.ToString() = strPage) if (ViewStateOrderDir.ToString() = DESC) ViewState

13、OrderDir = ASC; else ViewStateOrderDir = DESC; else ViewStateSortOrder = e.SortExpression; dataBind(); info.aspx.csusing System;using System.Collections.Generic;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using System.Data.SqlClient;public partial class inf

14、o : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) if (!IsPostBack) dataBind(); protected void dataBind() string conStr=System.Configuration.ConfigurationManager.ConnectionStringsConStr.ToString(); SqlConnection conn = new SqlConnection(conStr); if (conn.State = ConnectionSt

15、ate.Closed) conn.Open(); string strSql = select * from tabUserInfo where userId=+RequestuserId.ToString()+; SqlDataAdapter da = new SqlDataAdapter(strSql, conn); DataSet ds = new DataSet(); da.Fill(ds, tabInfo); DataRowView rowView = ds.TablestabInfo.DefaultView0; lblUserId.Text = Convert.ToString(rowViewuserId); lblSex.Text = Convert.ToString(rowViewuserSex); lblMail.Text = Convert.ToString(rowViewuserMail); if (conn.State = ConnectionState.Open) conn.Close();