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