V120401 - DataTable 用法介紹 - 1

 目的:  V120401  - DataTable 的用法介紹

參考網址: http://www.aspphp.online/bianchen/dnet/cxiapu/cxprm/201701/188855.html

1>Create  Table
DataTable dt= new DataTable("T1");

2>Create Columns

int Tmp_Cnt = ds.Tables["T1"].Rows.Count;

ds.Tables["T1"].Columns.Add(new DataColumn("VNDTXY_", typeof(string)));

dt.Columns.Add(new DataColumn("VNTPXD_", typeof(string)));

dt.Columns.Add(new DataColumn("MKER_", typeof(string)));

3>Add row     DataRow dr = dt.NewRow();

dr["VNDTXY_"] = "AX";

4>SeletRows

    DataRow[] drs = dt.Select("column0 = 'AX'");

5>Copy DataTable include data
     DataTable dt1 = dt.Copy();

6>Copy DataTable only scheme

    DataTable dt2 = dt.Clone();