count rows in dataset...

  • Thread starter Thread starter Chris Wilmot
  • Start date Start date
C

Chris Wilmot

Try

MyDataset.Tables(0).Rows.Count

Chris Wilmot
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 @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP &
Click to expand...
ASP.NET resources...
 
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 @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
 
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 said:
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 @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP &
Click to expand...
ASP.NET resources...
 
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 @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
 
Back
Top