How do you determine the size of the dataset [the record count] delivered by a SqlDataSource?

Hello Everyone,

I am using VB and ASP.Net to build a web application with VS.2005.

I have a SqlDataSource defined and am using it to populate a table [Array].

Is there an easy way to determine the size of the dataset [the record count]
delivered by a SqlDataSource?

Any pointers would be greatly appreciated.

Bob

[Showjumper]

Have you tried the count function in sql
Example
SELECT COUNT(*) as "Number of employees"
FROM employees
WHERE salary > 25000;

<BS***@newsgroups.nospam> wrote in message
news:pa***********************@ue.ph...

Hello Everyone,

I am using VB and ASP.Net to build a web application with VS.2005.

I have a SqlDataSource defined and am using it to populate a table
[Array].

Is there an easy way to determine the size of the dataset [the record
count]
delivered by a SqlDataSource?

Any pointers would be greatly appreciated.

Bob

[Daniel TIZON]

You can subscribe to the folowing event, and read the AffectedRows property

Protected Sub SqlDataSource1_Selected(ByVal sender As Object, ByVal e As
System.Web.UI.WebControls.SqlDataSourceStatusEvent Args) Handles
SqlDataSource1.Selected
Label1.Text = String.Format("rows count: {0}", e.AffectedRows)
End Sub

--
Daniel TIZON
MCP - MCSD.NET - MCT

<BS***@newsgroups.nospam> a écrit dans le message de news:
pa***********************@ue.ph...

Hello Everyone,

I am using VB and ASP.Net to build a web application with VS.2005.

I have a SqlDataSource defined and am using it to populate a table
[Array].

Is there an easy way to determine the size of the dataset [the record
count]
delivered by a SqlDataSource?

Any pointers would be greatly appreciated.

Bob