Assigning null to OleDb.OleDbConnection

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

How can I assign a null value to a variable of type OleDb.OleDbConnection?

Thanks

Regards
 
John said:
How can I assign a null value to a variable of type
OleDb.OleDbConnection?
Click to expand...

dim con as OleDb.OleDbConnection

'...
con = Nothing

That's it?


Armin
 
Hi

How can I assign a null value to a variable of type OleDb.OleDbConnection?

Thanks

Regards
Click to expand...

C#'s "null" should be replaced with "Nothing" in Visual Basic.

But if you concerned with terminating the connection you should really
call connection.Close() or connection.Dispose() or just wrap the
connection object in a using block

Thanks,

Seth Rowe
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array of db connections with string subscription 7
ExecuteNonQuery: Error Cannot open action query '' 2
Exporting data to excel not working..... 3
Saving data to excel not working. Grrrrrr 1
0x80020003 DISP_E_MEMBERNOTFOUND When working with Excel Spreadsheet 0
An unhandled exception of type 'System.ExecutionEngineException' occurred in System.Data.dll 3
connection pooling for MS Access using OleDBConnection 1
Checking db connection open status 8

Back
Top