sqldataadapter

Hi, Im after some advice on how i go about opening my sqlConnection. At the moment when my program is first run i open the sqlConnection and this is made as a public object so i can reference throughout the program without having to close it untill i close the program. I thought this was fine...

Probably various ways of doing this and reasons why some ways are better than others. I am probably not going about things the best way but owing to my limited experience, it is what it is and any help would be much appreciated. I have pulled data from a sql database, put into a...