Update/Resync ADO.NET Dataset?

[Computer Guru]

I imported an Access database, created a dataset, added a
bindingsource; and have been happily coding away - couldn't be easier.

My problems started when I added a column to the database - I can't
find a way to tell Visual Studio to "resync" the imported dataset and
the external DB!

I tried deleting the dataset, Visual Studio just crashed. Attempted to
create another Dataset, discovered it crashed in the middle of an
operation, and spent an hour manually cleaning up designer-generated
code and non-existent references then tried again - I was able to
create the dataset this time just fine.

It occured to me to change the column later on (from text to memo),
and what do you know: when I tried to delete the old dataset, VS
crashed *yet again!*

I've given up on VS on Vista, just too damn buggy - but I was
wondering if anyone knows a way of kicking-off an update or resync
sequence for an ADO.NET object(s) like the table adapter and dataset?

Thanks.

 

[Nicholas Paldino [.NET/C# MVP]]

Unfortunately, the way that you are doing it is exactly the way I would
referesh the designer generated code. You should be able to delete the
table from the data set, and then re-add it.

Can you post the access file, as well as a complete solution that shows
where it crashes? I've used the data designer a number of times doing just
this (against SQL databases, not access) and haven't had this problem.

 

[Computer Guru]

Unfortunately, the way that you are doing it is exactly the way I would
referesh the designer generated code. You should be able to delete the
table from the data set, and then re-add it.

Can you post the access file, as well as a complete solution that shows
where it crashes? I've used the data designer a number of times doing just
this (against SQL databases, not access) and haven't had this problem.

--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

I imported an Access database, created a dataset, added a
bindingsource; and have been happily coding away - couldn't be easier.

My problems started when I added a column to the database - I can't
find a way to tell Visual Studio to "resync" the imported dataset and
the external DB!

I tried deleting the dataset, Visual Studio just crashed. Attempted to
create another Dataset, discovered it crashed in the middle of an
operation, and spent an hour manually cleaning up designer-generated
code and non-existent references then tried again - I was able to
create the dataset this time just fine.

It occured to me to change the column later on (from text to memo),
and what do you know: when I tried to delete the old dataset, VS
crashed *yet again!*

I've given up on VS on Vista, just too damn buggy - but I was
wondering if anyone knows a way of kicking-off an update or resync
sequence for an ADO.NET object(s) like the table adapter and dataset?

Thanks.- Hide quoted text -

- Show quoted text -

That's certainly a shame :-(

I haven't seen this particular issue before either; I'll create a new
solution and see if I can get it to happen there (the current solution
can't exactly be released
I just reproduced it again for the hell of it - it's becoming a real
pain and happens each and every time I delete the dataset.

Thanks.