The problem is not the control you use. There are a couple, the DataGrid and
the repeater, that will display this in an ASP+ page or the DataGrid for
Windows Forms.
The trick is in constructing the SQL query that will pull the info out of
the database in that format.
Essentially.... it's doable.

Signature
Bob Powell [MVP]
Visual C#, System.Drawing
Find great Windows Forms articles in Windows Forms Tips and Tricks
http://www.bobpowell.net/tipstricks.htm
Answer those GDI+ questions with the GDI+ FAQ
http://www.bobpowell.net/faqmain.htm
All new articles provide code in C# and VB.NET.
Subscribe to the RSS feeds provided and never miss a new article.
>I have a winForm and i need to display my data in this format and this
>format
[quoted text clipped - 18 lines]
>
> 1/8/05
Mike - 11 Feb 2005 14:03 GMT
I'm using the same SQL that a java version of this app is doing, and he's
doing nothing specail with the SQL the java is using?
Since this has to be a winForm the repeater or datalist wouuld work in this
case.
how can I construct the SQL to bring the data out like this
> The problem is not the control you use. There are a couple, the DataGrid and
> the repeater, that will display this in an ASP+ page or the DataGrid for
[quoted text clipped - 27 lines]
> >
> > 1/8/05
Bob Powell [MVP] - 11 Feb 2005 17:05 GMT
If it's a winform then you have the datagrid to work with.
for a complex SQL query you should probably ask over in the access or SQL
server groups.

Signature
Bob Powell [MVP]
Visual C#, System.Drawing
Find great Windows Forms articles in Windows Forms Tips and Tricks
http://www.bobpowell.net/tipstricks.htm
Answer those GDI+ questions with the GDI+ FAQ
http://www.bobpowell.net/faqmain.htm
All new articles provide code in C# and VB.NET.
Subscribe to the RSS feeds provided and never miss a new article.
> I'm using the same SQL that a java version of this app is doing, and he's
> doing nothing specail with the SQL the java is using?
[quoted text clipped - 36 lines]
>> >
>> > 1/8/05
Mike - 11 Feb 2005 17:49 GMT
I'm using the datagrid and it sucks IMO. I can't do half of the stuff with it
as i can with the web form grid.
they really need to make the grid more flexable in 2005 with the final
release of it. the thing sucks now as it is.
> If it's a winform then you have the datagrid to work with.
>
[quoted text clipped - 41 lines]
> >> >
> >> > 1/8/05