By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,652 Members | 1,694 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,652 IT Pros & Developers. It's quick & easy.

Can I have a second TRY inside the first TRY/CATCH in ASP.NET ???

P: n/a

Hi all,

I'd like to use TRY, CATCH to open my database connection. I have 2 servers
that have the same table name "myTable". If the first connection to Server1
is failed, then the program will try to connect to Server2. Can I have the
secong Try inside the first Catch for this purpose ?. Please take a look on
my code and fix it if possible. Actually with this code, the database
connection with Server2 is opened after the first connection to Server1 is
failed.

Thanks in advance .
Dim myStr As String ="Select * from myTable"
Dim myConnection as ODBCConnection
Dim myCommand as ODBCCommand
Dim myRec as ODBCDataReader
Dim strConn as string =
"server=Server1;uid=UserID1;pwd=Password1;DSN=Serv er1"
Dim strConn as string =
"server=Server2;uid=UserID2;pwd=Password2;DSN=Serv er2"
Try
myConnection = New ODBCConnection(strConn)
myConnection.Open()
myCommand = New OdbcCommand(myStr, myConnection)
myCommand.ExecuteNonQuery()
myConnection.Close
Dim myDataSet as DataSet=GetDataSource()
myDataList.DataSource = myDataSet
myDataList.DataBind()
Catch Exc1 As Exception
Try
myConnection = New ODBCConnection(strConn2)
myConnection.Open()
myCommand = New OdbcCommand(myStr, myConnection)
myCommand.ExecuteNonQuery()
myConnection.Close
Dim myDataSet as DataSet=GetDataSource()
myDataList.DataSource = myDataSet
myDataList.DataBind()
Catch Exc2 As Exception
response.write("<BR>Database connection is failed ..")
End Try
End Try
Nov 19 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Ben
Your syntax looks ok. Have you considered writing a method to return an
open connection? That way you're code doesn't get junked up with try catch
blocks all over the place?

"bienwell" <bi******@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hi all,

I'd like to use TRY, CATCH to open my database connection. I have 2
servers
that have the same table name "myTable". If the first connection to
Server1
is failed, then the program will try to connect to Server2. Can I have the
secong Try inside the first Catch for this purpose ?. Please take a look
on
my code and fix it if possible. Actually with this code, the database
connection with Server2 is opened after the first connection to Server1 is
failed.

Thanks in advance .
Dim myStr As String ="Select * from myTable"
Dim myConnection as ODBCConnection
Dim myCommand as ODBCCommand
Dim myRec as ODBCDataReader
Dim strConn as string =
"server=Server1;uid=UserID1;pwd=Password1;DSN=Serv er1"
Dim strConn as string =
"server=Server2;uid=UserID2;pwd=Password2;DSN=Serv er2"
Try
myConnection = New ODBCConnection(strConn)
myConnection.Open()
myCommand = New OdbcCommand(myStr, myConnection)
myCommand.ExecuteNonQuery()
myConnection.Close
Dim myDataSet as DataSet=GetDataSource()
myDataList.DataSource = myDataSet
myDataList.DataBind()
Catch Exc1 As Exception
Try
myConnection = New ODBCConnection(strConn2)
myConnection.Open()
myCommand = New OdbcCommand(myStr, myConnection)
myCommand.ExecuteNonQuery()
myConnection.Close
Dim myDataSet as DataSet=GetDataSource()
myDataList.DataSource = myDataSet
myDataList.DataBind()
Catch Exc2 As Exception
response.write("<BR>Database connection is failed ..")
End Try
End Try

Nov 19 '05 #2

P: n/a
I would probably put each set of code in the try blocks in its own function.
Have the function return a boolean that says whether or not the function
suceeded. Inside the function is the try/catch, return True in the Try,
False in the catch.

You first call the first function. If it returns True, you are done.
Otherwise you call the second function. If it return True, you are done,
otherwise you display an error message.

In theory you can nest try/catch blocks all you want, but your code is going
to be come very difficult to read and debug.

"bienwell" <bi******@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hi all,

I'd like to use TRY, CATCH to open my database connection. I have 2
servers
that have the same table name "myTable". If the first connection to
Server1
is failed, then the program will try to connect to Server2. Can I have the
secong Try inside the first Catch for this purpose ?. Please take a look
on
my code and fix it if possible. Actually with this code, the database
connection with Server2 is opened after the first connection to Server1 is
failed.

Thanks in advance .
Dim myStr As String ="Select * from myTable"
Dim myConnection as ODBCConnection
Dim myCommand as ODBCCommand
Dim myRec as ODBCDataReader
Dim strConn as string =
"server=Server1;uid=UserID1;pwd=Password1;DSN=Serv er1"
Dim strConn as string =
"server=Server2;uid=UserID2;pwd=Password2;DSN=Serv er2"
Try
myConnection = New ODBCConnection(strConn)
myConnection.Open()
myCommand = New OdbcCommand(myStr, myConnection)
myCommand.ExecuteNonQuery()
myConnection.Close
Dim myDataSet as DataSet=GetDataSource()
myDataList.DataSource = myDataSet
myDataList.DataBind()
Catch Exc1 As Exception
Try
myConnection = New ODBCConnection(strConn2)
myConnection.Open()
myCommand = New OdbcCommand(myStr, myConnection)
myCommand.ExecuteNonQuery()
myConnection.Close
Dim myDataSet as DataSet=GetDataSource()
myDataList.DataSource = myDataSet
myDataList.DataBind()
Catch Exc2 As Exception
response.write("<BR>Database connection is failed ..")
End Try
End Try

Nov 19 '05 #3

P: n/a
That's a good idea. I will try it. Thank you.
"Ben" <be*@online.nospam> wrote in message
news:8f***************************@FUSE.NET...
Your syntax looks ok. Have you considered writing a method to return an
open connection? That way you're code doesn't get junked up with try catch blocks all over the place?

"bienwell" <bi******@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hi all,

I'd like to use TRY, CATCH to open my database connection. I have 2
servers
that have the same table name "myTable". If the first connection to
Server1
is failed, then the program will try to connect to Server2. Can I have the secong Try inside the first Catch for this purpose ?. Please take a look
on
my code and fix it if possible. Actually with this code, the database
connection with Server2 is opened after the first connection to Server1 is failed.

Thanks in advance .
Dim myStr As String ="Select * from myTable"
Dim myConnection as ODBCConnection
Dim myCommand as ODBCCommand
Dim myRec as ODBCDataReader
Dim strConn as string =
"server=Server1;uid=UserID1;pwd=Password1;DSN=Serv er1"
Dim strConn as string =
"server=Server2;uid=UserID2;pwd=Password2;DSN=Serv er2"
Try
myConnection = New ODBCConnection(strConn)
myConnection.Open()
myCommand = New OdbcCommand(myStr, myConnection)
myCommand.ExecuteNonQuery()
myConnection.Close
Dim myDataSet as DataSet=GetDataSource()
myDataList.DataSource = myDataSet
myDataList.DataBind()
Catch Exc1 As Exception
Try
myConnection = New ODBCConnection(strConn2)
myConnection.Open()
myCommand = New OdbcCommand(myStr, myConnection)
myCommand.ExecuteNonQuery()
myConnection.Close
Dim myDataSet as DataSet=GetDataSource()
myDataList.DataSource = myDataSet
myDataList.DataBind()
Catch Exc2 As Exception
response.write("<BR>Database connection is failed ..")
End Try
End Try


Nov 19 '05 #4

P: n/a
Thank you, Marina. I will keep up with your idea.

"Marina" <so*****@nospam.com> wrote in message
news:eb**************@tk2msftngp13.phx.gbl...
I would probably put each set of code in the try blocks in its own function. Have the function return a boolean that says whether or not the function
suceeded. Inside the function is the try/catch, return True in the Try,
False in the catch.

You first call the first function. If it returns True, you are done.
Otherwise you call the second function. If it return True, you are done,
otherwise you display an error message.

In theory you can nest try/catch blocks all you want, but your code is going to be come very difficult to read and debug.

"bienwell" <bi******@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Hi all,

I'd like to use TRY, CATCH to open my database connection. I have 2
servers
that have the same table name "myTable". If the first connection to
Server1
is failed, then the program will try to connect to Server2. Can I have the secong Try inside the first Catch for this purpose ?. Please take a look
on
my code and fix it if possible. Actually with this code, the database
connection with Server2 is opened after the first connection to Server1 is failed.

Thanks in advance .
Dim myStr As String ="Select * from myTable"
Dim myConnection as ODBCConnection
Dim myCommand as ODBCCommand
Dim myRec as ODBCDataReader
Dim strConn as string =
"server=Server1;uid=UserID1;pwd=Password1;DSN=Serv er1"
Dim strConn as string =
"server=Server2;uid=UserID2;pwd=Password2;DSN=Serv er2"
Try
myConnection = New ODBCConnection(strConn)
myConnection.Open()
myCommand = New OdbcCommand(myStr, myConnection)
myCommand.ExecuteNonQuery()
myConnection.Close
Dim myDataSet as DataSet=GetDataSource()
myDataList.DataSource = myDataSet
myDataList.DataBind()
Catch Exc1 As Exception
Try
myConnection = New ODBCConnection(strConn2)
myConnection.Open()
myCommand = New OdbcCommand(myStr, myConnection)
myCommand.ExecuteNonQuery()
myConnection.Close
Dim myDataSet as DataSet=GetDataSource()
myDataList.DataSource = myDataSet
myDataList.DataBind()
Catch Exc2 As Exception
response.write("<BR>Database connection is failed ..")
End Try
End Try


Nov 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.