OLEDB, ADO.NET, Charts & NotePad

[Isadore]

After 36 hours of trying to open "Permissions" for Visual Studio to access *.mdb tables, without any luck, we gave up -- for the time being.

We turned to NotePad and created our data forum web site. We are using ChartDirector, an excellent graphics package, and of course, have no vb code behind pages as our html and vb are on the same *.aspx pages.

For any newcomers we will be more than happy to share any of the code running the program -- some SQL's were a bit touchy, but the grids, etc... work well enough.

The site can be found at:

http://frontpage.auburn.edu/icaae/index.aspx

On the main menu there is a button for the charts and graphs we have created. The code for any of these pages, in as much as it might help newcomers, we will be more than happy to share (it is currently under constant revision & additions). You can contact us at:

biochem3d@yahoo.com

...and many thanks to those at Tek-Tips for help along the way. When we conquer the Visual Studio problem we'll share the solution (Access denied to *.mdb files). By the way, for every 200 lines of code Visual Studio used, we used approximately 25 in NotePad. That is not to say that Visual Studio is to be avoided...no doubt it has many benefits...

By the way...anyone out there know the "html" command for "Previous Page?". A few of the Grids work best if the user could click on a link that pages back one page, instead of the current message "Use your back button on your browser.."

 

[link9]

javascript:

history.go(-1);

 

[Isadore]

Thanks link. I've been looking for that line for years.

 

[link9]

Isadore,

Those are nice charts. Did you use ChartDirector for them, or use the system.drawing to make them from scratch?

Curious because I've been playing with that product for a while, but haven't yet tried to make charts from scratch.

thx-
paul

 

[TomTT]

I've been using chart director for a while after using the system drawing namespace. You can get some pretty good charts from either, but chartdirector can produce them with a lot less coding and the parameters to control the chart are a lot more logical. If you print out the rather large chart director documentation (PDF file), it gives you a lot of useful documentation and you can be up with nice charts in an hour or so. I really like using this product and the e-mail only support is much better than I would have suspected.

 

[Isadore]

link: The *.pdf file is pretty straightforward; the only problems I had was setting up the arrays to pull the data out...if you want some examples let me know...ChartDirector is pretty straight forward..right now we are working with the Chart.NoValue property to populate fields where there are no data...and also dealing with the problem of the "absence" of a data point, for example, in a time series, a complete data (as well as the data) may be missing -- in the latter case we have to force the the timestamp and then populate the null values with a Chart.NoValue double...wd be glad to help..just let me know...