How do you check if SQLDataSource returns empty data

Tweet

A user asked me a simple way to determine if the SQLDataSource returns empty data.

Here's a simple way to do so: Use the OnSelected event of the SQLDataSource

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"

SelectCommand="SELECT [CustomerID], [CompanyName], [ContactName],

[ContactTitle], [Address] FROM [Customers]"

onselected="SqlDataSource1_Selected">

</asp:SqlDataSource>

C#

protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)

{

if (e.AffectedRows < 1)

{

// perform action

}

}

VB.NET

Protected Sub SqlDataSource1_Selected(ByVal sender As Object, ByVal e As SqlDataSourceStatusEventArgs)

If e.AffectedRows < 1 Then

' perform action

End If

End Sub

Note: As pointed out by a reader, this tip will not work if SQLDataSource caching is enabled.

Tweet

About The Author

Suprotim Agarwal, Developer Technologies MVP (Microsoft Most Valuable Professional) is the founder and contributor for DevCurry, DotNetCurry and SQLServerCurry. He is the Chief Editor of a Developer Magazine called DNC Magazine. He has also authored two Books - 51 Recipes using jQuery with ASP.NET Controls. and The Absolutely Awesome jQuery CookBook.

Follow him on twitter @suprotimagarwal.