Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Windows Forms / WinForm General / February 2005

Tip: Looking for answers? Try searching our database.

is this possible

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike - 11 Feb 2005 13:23 GMT
I have a winForm and i need to display my data in this format and this format
only. Is this format possible with any control supplied with .NET Windows
Application?

header  data:           BMW                  Porsche              Lexus

left column
data:  
1/5/05                    2 cars sold            0 cars sold         3 cars
sold
1/6/05                    0 cars sold            1 cars sold         1 cars
sold
1/7/05                    4 cars sold            1 cars sold         0 cars
sold

is this format possible with any control supplied with .NET?

1/8/05
Bob Powell [MVP] - 11 Feb 2005 13:55 GMT
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

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.