need help to merge two datasets

Hi,

Are you referring to a ado.net dataset? If so I assume you have a datatable in the datasets with identical column definitions. Do you want to merge the tables into 1 table with all the data?

Datatables have no inherent order, they are collections of rows,
although the rows usually are in the order they are added to the datatable. You could ensure a particualar order in the merged table by adding each row from the 2 tables one at a time in the correct order.

If you are displaying the data in some sort of control (web, winforms?) then the control would have some way of ordering the rows displayed, usually thru the controls datasource.

I hope this is useful. Good Luck