Comments by Kamlesh_Singh08 (Top 2 by date)

hi Raja
example

DataTable tblFirst = new DataTable();
tblFirst.Columns.Add("c1", typeof(int));
tblFirst.Columns.Add("c2", typeof(int));
tblFirst.Columns.Add("c3", typeof(string));
tblFirst.Columns.Add("c4", typeof(char));

DataTable tblSecond = new DataTable();
tblSecond.Columns.Add("c1", typeof(int));
tblSecond.Columns.Add("c5", typeof(int));
tblSecond.Columns.Add("c6", typeof(string));
tblSecond.Columns.Add("c7", typeof(char));

DataTable tblThird = new DataTable();
tblThird.Columns.Add("c1", typeof(int));
tblThird.Columns.Add("c8", typeof(int));
tblThird.Columns.Add("c9", typeof(string));
tblThird.Columns.Add("c10", typeof(char));

tblFirst.Rows.Add(1, 8500, "abc", 'A');
tblFirst.Rows.Add(2, 950, "cde", 'B');
tblFirst.Rows.Add(3, 150, "efg", 'C');
tblFirst.Rows.Add(4, 850, "ghi", 'D');
tblFirst.Rows.Add(5, 50, "ijk", 'E');

tblSecond.Rows.Add(1, 7500, "klm", 'F');
tblSecond.Rows.Add(2, 900, "mno", 'G');
tblSecond.Rows.Add(3, 150, "opq", 'H');
tblSecond.Rows.Add(4, 850, "qrs", 'I');
tblSecond.Rows.Add(5, 50, "stu", 'J');

tblThird.Rows.Add(1, 7500, "uvw", 'K');
tblThird.Rows.Add(2, 900, "wxy", 'L');
tblThird.Rows.Add(3, 150, "yza", 'M');
tblThird.Rows.Add(4, 850, "ABC", 'N');
tblThird.Rows.Add(5, 50, "CDE", 'O');


DataTable tblMeargeAll = new DataTable();
tblMeargeAll = tblFirst.Copy(); // Copy data and schema
tblMeargeAll.Merge(tblSecond); // meage second table
tblMeargeAll.Merge(tblThird); // mearge thired table