Create Data Table C# datatable

Sometimes need to hand craft a data table for use.

DataTable dt = new DataTable();
        DataRow dr;
        dt.Columns.Add(new System.Data.DataColumn("EventTitle", typeof(String)));
        dt.Columns.Add(new System.Data.DataColumn("EventID", typeof(String)));
        dr = dt.NewRow();
        dr[0] = "Emergency Alert";
        dr[1] = "Event Id";

      dt.Rows.Add(dr);

Here is how you could use that in a function to return the datatable:

 private DataTable GetDummyData()
 {





DataTable dt = new DataTable();
 DataRow dr;
 dt.Columns.Add(new System.Data.DataColumn("EventTitle", typeof(String)));
 dt.Columns.Add(new System.Data.DataColumn("EventID", typeof(String)));
 dt.Columns.Add(new System.Data.DataColumn("Start_Time", typeof(String)));
 dt.Columns.Add(new System.Data.DataColumn("End_Time", typeof(String)));
 dt.Columns.Add(new System.Data.DataColumn("EventDetails", typeof(String)));


dr = dt.NewRow();
 dr[0] = "Christmas Party";
 dr[1] = "1";
 dr[2] = "12/23/2017 12:00:00";
 dr[3] = "12/23/2017 14:00:00";
 dr[4] = "Please drop by our Christmas party and bring gifts!";
 dt.Rows.Add(dr);

return dt;
 }

Leave a Reply