GridView数据绑定的一些主要属性

最新推荐文章于 2018-07-03 16:27:21 发布

eclipseluo

最新推荐文章于 2018-07-03 16:27:21 发布

阅读量708

点赞数

分类专栏： ASP.NET 文章标签： asp string server object textbox session

本文链接：https://blog.csdn.net/eclipseluo/article/details/4757254

版权

ASP.NET 专栏收录该内容

90 篇文章 1 订阅

订阅专栏

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="HomePage.aspx.cs" Inherits="HomePage" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>无标题页</title> </head> <body> <form id="form1" runat="server"> <div> <div align="right"> <div align="center"> <br /> </div> <b> <asp:Label ID="lbView" runat="server" ForeColor="red"></asp:Label></b> <asp:LinkButton ID="lbCancle" runat="server" OnClick="lbCancle_Click" Visible="false">注销登录</asp:LinkButton> <br /> <br /> <br /> <div align="center"> <h1> 用户信息</h1> <asp:TextBox ID="tbsearch" runat="server" Height="22px"></asp:TextBox> <asp:Button ID="btsearch" runat="server" Text="搜索" OnClick="btsearch_Click" /> <asp:Button ID="btrecover" runat="server" Text="还原" OnClick="btrecover_Click" /> <br /> </div> <div align="center"> <asp:GridView ID="GridView1" runat="server" BackColor="White" AutoGenerateColumns="false" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical" OnRowCommand="GridView1_RowCommand" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" DataKeyNames="UserID" OnRowCancelingEdit="GridView1_RowCancelingEdit" EnableSortingAndPagingCallbacks="False"> <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" /> <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" /> <AlternatingRowStyle BackColor="#DCDCDC" /> <FooterStyle BackColor="#CCCCCC" ForeColor="Black" /> <RowStyle BackColor="#EEEEEE" ForeColor="Black" /> <%--//绑定列--%> <Columns> <asp:BoundField DataField="UserName" HeaderText="用户名" ReadOnly="true" /> <asp:BoundField DataField="UserEmail" HeaderText="电子邮箱"></asp:BoundField> <%-- //模板列--%> <asp:TemplateField HeaderText="查看"> <ItemTemplate> <asp:LinkButton ID="lblookMes" runat="server" CommandName="look" CommandArgument='<%#Eval("UserID") %>'>查看信息</asp:LinkButton> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="删除"> <ItemTemplate> <asp:LinkButton ID="lbDelete" runat="server" CommandName="del" CommandArgument='<%#Eval("UserID") %>'>删除</asp:LinkButton> </ItemTemplate> </asp:TemplateField> <%--跟新列--%> <asp:CommandField ShowEditButton="True" /> </Columns> </asp:GridView> <br /> </div> </form> </body> </html>

GridView的一些需要注意的属性

AutoGenerateColumns="false" //消除自动跟新，可以覆盖原始表，显示想要的属性

DataKeyNames="UserID" //绑定数据表的主键值

GridView的域

1。绑定列，绑定数据表的属性，用HeaderText别名加以显示

<asp:BoundField DataField="UserName" HeaderText="用户名" ReadOnly="true" />
<asp:BoundField DataField="UserEmail" HeaderText="电子邮箱"></asp:BoundField>

2。模板列，可以创建自定义操作，通过（CommandName，CommandArgument通过Eval函数绑定主键进行操作）键值对来访问

   <asp:TemplateField HeaderText="查看">
   <ItemTemplate>
   <asp:LinkButton ID="lblookMes" runat="server" CommandName="look" CommandArgument='<%#Eval("UserID") %>'>查看信息</asp:LinkButton>
   </ItemTemplate>
   </asp:TemplateField>

3。跟新列，可以对属性值进行编辑
<asp:CommandField ShowEditButton="True" />

GridView的一些常用方法

OnRowCommand="GridView1_RowCommand" //行操作

OnRowEditing="GridView1_RowEditing" //行编辑

OnRowUpdating="GridView1_RowUpdating" //行跟新

OnRowCancelingEdit="GridView1_RowCancelingEdit" //取消跟新

后台代码：

using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class HomePage : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["UserName"] != null) { lbView.Text = "欢迎," + Session["UserName"].ToString(); lbCancle.Visible = true; } GetDataConn(); } } /// <summary> /// 绑定GridView控件 /// </summary> /// <param name="cmdText"></param> protected void bind(string cmdText) { SqlHelper helper = new SqlHelper(@"Data Source=A102-35/SQLEXPRESS;Initial Catalog=DB_Login;Integrated Security=True"); DataTable dt = helper.RunProcDataTable(cmdText, "UserList"); //把得到的数据赋给数据列表控件 GridView1.DataSource = dt; GridView1.DataBind(); } /// <summary> /// 执行插入或删除语句 /// </summary> /// <param name="cmdText"></param> /// <param name="pa"></param> protected void commandSQL(string cmdText, SqlParameter[] pa) { SqlHelper helper = new SqlHelper(@"Data Source=A102-35/SQLEXPRESS;Initial Catalog=DB_Login;Integrated Security=True"); helper.RunSQL(cmdText, pa); } /// <summary> /// 注销登录 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lbCancle_Click(object sender, EventArgs e) { if (Session["UserName"] != null) { Response.Redirect("Login.aspx"); } } /// <summary> /// 刷新显示GridView控件 /// </summary> protected void GetDataConn() { //建立和数据库的连接 try { string sqlStr = @"select * from UserList"; bind(sqlStr); } catch (SqlException se) { Response.Write("CUOWU:" + se.Message.ToString()); } } /// <summary> ///模糊查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btsearch_Click(object sender, EventArgs e) { string getStr = tbsearch.Text.Trim(); string cmdStr = @"select * from UserList where UserName like '%" + getStr + "%'"; bind(cmdStr); } /// <summary> /// 返回原始GridView /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btrecover_Click(object sender, EventArgs e) { GetDataConn(); } /// <summary> /// 执行删除或查看行操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "del") { string delStr = @"delete from UserList where UserID='" + e.CommandArgument.ToString() + "'"; bind(delStr); } else if (e.CommandName == "look") { } } /// <summary> /// 执行行编辑操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { GridView1.EditIndex = e.NewEditIndex; //该属性获取或设置所编辑的行的索引 string commandText = "SELECT * FROM UserList"; bind(commandText); } /// <summary> /// 执行行跟新操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { string email = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text; //获得更新行 int userid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value); //获得主键 SqlParameter[] para ={new SqlParameter ("@email",SqlDbType.NChar,20), //添加命令变量 new SqlParameter("@userid",SqlDbType.Int) }; para[0].Value = email; para[1].Value = userid; string sqlStr = "update UserList set UserEmail = @email where UserID= @userid"; //跟新语句 commandSQL(sqlStr, para); string commandText = "SELECT * FROM UserList"; bind(commandText); } /// <summary> /// 行取消编辑操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { GridView1.EditIndex = -1; string commandText = "SELECT * FROM UserList"; bind(commandText); } }