Working with a ADO(.Net) DataSet

[seanb]

I already have a populated ADO.Net DataSet. I need to issue queries to this DataSet. The query will be an Update SQL Statement.

So far I have figured out how to issue a SqlCommand state to issue the query but they all require a SQLConnection object. I need some help conencting to an in memory Dataset.

Help...

[seanb]

I managed to accomplish what I need to get done. I am just accessing the Rows/Columns collections and directly changing the values as needed. The problem with such a scheme is that I must iterate thruy the rows which more time consuming then what I was looking for.

If anyone knows of a way to modify DataSets (rather then the DataSource from which they came from) via a SQL Statement please let me know...

Thanks!

[programatix]

You seems to be missing something. You cannot run a SQL statement on a dataset. It represents an in-memory cache of data. Which mean, everytime you call the Fill method of a DataAdapter, it will load everything into the dataset.