How do i perform intersection in 2 datasets having a same col.




*** Sent via Developersdex http://www.developersdex.com ***

Hello, do you mean JOIN between two datasets ?
It's possible to do JOINs between DataTables in a DataSet,
but it seems to me odd to do JOINs between DataTables from
two DataSets...
Maybe you should expose your design so that one
may give guidance by answer.

I'd also like to know the answer.

gridview - from what I know, if i bind it with dataset with join query,
update methods want be generated.
So one of resolutions would be to define 2 (or more) single table
DataTables, join them, feed it to gridview, and on update of gridview
somehow modify those singletable datasets.

Is there simpler way to do it?

thanks a lot

Store procedure vs Direct statement ???
UniqueIdentifier Sql Data and Parameters
Storing wave files in database
Dataset, SqlDataAdapter, memory and you in .net 2
Passing Parameter Collections