merging multiple datasets to bind to a grid

[Rock]

How can I merge 2 datasets into one, then bind with the datagrid, or bind
the datagrid to 2 datasets? For instance, I have one stored procedure that
finds company name, address, etc., and another stored procedure that finds
employees of that company and the employee information.

Thanks.

[Alvin Bruney [MVP]]

Couple ways of doing this, you can call merge on the tables in question or
you can build a new dataset from both datasets by iterating both. If you
choose the latter, as you iterate and add, you need to remove so that you
don't have duplicates on the second pass.

--
Regards,
Alvin Bruney
[ASP.NET MVP [url]http://mvp.support.microsoft.com/default.aspx][/url]
Got tidbits? Get it here... [url]http://tinyurl.com/27cok[/url]
"Rock" <rockisland@yahoo.com> wrote in message
news:OaN94bdzEHA.352@TK2MSFTNGP14.phx.gbl...

> How can I merge 2 datasets into one, then bind with the datagrid, or bind
> the datagrid to 2 datasets? For instance, I have one stored procedure
> that
> finds company name, address, etc., and another stored procedure that finds
> employees of that company and the employee information.
>
> Thanks.
>
>

[rajdothenew@gmail.com]

i have a dropdown in asp.net containing detail about emergency its fields are airways,police station etc having 27 such type of field and for each field i have a table in access data base i want to bind that table on select from dropdown and through click event of button binds only that particular value