Updating to Access

  • Thread starter Thread starter Brad Allison
  • Start date Start date
B

Brad Allison

Hello,

I am new to ADO and VB.Net. I am not new to using Access. I am in the
process of creating a very large entry system for dog shows and I am having
a problem. All seems to work except one very important thing and that is
saving the actual data that has been input to the bound controls between my
Windows VB form and the actual Access table. I know that this is a very
broad and general topic, but any little information may help.

I have my ole db data adapter, my datasets in place and I have code that
reads
oledbdataadapter1.update(dsDataset1)
When this runs, no data is updated. I have read about data tables, data
views, adding rows, insert, update, delete, etc, but I am missing something
other than simply creating a data adapter, creating a dataset and then using
the data adapters update to write changed or new records back to the Access
table.

Again, thanks for any information.

Brad
 
If you examine the RowState property of datarow in the dataset, what is the
value?

Cheers,

Simon Stewart
Johannesburg, South Africa
 
Brad,

Did you write an updatecommand? Are you using a commandbuilder to update?
I'll bet this is where the problem is.

HTH,
Bernie Yaeger
 
For some reason I decided to also view the schema. On several (I use 8) of
the datasets the view schema was greyed out. Now I went in to create a new
dataset from the Data menu and it worked! The former 8 datasets were
created by selecting the data adapter and then clicking on the link to
generate a dataset. Is there a difference? I do know that there is
something about a typed dataset and an untyped dataset.

But now I think I am on the right track.

Brad
 
Hi Brad,

You're going too far afield. Let me tell you this again, because it is the
classic 'no backend update but I don't get an error message' problem:
Did you create and insert command? If not, did you use the commandbuilder?
If you did neither of these, it will not update the back end.

Bernie
 
Back
Top