SqlBound (12/13/2013)
what exactly is returned to VB.NET from a called stored procedure when no data is found?
That depends on the procedure AND the .NET code. I will make some assumptions based on the title of your post.
Assuming your code is getting a DataSet AND that your procedure has a single select statement to return a single dataset...
If the above is true then you will get a DataSet with a single table that matches the definition of the query but it will not have any rows.
MyDataSet.Tables[0].Rows.Count = 0
MyDataSet.Tables[0].Columns.Count = the number of columns in the select statement in your procedure.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/