Can i actually setup database queries before the application.run in the program.cs file? I just looked and I can, but I can't declare the required database variables anywhere because its a static class. This is turning out to be much more trouble than I thought.

What do you mean you can't declare them? Did you declare them as static?

It would probably be less of a pain to not use global variables at all...

It probably would be easier not ot use global variables, but i don't really want to run the same db query on multiple user controls to get the same information.

Its not that I am displaying duplicate information. I will be displaying the players stats such as HP, MP, strength, etc, and then using these values in the battle formulas. I planned on using the global variables and get, set to ensure that the variables will always be up-todate. What I am ultimately trying to do is, when the player starts the game, all his/her data from the database gets "downloaded" into variables, arrays, etc. That way the amount of querying to the database would be a minimum and only necessary for none-player related queries such as whats in stock at stores, quest information, enemy information, etc. The global variables are working when I debug and run the game, but when I am in the editor, I am unable to modify my main windows form because one of the queries in the explore user control is sending back an error because it is not getting some of the global variables. I'm quite new at C# so while some of the suggestion may do things an easier and more effective way, I'm unsure of the speak that is being used. I learn by trial and error and now via tutorials.

You should put all the variables, arrays that are filled from the DB into a separate class, like a PlayerStats class. Then you create that object once when the program starts, and pass that single object to each UserControl. There's no duplicate database queries to worry about that way.

I've done that like you had suggested earlier. I have a class named global where all the variables are declared. So I guess now its just to figure out how to create that object first, then the windows form, and then after that is done the user controls. It needs to be initialized this way because the windows form is where all the variables declared in the global class are filled with their values.