owinterton

It works like a charm

Thanks SilverStormBoy. You have solved much of my frustration. I tried to set the connection string but I couldn't figure out how to make it work the way I wanted it. Thanks a bunch.

So I finally figured out how to make it all work. I created my code to draw the lines and the points in a Picturebox1.Paint() event. In the form load I set the background of the picturebox to "white" thus making the picturebox have to re-paint itself, which then calls my code and makes the lines that I want while keeping it on the screen during scrolling. The next problem that I have is now that I need to find out where lines intersect each other. I was trying to use the Point-Slope method to find the slope of the line and then generate an equation from that to determine where the intersection point of the two lines occurred. That has gone horribly afoul since I can't figure out why I keep getting different equations everytime. Can anyone tell me a faster, better way of figuring out how to come up with an intersection point for the two lines?

I goofed, I mean't to say the Graph is dynamically creating labels based on the information from our database, not "on our database".

I kind of figured that I was being confusing. I appreciate you all for tolerating my ignorance. My goal is to create a string line program to graph where Trains go based on station times (X coordinate) and Train Stations (Y coordinate). So I'm developing it on a screen that is 1024 x 768. The form that I am creating, is dynamically created based on our database which stores all of the train stations (Y) and all of the station times which each train stops at (X). For Testing Purposes I'm using a 2 dimensional array to simulate the data that needs to be stored. From there I'm translating the arrival times of the trains into points based on how the coinciding labels of times as well as train stations. Because I have so many times (24 hour clock each spaced 60 pixels apart) the screen is larger than 1024x768 so it needs a scroll bar. When I draw the line, it works perfectly (thanks to those above for the info). However, when I scroll right, the line redraws itself twice or multiple times depending on how far I scroll. What I want to accomplish is to draw the line so that it coincides with its corresponding time, but when I scroll for it to dissappear so that I can see the other times and other lines. When I scroll back to it, I would like to see it back in its original place. Currently the line that I've drawn keeps drawing across the screen so I get a flag-like picture, which disappears when I scroll back to it. What do you suggest would be the best way because I've never had to do graphics like this before?

Ok, that works brilliantly Thanks so much. However, now I have another dilemma. Everytime I scroll (I set the scrolling property on the form to true) the picture repaints itself in the position it thinks it should be in (which is probably due to the way I have my coordinates set up) instead of staying where I want it to be off of the visible screen. How can I keep the lines that I want drawn in the same place and then once I scroll back to it, have it redraw itself? The form that I am creating dynamically is bigger than my screen so I have to have a scroll to make it visible to the user. Would my code be helpful because I feel like I'm probably confusing everyone.

Do you have any snipits of code syntax that you could show me because I don't know how to use the invalidate method. Sorry, I'm a bit new to .NET. Thanks.

I'm having a problem redrawing the data that I want to show in a form. I am trying to draw on a form that is bigger than normal so it has a scroll bar to expand the window. On that window I'm trying to draw lines (much like a line chart). The lines are being plotted from information from my database. I take the information from the database and create coordinates to plot the data. However, when I scroll left or right, the lines that I've already drawn disappear completely never to be seen again. In VB6 it has the autoRedraw function but I've found out that no longer applies. I've read up on how to draw static points using the paint method. But, how do I redraw the data when I'm creating dynamic plotting points?

If I were you I would try to format the date from the textboxes into variables. It might be easier when you put it into the SQL statement.

Since my app is going to live on a Windows 2000 SQL Server, I am trying to use the windows username and password for my app. How do I go about using the log in or accessing the username and password for the current user? I have found VB6 code but it doesn't work in my app for .NET. Any suggestions?

I've found a way to include it in the deployment package however I haven't found a way to allow the database connection to be specified by the user at install. It still looks for the path that I set for it where it was being developed.

I am trying to develop my windows application and make the connection to the database as flexible as possible so that when I deploy it, the app will work on anyone's computer and the user can identify the path where the database will live. I am new to VB.net so I have no clue as to how to set the connection string so that it will know where the path is at all times. I'm working with VB.net for Windows apps and an Access database. I am trying to migrate the access database to an Windows 2000 SQL Server eventually. Any ideas out there to help solve my dilemma?