About GridView-优快云博客

本文链接：https://blog.youkuaiyun.com/IntelliJ/article/details/4004858

本文介绍了一个使用ASP.NET中GridView控件进行数据绑定的示例项目。该项目通过C#代码从数据库读取客户信息，并展示在一个自定义的GridView中。文章详细展示了页面布局设置、数据库连接及数据填充的具体实现。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

新建了一个项目 GridViewDemo

添加了一个页面 KehuCSharp.aspx

拖了一个 GridView 空间到 kehucsharp.aspx

页面代码如下:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="KehuCSharp.aspx.cs" Inherits="KehuCSharp" %> <!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="form_kehu" runat="server"> <div> <asp:GridView ID="GvKehu" runat="server" AutoGenerateColumns="False" Font-Size="9pt"> </asp:GridView> </div> </form> </body> </html>

KehuCSharp.aspx.cs 如下

using System; using System.Data; using System.Configuration; using System.Collections; 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; public partial class KehuCSharp : System.Web.UI.Page { // 声明一个数据库连接 SqlConnection kehuSqlConnection; // SqlDataAdapter kehuSqlDataAdapter; // DataSet kehuDataSet; // 获取写在 Web.Config 文件里面的数据库连接字符串 string strKehuSqlConnection = System.Configuration.ConfigurationSettings.AppSettings["BaobeiConnectionString"].ToString(); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { KehuBbind(); } } // 绑定数据 public void KehuBbind() { string sqlKehu = "select * from kehu where bqr=1 and cqr=0"; OpenDatabase(); kehuSqlDataAdapter = new SqlDataAdapter(sqlKehu, kehuSqlConnection); kehuDataSet = new DataSet(); kehuSqlDataAdapter.Fill(kehuDataSet, "kehu"); GvKehu.DataSource = kehuDataSet; GvKehu.DataKeyNames = new string[] { "id" }; // 主键 GvKehu.DataBind(); CloseDatabase(); } // 打开数据库连接 public void OpenDatabase() { kehuSqlConnection = new SqlConnection(strKehuSqlConnection); if (kehuSqlConnection.State == ConnectionState.Closed || kehuSqlConnection == null) { kehuSqlConnection.Open(); } } // 关闭数据库连接 public void CloseDatabase() { if (kehuSqlConnection.State == ConnectionState.Open || kehuSqlConnection != null) { kehuSqlConnection.Close(); } } }

GridView 表头编辑如下:

<asp:GridView ID="GvKehu" runat="server" AutoGenerateColumns="False" Font-Size="9pt"> <Columns> <asp:TemplateField> <EditItemTemplate> <asp:CheckBox ID="CheckBox1" runat="server" /> </EditItemTemplate> <ItemTemplate> <asp:CheckBox ID="CheckBox1" runat="server" /> </ItemTemplate> </asp:TemplateField> <asp:BoundField DataField="id" HeaderText="编号" InsertVisible="False" ReadOnly="True" SortExpression="id" /> <asp:BoundField DataField="kname" HeaderText="姓名" SortExpression="kname" ReadOnly="True" /> <asp:BoundField DataField="tel" HeaderText="电话1" SortExpression="tel" ReadOnly="True" /> <asp:BoundField DataField="mobi" HeaderText="电话2" SortExpression="mobi" ReadOnly="True" /> <asp:BoundField DataField="tel_sw" HeaderText="电话3" SortExpression="tel_sw" ReadOnly="True" /> <asp:BoundField DataField="mobi_sw" HeaderText="电话4" SortExpression="mobi_sw" ReadOnly="True" /> <asp:BoundField DataField="address" HeaderText="地址" SortExpression="address" ReadOnly="True" /> <asp:BoundField DataField="other" HeaderText="其它信息" SortExpression="other" ReadOnly="True" /> <asp:BoundField DataField="did" HeaderText="业务员" SortExpression="did" ReadOnly="True" /> <asp:BoundField DataField="bqr" HeaderText="上级" SortExpression="bqr" ReadOnly="True" /> <asp:BoundField DataField="kqr" HeaderText="客服" SortExpression="kqr" /> <asp:BoundField DataField="zqr" HeaderText="装潢中心" SortExpression="zqr" ReadOnly="True" /> <asp:BoundField DataField="sqr" HeaderText="设计师" SortExpression="sqr" ReadOnly="True" /> <asp:BoundField DataField="cqr" HeaderText="财务" SortExpression="cqr" ReadOnly="True" /> <asp:BoundField DataField="dates" HeaderText="日期" SortExpression="dates" ReadOnly="True" /> <asp:BoundField DataField="hhmmss" HeaderText="时分秒" SortExpression="hhmmss" ReadOnly="True" /> <asp:BoundField DataField="wip" HeaderText="IP" SortExpression="wip" ReadOnly="True" /> <asp:BoundField DataField="gm" HeaderText="购买" SortExpression="gm" ReadOnly="True" /> <asp:BoundField DataField="state" HeaderText="状态" SortExpression="state" ReadOnly="True" /> <asp:BoundField DataField="d_id" HeaderText="组别" SortExpression="d_id" ReadOnly="True" /> <asp:BoundField DataField="cwyj" HeaderText="财务拒绝" SortExpression="cwyj" ReadOnly="True" /> <asp:BoundField DataField="bmyj" HeaderText="上级拒绝" SortExpression="bmyj" ReadOnly="True" /> <asp:BoundField DataField="invalidation" HeaderText="失效时间" SortExpression="invalidation" ReadOnly="True" /> </Columns> </asp:GridView>