ZZhang

Hello,

I have two db, one has Product table, the other has SalesOrderDetail talbe. I buid a DataSet using ADO.NET, with these two tables. Now I want to do some sql query against two tables, like inner join, sum, group by. How can I make it in DataSet Are there any samples

There two db are not linked together.

Thanks a lot!

-ZZhang



Re: .NET Framework Data Access and Storage How to query DataSet?

Aneesh

http://support.microsoft.com/kb/326080

Hope this will help you





Re: .NET Framework Data Access and Storage How to query DataSet?

Robert Rossney

For most non-trivial cases, you'll be better off doing the query in the database and filling a DataTable with the results.




Re: .NET Framework Data Access and Storage How to query DataSet?

ZZhang

thank you all!

It seems that it is not easy to query DataSet like in db.

-ZZhang





Re: .NET Framework Data Access and Storage How to query DataSet?

Sean Fowler

You could check out Microsoft's new Linq over DataSet technology, the Linq syntax is similar to Sql. Of course this is still in beta as it's part of Orcas/VS2008.

Sean