ASP.NET操作DataTable各種方法まとめ(Datableに行列を追加、DataTable選択並べ替え等)
1937 ワード
using System;
using System.Collections.Generic;
using System.Data;
using System.Text;
namespace Gzcms.Common
{
public class CreateTable
{
public static DataTable getTable()
{
//1. datatable
DataTable dt = new DataTable("datatable");// ,datatable
//2. :
dt.Columns.Add("id", typeof(System.Int32));// , System.Int32,System.Double..
dt.Columns.Add("title", typeof(System.String));
//3. , :
DataRow row = dt.NewRow();
row["id"] = 1;
row["title"] = " 1";
dt.Rows.Add(row);//
row = dt.NewRow();
row["id"] = 2;
row["title"] = " 2";
dt.Rows.Add(row);
return dt;
/*
//4. ,, id 1
DataRow[] arr = dt.Select("id=1");//
//5. table
DataTable dtnew = dt.Clone();// dt dtnew ,
foreach (DataRow row in arr)
{
dtnew.Rows.Add(row);// dtnew
}
dt.AcceptChanges();// , !
//6.
dt.DefaultView.Sort = "id desc";
//7.
dt.Rows.Remove(row);// row
dt.Rows.RemoveAt(index);// index
//8. dt
row2[0].BeginEdit();
row2[0]["status"] = 0;
row2[0].EndEdit();
*/
}
}
}