Tuesday, July 5, 2011

Merging two Datatables

Code for Merging two datatable is given below

DataTable dt = dsSearch.Tables[0];
DataTable dt1 = dsSearch2.Tables[0];

dt.Merge(dt1);



First you must have two databale of same columns name i repeat both of them must have same column name like

datatable 1 colname sno , name , email address
datatable 2 colname sno , name , email_address

but if you merge them output will be

sno , name , email address ,email_address

but if
datatable 1 colname sno , name , email address
datatable 2 colname sno , name , email_address

then after merging

sno , name , email address

No comments:

Post a Comment