BindingContext between Query Table

[fhiemstra0507]

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

 

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

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.