Re: Control over connection periode

[Terri Kelley]

Something like this:
Dim strConnect As String
strConnect = "Database = database; DataSource = server; User ID=user; Password=password;"
Dim cnConnect As New MySqlConnection(strConnect)
cnConnect.Open( )
Dim cmdNewEmp As String
cmdNewEmp = "Select * from emp"
Dim daNewEmp As New MySqlDataAdapter(cmdNewEmp, cnConnect)
'rest of the code...

cnConnect.Close( )

Connect will stay open for everything between the open and close.

tk