howto 'refresh' an SqlDataAdapter in Design-mode

[DraguVaso]

Hi,

In my VB.NET-application I have an SqlDataAdapter with build in
Update-Commands, but during development from time to time the Table's in my
Database change. So I need to kind of rebuild the SqlDataAdapter's
update-Commands.

Is there an easy way to do this? The way I do it now is by the "configurin
Data Adapter", redoing the whole stuff, and afterwards changing the
Connection manually back to my orginal Connection. I guess there should be a
more easy way to do this?

Thanks,

Pieter

 

[Jason L James]

Pieter,

if you are using a commandbuilder you can do the following:

Dim mycb As New SqlCeCommandBuilder(myDA)
mycb.RefreshSchema()

Otherwise, I'm not too sure.

Jason.