Combining Two (or More) DataSets 1

[iaresean]

Hello all;

I generate datasets using and sql command. Does anyone know how I could combine two or more datasets into a single dataset that I can use to populate a control?

All the datasets have the same structure in terms of columns, but obviously very different data.

I am pretty sure that a stored procedure would have been the best route, however, I do not have stored procedures available to me.

Any and all help would be greatly appreciated!

Sean.

 

[DotNetGnat]

do a UNION ALL query to combine them...

example...

Select field1, field2 from table1
UNION ALL
Select field1, field2 from table2

-DNG

 

[macleod1021]

Can you explain "do not have stored procedures available"? Is it because you don't have access or the database doesnt support it? If it's because you don't have access to create them, then use the union all. If it's because your db doesn't support it, then it may not support union all.

 

[iaresean]

Hi Macleod1021;

No the db for this project, MS ACCESS 2000, doesn't support stored procedures, but it does support the UNION ALL. Actually after further coding I realised that UNION ALL actually wasn't really going to solve my problem due to technical requirements. I ended up using multiple datasets combined with the MERGE function.

Regards;

Sean.