📄 boundcolumn.aspx

📁 asp.net经典案例资料
💻 ASPX
字号:
<%@ Page Debug="true" Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<html>
  <head>
    <title>DataGrid Demo- Bound Column</title>
    <script language="C#" runat="server" >
    public void Page_Load()
    {
      //Create Connection object
      string dataSource = "Data Source=localhost;";
      string security = "user id=sa; password=;";
      string initialCatalog = "initial catalog=pubs;";
      string cnnString = dataSource + security + initialCatalog;
      SqlConnection connection = new SqlConnection(cnnString);

      // Create Data Command
      string strSql = "select * from [authors]";
      SqlCommand command = new SqlCommand(strSql, connection);

      // Create Data Adapter
      SqlDataAdapter adapter = new SqlDataAdapter();
      adapter.SelectCommand = command;

      // Create DataSet
      DataSet dataSet = new DataSet();

      try
      {
        connection.Open();
        adapter.Fill(dataSet);
      }
      catch(SqlException e)
      {
        Response.Write(e.ToString());
      } 
      finally
      {
        connection.Close();
      }

      DataTable dataTable = dataSet.Tables[0];
      DataColumn dataColumn = dataTable.Columns.Add("Email", typeof(string));
      foreach(DataRow row in dataTable.Rows)
        row["Email"] = (string)row["au_lname"] + " " + (string)row["au_fname"] + "@nobody.com";

      grid1.DataSource = dataTable;
      grid1.DataBind();
    }
    </script>
  </head>

  <body>
  <form id="form1" runat="server">
    <h3>DataGrid Demo- Bound Column</h3>
    <asp:DataGrid id="grid1" runat="server" AutoGenerateColumns="false">
      <HeaderStyle BackColor="lightblue" Font-Name="Arial" Font-Bold="true" />
      <Columns>
        <asp:BoundColumn DataField="au_fname" HeaderText="作者姓"/>
        <asp:BoundColumn DataField="au_lname" HeaderText="作者名" />
        <asp:BoundColumn DataField="phone" HeaderText="电话" />
        <asp:BoundColumn DataField="Address" HeaderText="地址" />
        <asp:BoundColumn DataField="zip" HeaderText="邮政编码" DataFormatString="{0:G6}"/>
        <asp:HyperLinkColumn  HeaderText="电子邮件" DataTextField="Email" 
          DataNavigateUrlField="Email" DataNavigateUrlFormatString="mailto:{0:G}" />
        <asp:TemplateColumn>
          <HeaderTemplate>
            <b>是否有合同</b>
          </HeaderTemplate>

          <ItemTemplate>
             <asp:CheckBox Enabled="false" runat="server" Text="合同"
               Checked='<%# DataBinder.Eval(Container.DataItem, "contract") %>' />
          </ItemTemplate>
        </asp:TemplateColumn>
      </Columns>
    </asp:DataGrid>
  </form>
  </body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -