How can I add a new column and data to a datatable that already contains data

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  NewColumn   type System Int32     foreach DataRow row in dr Rows          need to set value to NewColumn column

User · Answer

Try this   gt  dt columns Add  ColumnName   typeof Give the type you want     gt  dt Rows give the row no like  or  or any no   Column name in which you want to add data     Value

User · Answer

Here is an alternate solution to reduce For ForEach looping  this would reduce looping time and updates quickly       dt Columns Add  MyRow   typeof System Int32     dt Columns  MyRow   Expression     0

User · Answer

Only you want to set default value parameter  This calling third overloading method    dt Columns Add  MyRow   type System Int32  0

User · Answer

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  NewColumn   typeof System Int32     foreach DataRow row in dt Rows          need to set value to NewColumn column     row  NewColumn     0       or set it to some other value       possibly save your Dataset here  after setting all the new values

User · Answer

Should it not be foreach instead of for      call SQL helper class to get initial data   DataTable dt   sql ExecuteDataTable  sp MyProc      dt Columns Add  MyRow     typeof   System Int32      foreach DataRow dr in dt Rows            need to set value to MyRow column      dr  MyRow     0       or set it to some other value

[c#] How can I add a new column and data to a datatable that already contains data?

Examples related to c#

Examples related to datatable

Examples related to datarow