wilsongull
New Member
How can i merge two Datatables into the same row. I am using different stored procedures to get data into datasets. In asp.net using c#, i want to merge them so there are same number of rows as table 1 with an added column from table 2.For example:\[code\]DataTable table1 = dsnew.Tables[0];DataTable table2 = dsSpotsLeft.Tables[0];table1.Merge(table2);\[/code\]This is fetching me 4 rows instead of 2 rows. What am i missing here? Thanks in advance!!