Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Professional C#, 2nd and 3rd Editions
This is the forum to discuss the Wrox book Professional C#, 3rd Edition by Simon Robinson, Christian Nagel, Karli Watson, Jay Glynn, Morgan Skinner, Bill Evjen; ISBN: 9780764557590
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional C#, 2nd and 3rd Editions section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 3rd, 2004, 11:24 PM
Authorized User
 
Join Date: Dec 2003
Location: , , .
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to StreetSweaper Send a message via MSN to StreetSweaper
Default Diagrams?

Hello!
i am writing a program that uses an access 2003 database. I want to show diagrams from the database. How can i do that i C#?
By that i mean creating a diagram from the values in the database!


Best regards StreetSweaper


 
Old January 4th, 2004, 05:38 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi there,

You have been asking the exact same question for the past two weeks now.

You have received a number of answers. From this new post, I assume the answers are now what you're looking for, but how about you tell that to the people who replied, so they can reformulate their answer, or give you other hints and suggestions. That makes it a lot easier for everyone and show your appreciation for their reply.

Try to explain what you're doing. Explain what you already know and don't know. Explain what you have already done and searched for. I assume you want to display the diagrams like SQL Server Diagrams or the Access Relation Designer, but I am not sure about that.

Can you please not double / triple post to these forums? Your message will be read anyway.....


Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old January 4th, 2004, 06:29 AM
Authorized User
 
Join Date: Dec 2003
Location: , , .
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to StreetSweaper Send a message via MSN to StreetSweaper
Default

ok, lets start over again.
The database looks like this:

I have two tables.
one is called HuvudAktivitet and the other UnderAktivitet.
the first one has 4 columns:
1: HuvudAktivitetNr Counter [PK]
2:TotalTime number
3:TotalOverTime number
4:HuvudAktivitetsNamn Text(50)

the second has moore columns:
1:UnderAktivitetsNamn Text(50)
2:MaxTid number(double)
3:ArbetadTid number(double)
4:VarningsTid number(double)
5:OverTime number(double)
6:Progress Integer
7:Comments text(250)
8:HuvudAktivitetNr counter[fk]

The program is an application i C# language, and it main function is to log the time for an activity for example(read email), and after a while to be able to track where time have been spent on doing what.

What i want to do is take the values inside the table HuvudAktivitet and show theese as a diagram.
I don't have any clue how to do this. I have searched msdn, access help, and i haven't found anything that can be of help.


 
Old January 4th, 2004, 06:33 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

What kind of diagram? Like a chart or graph or something?

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old January 4th, 2004, 06:53 AM
Authorized User
 
Join Date: Dec 2003
Location: , , .
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to StreetSweaper Send a message via MSN to StreetSweaper
Default

The diagram should be a graph.
Like staples. Hope you understand what i mean.

 
Old January 4th, 2004, 07:01 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Right.

Well, in that case, you have at couple of options. First, you can do (a lot of / some) programming yourself in GDI+. Take a look here:

http://www.google.com/search?hl=en&l...=Google+Search

and here:
http://msdn.microsoft.com/msdnmag/is...w/default.aspx

This second link is for ASP.NET but you can use the same tricks for the desktop.

Alternatively, you can buy third party controls. There are many available, including Dundas: http://www.dundas.com/home/index.aspx.
It seems they just licensed their product to Microsoft for SQL Server reporting services, so that looks good.

You didn't say what your application will run on, so there may be other solutions as well:

1. Use Microsoft Excel. It has some nice graphing capabilities.
2. Use reporting tools, like Business Objects or Chrystal Reports


Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old June 8th, 2006, 01:10 AM
Registered User
 
Join Date: Jun 2006
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hi
maybe this link be usful for you (http://www.e-charts.com)
thanks





Similar Threads
Thread Thread Starter Forum Replies Last Post
Diagrams jbenson001 SQL Server 2000 3 March 31st, 2005 01:51 AM
Diagrams? StreetSweaper C# 2 January 4th, 2004 06:24 AM
Diagrams? StreetSweaper Access 1 January 4th, 2004 05:38 AM
diagrams yagiroy SQL Server 2000 6 June 28th, 2003 01:39 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.