Adding to a dataset

[Philip Townsend]

I have a user control that populates a dataset from a stored procedure.
In the event that the stored procedure returns an empty result set, I
want to add a record to the dataset indicating to the user that the
search returned nothing. How should I add a value to the dataset?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Dmitriy Lapshin [C# / .NET MVP]]

Philip,

You cannot add a row to a data set, but you definitely can add a row to a
data table.
Add a new data table to the data set, set up a single string column for this
data table, and then add a row with the explanation text with the table's
AddRow method.

--
Dmitriy Lapshin [C# / .NET MVP]
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE

"Philip Townsend" <pt*******@v1tech.com> wrote in message
news:Ol**************@tk2msftngp13.phx.gbl...

I have a user control that populates a dataset from a stored procedure.
In the event that the stored procedure returns an empty result set, I
want to add a record to the dataset indicating to the user that the
search returned nothing. How should I add a value to the dataset?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!