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?
 
Back
Top