can't update access tables

[jamesmor]

i'm updating an app written by the guy before me, and having a heck of a time. I used to develop in VB, but never done anything in VB.net

i've updated the table with the new columns we needed
updated the xsd with the new column headings
updated his code adding lines for the datarows i need to send to the access datase

i'm assuming the data rows are populating correctly as when i output them with a msgbox they show the values they should

however, when the app runs the update none of my new values are carried over.


::Edit

figured out what i need to do, i need to update my table mappings and sql statements for my data adapter, however, for the life of me i can't figure out how to do this.

i don't know if it'll throw a wrench in the mix or not (or change things) but the database connection is set programmatically instead of in the connection object.



Can anyone give a helping hand to a VB.Net Newbie?

Thanks

 

[ripp3r]

i'm updating an app written by the guy before me, and having a heck of a time. I used to develop in VB, but never done anything in VB.net

i've updated the table with the new columns we needed
updated the xsd with the new column headings
updated his code adding lines for the datarows i need to send to the access datase

i'm assuming the data rows are populating correctly as when i output them with a msgbox they show the values they should

however, when the app runs the update none of my new values are carried over.


::Edit

figured out what i need to do, i need to update my table mappings and sql statements for my data adapter, however, for the life of me i can't figure out how to do this.

i don't know if it'll throw a wrench in the mix or not (or change things) but the database connection is set programmatically instead of in the connection object.



Can anyone give a helping hand to a VB.Net Newbie?

Thanks

Without the code is not easy... you should (at least) post the code of your connection to the DB, and the way you manipulate data (editing, adding and updating).

Bye