booyaa/DTExample.md

Created September 17, 2013 11:58

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/booyaa/6593372.js"></script>
Save booyaa/6593372 to your computer and use it in GitHub Desktop.

Create a datatable with columns and insert rows

Raw

// initialise
DataTable dt = new DataTable();
dt.TableName = "foo";

// add meta data
DataColumn col = dtColumns.Add("CustID", typeof(Int32));
DataColumn col = dtColumns.Add("Name", typeof(String));

// insert row
DataRow row = dt.NewRow();
row["CustID"] = 1;
row["Name"] = "bar";

dt.Rows.Add(row); // alt method: dt.Rows.Add(new Object[] {1, "bar"});