[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:

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
2 Solutions
Jorge PaulinoIT Pro/DeveloperCommented:
Can you show us some code ? What changes do you make and what you mean with lost?
.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).
mjs082969Author Commented:
Sorry, it was in ID 10T error.


Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now