Printable View
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...
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!
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.