"tshad" <tscheider***@ftsolutions.com> wrote in message
news:O13OQ%2348EHA.2316@TK2MSFTNGP15.phx.gbl...
> I have a dataset that I am going to navigate through and need to set up an
> array beforehand.
>
> ******************************************
>  Dim oData as new DataSet()
>  Dim oAdpt as new SqlDataAdapter(sQuery,objConn)
>  oAdpt.Fill(oData,"tempTable")
>
>  for each dr as datarow in oData.Tables(0).Rows
>   trace.warn("Inside Datarow navigation" & dr("answer"))
>  next
> *******************************************
>
> Is there a property (oData.Tables(0).?) that would tell me how many rows
are
> in the table that were returned?
>
> Thanks,
>
> Tom.
>
>

>
> regards
> Joyjit
>
> "tshad" <tscheider***@ftsolutions.com> wrote in message
> news:O13OQ%2348EHA.2316@TK2MSFTNGP15.phx.gbl...
>> I have a dataset that I am going to navigate through and need to set up
>> an
>> array beforehand.
>>
>> ******************************************
>>  Dim oData as new DataSet()
>>  Dim oAdpt as new SqlDataAdapter(sQuery,objConn)
>>  oAdpt.Fill(oData,"tempTable")
>>
>>  for each dr as datarow in oData.Tables(0).Rows
>>   trace.warn("Inside Datarow navigation" & dr("answer"))
>>  next
>> *******************************************
>>
>> Is there a property (oData.Tables(0).?) that would tell me how many rows
> are
>> in the table that were returned?
>>
>> Thanks,
>>
>> Tom.
>>
>>
>
>

"tshad" <tscheider***@ftsolutions.com> wrote in message
news:ut4FSNB9EHA.3616@TK2MSFTNGP11.phx.gbl...
>
> "Joyjit Mukherjee" <joyjit_mukher***@hotmail.com> wrote in message
> news:eqSdqt68EHA.2276@TK2MSFTNGP09.phx.gbl...
>> oData.Tables[0].Rows.Count
>
> Tried that and got the following message:
> *********************************************************************
> Compiler Error Message: BC30311: Value of type
> 'System.Data.DataTableCollection' cannot be converted to 'Integer'.
>
> Source Error:
>
> Line 449: dim temp as integer
> Line 450:
> Line 451: temp = oData.Tables[0].Rows.Count
> Line 452:trace.warn("Number of rows in table - " & temp)
> Line 453:
> ****************************************************************************
>
> Am I missing something?

>
> Thanks,
>
> Tom
>
>>
>> regards
>> Joyjit
>>
>> "tshad" <tscheider***@ftsolutions.com> wrote in message
>> news:O13OQ%2348EHA.2316@TK2MSFTNGP15.phx.gbl...
>>> I have a dataset that I am going to navigate through and need to set up
>>> an
>>> array beforehand.
>>>
>>> ******************************************
>>>  Dim oData as new DataSet()
>>>  Dim oAdpt as new SqlDataAdapter(sQuery,objConn)
>>>  oAdpt.Fill(oData,"tempTable")
>>>
>>>  for each dr as datarow in oData.Tables(0).Rows
>>>   trace.warn("Inside Datarow navigation" & dr("answer"))
>>>  next
>>> *******************************************
>>>
>>> Is there a property (oData.Tables(0).?) that would tell me how many rows
>> are
>>> in the table that were returned?
>>>
>>> Thanks,
>>>
>>> Tom.
>>>
>>>
>>
>>
>
>

"tshad" <tscheider***@ftsolutions.com> wrote in message
news:ut4FSNB9EHA.3616@TK2MSFTNGP11.phx.gbl...
>
> "Joyjit Mukherjee" <joyjit_mukher***@hotmail.com> wrote in message
> news:eqSdqt68EHA.2276@TK2MSFTNGP09.phx.gbl...
> > oData.Tables[0].Rows.Count
>
> Tried that and got the following message:
> *********************************************************************
>  Compiler Error Message: BC30311: Value of type
> 'System.Data.DataTableCollection' cannot be converted to 'Integer'.
>
> Source Error:
>
> Line 449: dim temp as integer
> Line 450:
> Line 451: temp = oData.Tables[0].Rows.Count
> Line 452:trace.warn("Number of rows in table - " & temp)
> Line 453:
>
****************************************************************************
>
> Am I missing something?
>
> Thanks,
>
> Tom
>
> >
> > regards
> > Joyjit
> >
> > "tshad" <tscheider***@ftsolutions.com> wrote in message
> > news:O13OQ%2348EHA.2316@TK2MSFTNGP15.phx.gbl...
> >> I have a dataset that I am going to navigate through and need to set up
> >> an
> >> array beforehand.
> >>
> >> ******************************************
> >>  Dim oData as new DataSet()
> >>  Dim oAdpt as new SqlDataAdapter(sQuery,objConn)
> >>  oAdpt.Fill(oData,"tempTable")
> >>
> >>  for each dr as datarow in oData.Tables(0).Rows
> >>   trace.warn("Inside Datarow navigation" & dr("answer"))
> >>  next
> >> *******************************************
> >>
> >> Is there a property (oData.Tables(0).?) that would tell me how many
rows
> > are
> >> in the table that were returned?
> >>
> >> Thanks,
> >>
> >> Tom.
> >>
> >>
> >
> >
>
>