Dataset always connected? [Resolved]

[salvelinus]

I have the code below, adapted from a book, in Sub New() of a form. It's used to populate some textboxes, and works fine (so far). The eventual aim is to have Next and Previous buttons to navigate the dataset.
But I don't see where the connection is ever closed. I'd rather have the dataset retrieve records, close the connection and re-open it for each separate click event. There could be upwards of 20 users at one time, so I don't want a permanent connection.
Should the code be in a stand alone sub, use a static variable, or what? Thanks.

[Shaggy Hiker]

Wouldn't you just use an ADO.NET disconnected dataset? That way you would open the connection, fill the dataset, close the connection, and not reopen it until you need to refresh the date (or save changes, if that's a possibility).

[Pirate]

Declare a member static variable of your connection obj . Then , declare create two methods , OpenDB() and CloseDB() . Both work like this :

If connObj.State = ConnectionState.Closed Then 'Change Closed to Open in CloseDB() method .
connObj.Open()
End If

Tip : Close the connection to the source after you're done.

[Pirate]

For the Next , Previous , Last , First navigations , try this demo .

[salvelinus]

Thanks. Never used ado.net before a couple days ago, or vb.net before end of last week. Worked in vb6 and eVB for a couple years.