Combine SQL results in one DataGrid

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

Is it somehow possible to Use One DataGrid control with two sql querys? For example one query selects customer's names and another query selects products that each customer had bought. Is it possible to combine two sql results in one DataGrid

thanks

Pete
 
Hi Peter,

See

HOW TO: Implement a DataSet JOIN helper class in Visual C# .NET

http://support.microsoft.com/default.aspx?scid=kb;en-us;326080&Product=vcSnet

and

HOW TO: Implement a Custom DataView Class in Visual Basic .NET

http://support.microsoft.com/default.aspx?scid=kb;en-us;325682&Product=vbNET

--
Miha Markic [MVP C#] - RightHand .NET consulting & software
development
miha at rthand com
www.rthand.com


Peter said:
Hi!

Is it somehow possible to Use One DataGrid control with two sql querys?
Click to expand...
For example one query selects customer's names and another query selects
products that each customer had bought. Is it possible to combine two sql
results in one DataGrid?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refresh Bound DataGrid 4
Combine Duplicates in Query 0
2 tables in one DataGrid 5
How to bind DataGrid to SQL query ? 4
Datagrid 4
Datagrid binded to sqlceresultset 0
How select in either grids in 'Master-Slave' ? 1
Datagrid binded to sqlceresultset (how to) 4

Back
Top