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

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.

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.

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

---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

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

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.

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