DataSet contents

[ace333]

Is it possible to examine the contents of a dataset if you are using it when it comes to executing a stored procedure in c#. The procedure will add a row of data to the table in question. The procedure does not return anything at all. Will there be anything in the data set at all or is it only when you use say for example a select statement.

 

[ca8msm]

The dataset can be populated from either an SP or a select statement and you could simply count the records in the relevant table if you just want to know how many records exist e.g.

MyDataSet.Tables(0).Rows.Count

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[ace333]

no i dont want to count any rows in a table but lets say i add a row of data to a table through the data set. is there anything in the dataset after the stored procedure executes. I'm guessing not unless i specifically return something from the stored proc.

 

[ca8msm]

i add a row of data to a table through the data set. is there anything in the dataset after the stored procedure executes

So you are adding a row to the dataset, then running a stored procedure to add to those records? If so, then yes of course the dataset will contain rows, as it should include the row you have added and then the rows that are returned from the SP.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.