C# DataTable Memo

Columns.Add_fromOtherCols.cs

DataTable dt = New DataTable();
dt.Columns.Add("COL1");
dt.Columns.Add("COL2", typeof(int), "Convert(COL1,'System.Int32')");

DataTable.Select.cs

//filter
string sql = "SELECT COL1, COL2 FROM DUAL";
DataTable dt = SelectSQL(sql); //Run SQL
DataRow[] dr = dt.Select("COL1='A'");

//sort
DataRow[] dr2 = dt.Select("COL1='A'", "COL2 DESC");
DataRow[] dr3 = dt.Select("COL1='A'", "COL2 ASC");