Working with datasets
Posted on 2005-04-01
Alright here we go!! I'm writing an app and for that apps datastore I want to use a couple xml files. My vision is that when the app loads it reads the xml into a dataset that I work with while the app is running and then write that dataset back to xml upon closing the application, sounds simple enough right!! Here is where my idea goes downhill. I don't know how to "work" with the data in the dataset. Say I wanted to delete all records with say an "A" in the status field. If I were working against a database I'd say "delete * from table where status = A", how do I do that when referring to a dataset? Can I use a dataadapter that points to the dataset? Basically I would like to use sql against a dataset but have a feeling that can't be done. If so do I need to learn xquery or something of that sort.
Extreme appriciation to whomever is able to help me with this.