DataSet Usage IN VB.NET

I am converting an application from VB6, and I am reading a table in Access into a DataSet.  I do not need to make any changes to the original, but I do not wish to have a continual impact on the original database, as it is probably being used by other processes.  

I am making changes to the DataSet, including changes to the structure (adding a few columns), and then traversing the row collection and reformatting some of the information (padding, etc).  However, when I dump out the DataTable again, my changes have not taken place.

Thanks In Advance,

- Michael
mjs082969Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jorge PaulinoIT Pro/DeveloperCommented:
Can you show us some code ? What changes do you make and what you mean with lost?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Tommy11bCommented:
.Net has many differences in the file system and datasets from VB6. If you have simply upgraded the old dataset, I would suggest scrapping it and creating a new one from scratch in .Net. It seems like you have your query & table structure already made up, if thats the case I would use that to fill an Untyped dataset and then call the DataSet.WriteXmlSchema("yourFile.xsd") method to get you started on your new dataset. (simply saves some typing and manual entry).
0
mjs082969Author Commented:
Sorry, it was in ID 10T error.

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.