Add new column and data to datatable that already contains data - c#

Question

How do I add a new DataColumn to a DataTable object that already contains data?

PseudoCode

//call SQL helper class to get initial data 
DataTable dt = sql.ExecuteDataTable("sp_MyProc");

dt.Columns.Add("MyRow", type(System.Int32));

for(DataRow dr in dr.Rows)
{
    //need to set value to MyRow column
}

Answer 1

Just keep going with your code - you're on the right track:

//call SQL helper class to get initial data 
DataTable dt = sql.ExecuteDataTable("sp_MyProc");

dt.Columns.Add("MyRow", type(System.Int32));

for(DataRow dr in dt.Rows)
{
    //need to set value to MyRow column
    dr["MyRow"] = 0;   // or set it to some other value
}

// possibly save your Dataset here, after setting all the new values