connect two datatable

[ammoos]

Hi Friends

I want to select data from two tables, one is from sqlserver and other is from sybase. May I know how it will be possible..

Is there any way in .net to connect two datatable using some critiria

Thanks

[r035198x]

Open separate connections for the two databases and get the data into two ArrayLists. You can then "select" the data from those two ArrayLists.

[Curtis Rutland]

If you are just asking if you can connect to two different data sources in your project, then yes, of course you can.

If you need to "join" these datasources, I'd suggest that you select into DataTables (using OleDbDataAdapte rs) and then make a new DataTable and fill it with rows from both other tables.

[ammoos]

Thanks Friends....