count rows in dataset...

[Chris Wilmot]

Try

MyDataset.Tables(0).Rows.Count

Chris Wilmot
"John Pether" <john@<nospam>dotnetsites.net> wrote in message
news:ORC$H6cUDHA.2284@TK2MSFTNGP12.phx.gbl...

> I have the following code which loads a dataset into a datagrid:
> <code>
> ' Obtain Link information from Links table
> ' and bind to the datagrid control
>
> Dim links As New DNSite.LinksIndexDB()
>
> ' DataBind Links to DataGrid Control
>
> DG.DataSource = links.GetLinks(CatID)
> DG.DataBind()
> DLLegend.DataSource = links.GetGroups
> DLLegend.DataBind()
> TotalLinks =
> </code>
>
> TotalLinks needs to be the number of rows of data from the dataset

links.GetLinks

>
> Can anyone tell me how I access that info?
>
> thx:)
>
>
> ************************************************** ********************
> Sent via Fuzzy Software @ [url]http://www.fuzzysoftware.com/[/url]
> Comprehensive, categorised, searchable collection of links to ASP &

ASP.NET resources...

[John Pether (john@]

I have the following code which loads a dataset into a datagrid:
<code>
' Obtain Link information from Links table
' and bind to the datagrid control

Dim links As New DNSite.LinksIndexDB()

' DataBind Links to DataGrid Control

DG.DataSource = links.GetLinks(CatID)
DG.DataBind()
DLLegend.DataSource = links.GetGroups
DLLegend.DataBind()
TotalLinks =
</code>

TotalLinks needs to be the number of rows of data from the dataset links.GetLinks

Can anyone tell me how I access that info?

thx:)


************************************************** ********************
Sent via Fuzzy Software @ [url]http://www.fuzzysoftware.com/[/url]
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

[Saravana]

Before binding your datasource with datagrid, load it in local dataset and
then find out the count. For example,

Dataset1 = links.GetLinks(CatID)
Dataset1.tables(0).rows.count
DG.DataSource= DataSet1



--
Saravana
Microsoft India Community Star,
MCAD,SE,SD,DBA.


"John Pether" <john@<nospam>dotnetsites.net> wrote in message
news:ORC$H6cUDHA.2284@TK2MSFTNGP12.phx.gbl...

> I have the following code which loads a dataset into a datagrid:
> <code>
> ' Obtain Link information from Links table
> ' and bind to the datagrid control
>
> Dim links As New DNSite.LinksIndexDB()
>
> ' DataBind Links to DataGrid Control
>
> DG.DataSource = links.GetLinks(CatID)
> DG.DataBind()
> DLLegend.DataSource = links.GetGroups
> DLLegend.DataBind()
> TotalLinks =
> </code>
>
> TotalLinks needs to be the number of rows of data from the dataset

links.GetLinks

>
> Can anyone tell me how I access that info?
>
> thx:)
>
>
> ************************************************** ********************
> Sent via Fuzzy Software @ [url]http://www.fuzzysoftware.com/[/url]
> Comprehensive, categorised, searchable collection of links to ASP &

ASP.NET resources...

[John Pether (john@]

ok, so i wasn't able to do that in the code behind but I can do it in the function from the data access class file, see code below
So I have created a Dim TotalLinks and filled it but how do I access that from my page behind code??? any ideas?

<code>
Public Function GetLinks(ByVal CatID As Long) As DataSet
Dim myConnection As New SqlConnection(strConnection)
' Create Instance of Connection and Command Object
Dim myCommand As New SqlCommand("GetLinks", myConnection)

' Mark the Command as a SPROC
myCommand.CommandType = CommandType.StoredProcedure

' Add Parameters to SPROC

Dim parameterCatID As New SqlParameter("@CatID", SqlDbType.BigInt)
parameterCatID.Value = CatID
myCommand.Parameters.Add(parameterCatID)

'********ADDED*********
Dim TotalLinks As Long
TotalLinks = GetLinks.Tables(0).Rows.Count
'********ADDED*********

' Execute the command
myConnection.Open()
myCommand.ExecuteNonQuery()
myConnection.Close()

End Function

************************************************** ********************
Sent via Fuzzy Software @ [url]http://www.fuzzysoftware.com/[/url]
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...