MSSQL Nested Queries

Hi,

I have been trying to write a nested query, however i am facing errors while executing that.

The code is as below.

<%

Dim MyConnection = New SqlConnection()

MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings("AppConnectionString1").ConnectionString

MyConnection.Open()

Dim cmd As New SqlCommand

Dim rs As SqlDataReader

Dim rs2 As SqlDataReader

Dim query = "select count(bank_id) from bank_master"

Dim query2 As String

cmd.CommandType = CommandType.Text

cmd.Connection = MyConnection

cmd.CommandText = query

rs = cmd.ExecuteReader

If rs.Read() Then

Dim rec = rs(0)

If (rec > 0) Then

Response.Write(rec & " banks registered in the system")

rs.Close()

query2 = "select * from bank_master order by bank_id"

rs2 = cmd.ExecuteReader(query2)

If rs2.Read() Then

Response.Write(rs2(0))

Else

Response.Write("No banks yet registered in the system")

End If

Else

Response.Write("No banks yet registered in the system")

End If

End If

%>

 

The error message that i am getting at runtime:



Server Error in '/Accounts' Application.


Input string was not in a correct format.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: Input string was not in a correct format.

Source Error:







Line 117:
Line 118: query2 = "select * from bank_master order by bank_id"
Line 119: rs2 = cmd.ExecuteReader(query2)
Line 120: If rs2.Read() Then
Line 121: Response.Write(rs2(0))


Source File: E:WEBHOMEAccountsank.aspx    Line: 119

 Could you please help?

 

Best Regards,

Debashis