By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,239 Members | 1,503 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,239 IT Pros & Developers. It's quick & easy.

howto 'refresh' an SqlDataAdapter in Design-mode

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

On Mon, 23 Aug 2004 16:34:26 +0200, "DraguVaso"
<pi**********@hotmail.com> wrote:
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


Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.