dataset recordcount returned via function

[drdave]

Hi

I have a situation where I call a function and return a dataset, this
works fine but I am trying to figure out the best way to send back to
the call page whether or not there are records returned.

What I'm tring to accomplish..

dgSearchResults .DataSource = ReportFour.GetR eport4
(ddlprovlist.Se lectedItem.Valu e,stryearval)
Dim RcdCount As Integer
RcdCount = Dset.Tables(0). Rows.Count.ToSt ring()
If RcdCount < 1
Response.Write ("No Matches")
Else
add datagrid to the page
dgSearchResults .DataBind ()
pnlSearchResult s.Controls.Add( dgSearchResults )
End If

My Function looks like this:
Public Shared Function GetReport4(ByVa l jur As Integer, ByVal year As
String) As DataSet
Dim connection As OracleConnectio n = New
OracleConnectio n(Configuration Settings.AppSet tings("connecti onstring"))

Dim storedParams(2) As OracleParameter
storedParams(0) = New OracleParameter ("jurid",
OracleDbType.In t32, ParameterDirect ion.Input)
storedParams(0) .Value = jur
storedParams(1) = New OracleParameter ("datefrom",
OracleDbType.Va rchar2, ParameterDirect ion.Input)
storedParams(1) .Value = year

storedParams(2) = New OracleParameter ("custom_cursor ",
OracleDbType.Re fCursor, ParameterDirect ion.Output)
storedParams(2) .Value = "custom_cur sor"

Dim dset As Dataset =
OracleHelperV2. ExecuteDataset( connection, CommandType.Sto redProcedure,
"REPORT_MW_CUST OMSEARCH_PKG.GE T_CUSTOMSEARCH" ,storedParams)

Select HttpContext.Cur rent.Session("L anguage")

Case "en-CA"
dset.Tables(0). Columns(6).Colu mnName = "provincena me"
Case "fr-CA"
dset.Tables(0). Columns(7).Colu mnName = "provincena me"

End Select

return dset

End Function
In my calling page I get err message that dset isn't declared, any
pointer on best way to handle this??

[drdave]

Solved..

k I used the dgrid.Items.Cou nt "After" databinding and it did the tirck
for me..

[Peter Rilling]

Why not just pass a NULL (NOTHING) back when there are no records?

<dr****@canoema il.com> wrote in message
news:11******** ************@o1 3g2000cwo.googl egroups.com...

Hi

I have a situation where I call a function and return a dataset, this
works fine but I am trying to figure out the best way to send back to
the call page whether or not there are records returned.

What I'm tring to accomplish..

dgSearchResults .DataSource = ReportFour.GetR eport4
(ddlprovlist.Se lectedItem.Valu e,stryearval)
Dim RcdCount As Integer
RcdCount = Dset.Tables(0). Rows.Count.ToSt ring()
If RcdCount < 1
Response.Write ("No Matches")
Else
add datagrid to the page
dgSearchResults .DataBind ()
pnlSearchResult s.Controls.Add( dgSearchResults )
End If

My Function looks like this:
Public Shared Function GetReport4(ByVa l jur As Integer, ByVal year As
String) As DataSet
Dim connection As OracleConnectio n = New
OracleConnectio n(Configuration Settings.AppSet tings("connecti onstring"))

Dim storedParams(2) As OracleParameter
storedParams(0) = New OracleParameter ("jurid",
OracleDbType.In t32, ParameterDirect ion.Input)
storedParams(0) .Value = jur
storedParams(1) = New OracleParameter ("datefrom",
OracleDbType.Va rchar2, ParameterDirect ion.Input)
storedParams(1) .Value = year

storedParams(2) = New OracleParameter ("custom_cursor ",
OracleDbType.Re fCursor, ParameterDirect ion.Output)
storedParams(2) .Value = "custom_cur sor"

Dim dset As Dataset =
OracleHelperV2. ExecuteDataset( connection, CommandType.Sto redProcedure,
"REPORT_MW_CUST OMSEARCH_PKG.GE T_CUSTOMSEARCH" ,storedParams)

Select HttpContext.Cur rent.Session("L anguage")

Case "en-CA"
dset.Tables(0). Columns(6).Colu mnName = "provincena me"
Case "fr-CA"
dset.Tables(0). Columns(7).Colu mnName = "provincena me"

End Select

return dset

End Function
In my calling page I get err message that dset isn't declared, any
pointer on best way to handle this??