幾種 DataTable / DataColumn / DataRow 使用方法

 
幾種 DataTable / DataColumn / DataRow 使用方法
 

   Deafult.aspx
 
   <form id="Form1" runat="server">
      <div>
      <asp:DataGrid ID="GD1" runat="server"/>
      <br />
      <asp:DataGrid ID="GD2" runat="server"/>
      <br />
      <asp:DataGrid ID="GD3" runat="server"/>
      </div>
   </form>
 

 

   Deafult.aspx.cs
 
   using System.Data;
 
   private void datatableuse()
   {
 
      DataTable DataTable1 = new DataTable();
      DataColumn DataColumn1;
      DataRow DataRow1;
 
      DataColumn1 = new DataColumn();
      DataColumn1.DataType = System.Type.GetType("System.Int32");
      DataColumn1.ColumnName = "ID";
      DataTable1.Columns.Add(DataColumn1);
 
      DataColumn1 = new DataColumn();
      DataColumn1.DataType = System.Type.GetType("System.String");
      DataColumn1.ColumnName = "Message";
      DataTable1.Columns.Add(DataColumn1);
 
      for (int index = 1; index < 11; index++)
      {
         DataRow1 = DataTable1.NewRow();
         DataRow1["ID"] = index;
         DataRow1["Message"] = "String " + index.ToString();
         DataTable1.Rows.Add(DataRow1);
      }
 
      DataView DataView1 = new DataView(DataTable1);
 
      GD1.DataSource = DataTable1;
      GD1.DataBind();
 
      GD2.DataSource = DataView1;
      GD2.DataBind();
 
      DataTable DataTable2 = new DataTable();
 
      DataTable2.Columns.Add(new DataColumn("ID", System.Type.GetType("System.Int32")));
      DataTable2.Columns.Add(new DataColumn("Message", System.Type.GetType("System.String")));
 
      for (int index = 1; index < 11; index++)
      {
         DataTable2.Rows.Add(DataTable2.NewRow());
         DataTable2.Rows[index – 1][0] = index;
         DataTable2.Rows[index – 1][1] = "String " + index.ToString();
      }
 
      GD3.DataSource = DataTable2;
      GD3.DataBind();
 
   }