How can I check for Zero rows from SQL SqlDataSource in C#?

Question

Does anybody know a good way of finding out if a SqlDataSource will return Zero Rows?

This is my call to the SQL Database in my C# code behind:

        string SQL_PROD_DOCS =
            @"SELECT   TOP 3  Documents.ProductID, Documents.ProjectID, Documents.DocTitle, Documents.DocURL
              FROM         Products INNER JOIN
                  Documents ON Products.ID = Documents.ProductID
              WHERE     (Products.ShowOnScorecard = 1) AND (Products.Deleted = 0) AND (Products.ID = 15) AND (Documents.ProjectID IS NULL) AND (Documents.Deleted = 0) AND (Documents.AttributeID = 1)";


        SqlDataSource dsProdDocsHeader = new SqlDataSource(utils.Conn(Server.MachineName), SQL_PROD_DOCS);
        RptrProductDocs.DataSource = dsProdDocsHeader.Select(DataSourceSelectArguments.Empty);
        RptrProductDocs.DataBind();

I want to find if dsProdDocsHeader will return zero so I can return a different message instead.
Thank you!

I'd build an object from the datareader, check that for a 0 Count and then Bind it. — Kevin DeVoe
– Kevin DeVoe, Commented Aug 9, 2013 at 17:33

Raghubar · Accepted Answer · 2013-08-09 17:42:44Z

2

Try This.

    SqlDataSource dsProdDocsHeader = new SqlDataSource(utils.Conn(Server.MachineName), SQL_PROD_DOCS);
    DataView dvsqllist = (DataView)dsProdDocsHeader.Select(DataSourceSelectArguments.Empty);
    DataTable tablelist = dvsqllist.Table;
    int n = tablelist.Rows.Count;
    if (n > 0)
    {
       RptrProductDocs.DataSource = dsProdDocsHeader.Select(DataSourceSelectArguments.Empty);
       RptrProductDocs.DataBind();
    }
    else
    {
       // whatever u want to show.
    }

answered Aug 9, 2013 at 17:42

Raghubar

2,7981 gold badge23 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pleun · Accepted Answer · 2013-08-09 17:37:20Z

1

The repeater does not have an EmptyData template (assuming Rptr=repeater).

SO have a look here: http://devcenter.auburnrandall.com/EmptyRepeaterData.aspx

answered Aug 9, 2013 at 17:37

Pleun

8,9102 gold badges32 silver badges51 bronze badges

Comments

IceCode · Accepted Answer · 2013-08-09 18:28:19Z

1

The select method returns a DataView object, you can check the Count propertie to se if any records have been returned:

SqlDataSource dsProdDocsHeader = new SqlDataSource(utils.Conn(Server.MachineName), SQL_PROD_DOCS);
DataView view = (DataView)dsProdDocsHeader.Select(DataSourceSelectArguments.Empty);

    if (view.Count == 0)
    {
        lblMessage.Text = "Message!!!";
    }
    else
    {
        RptrProductDocs.DataSource = view;
        RptrProductDocs.DataBind();
    }

answered Aug 9, 2013 at 18:28

IceCode

1,7591 gold badge14 silver badges25 bronze badges

Collectives™ on Stack Overflow

How can I check for Zero rows from SQL SqlDataSource in C#?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related