What is this for "Catch ex As Exception"

[momo]

I need someone to please explain what the "TRY" does and how it work. How do
I know if it is working or not.


I have this in my code and I don't know what it does, especially this "Catch
ex As Exception"

Try
'Create the connection and command objects
oConn = GetMsAccessOledbConnection(Pathdb, "admin", "")
'oConn = New OleDbConnection(sConn)

oComm = New OleDbDataAdapter(sComm, oConn)
'Fill the dataset with the results of the query
oComm.Fill(oDataSet, "Employees")

'Set the grid source to the dataset and bind the data
oGrid.DataSource=oDataSet.Tables("Employees").DefaultView
oGrid.DataBind()
Catch ex As Exception
'if there is a database error, it will get caught here
oDataSet = Nothing
Finally
'Ensure that the objects are disposed
oComm.Dispose()
oConn.Dispose()
End Try

--


Thanks,


Moses Nueman
Nueman Technologies
http://www.NuemanTech.com
Ph: 704-644-1220
Fax: 704-675-5169

 

[Erik Funkenbusch]

I need someone to please explain what the "TRY" does and how it work. How do
I know if it is working or not.

Stop your database server, then step through the code in the debugger.
You'll notice right away what it does.

Otherwise, look here:

http://www.c-sharpcorner.com/vbnet/vbarticles/VBASPExHSSK.asp
http://www.vbdotnetheaven.com/Code/Jun2003/2009.asp

 

[momo]

Thanks Erik for the info.

Stop your database server, then step through the code in the debugger.
You'll notice right away what it does.

Otherwise, look here:

http://www.c-sharpcorner.com/vbnet/vbarticles/VBASPExHSSK.asp
http://www.vbdotnetheaven.com/Code/Jun2003/2009.asp