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

BindingContext between Query Table

P: n/a
Hi

I have a listbox that is based upon a query. This query is sorted by PetName
and has the PetID and the PetName field in the query. It is based upon this
table Pets which obviously has this fields in it. However, I can not find
any examples of how to keep the data insync between the query and the table.

I do have it working through controls but that is not the ideal situation.

Are there any examples ordo you have any suggestions.

Thanks in Advance

Bill
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Bill,

The only way you can keep it in sync is by re-querying the database.
The model in .NET is that data sets are disconnected. Because of this, they
don't know when the underlying table changes. Since this is the case, you
will have to know when the changes take place, and reload the data at the
appropriate time.

Hope this helps.

--
- Nicholas Paldino [.NET/C# MVP]
- ni**************@exisconsulting.com

"fhiemstra0507" <fh***********@rogers.com> wrote in message
news:pz*******************@news01.bloor.is.net.cab le.rogers.com...
Hi

I have a listbox that is based upon a query. This query is sorted by PetName and has the PetID and the PetName field in the query. It is based upon this table Pets which obviously has this fields in it. However, I can not find
any examples of how to keep the data insync between the query and the table.
I do have it working through controls but that is not the ideal situation.

Are there any examples ordo you have any suggestions.

Thanks in Advance

Bill

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.