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

Nov 13 '05 #1

Subscribe Post Reply

2134

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.

--
- 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

Similar topics

BindingContext problem

by: Sergio Florez M. | last post by:

I have a windows form with a bunch of textboxes, comboboxes and three datagrids. My dataset has 4 tables and the necesary relations. Basically it's a master page with three detail grids. My problem...

C# / C Sharp

problems with bindingcontext and addnew

by: Jose_Csharp | last post by:

Hi group. I´m trying to add new records to a sql server data table with: BindingContext.AddNew(); This sentence clear all my textboxes and not add any record to the database, the I use the next...

C# / C Sharp

Form BindingContext object indexer problem?

by: D. Yates | last post by:

Hi, I retrieved the employee table from the Pubs database into a single dataset called, dataSet12. I dropped two textbox controls and a datagrid control onto the same form and bound the...

C# / C Sharp

Bound Controls and DataView, BindingContext

by: nina98765 | last post by:

Hi all I have a data-bound Windows form bound to a strongly-typed dataset. Upon opening the form, I would like to Find a specific record based on a parameter I've passed to the form, and display...

Visual Basic .NET

Totally confused Relation/Bindingcontext/EndCurrentEdit(), etc

by: graham | last post by:

Hi there, Can anyone help me with a definitive solution to the problem I have. I know this is much revisitied ground, and I have read a number of articles.. but I still can;t get this binding to...

Visual Basic .NET

BindingContext Position problem

by: Aaron Smith | last post by:

I have a simple datagrid on a form. I used the wizard to create the form. I have navigation buttons that I made myself.. This is the next button: Me.BindingContext(objSeasonsDS,...

Visual Basic .NET

BindingContext problem (Maybe)

by: doomx | last post by:

I have a strange problem. In my form there is a grid(dgBC) and there is one checkBox column who is editable. When i make a change on a row, i must select another row, if i don't the changes will...

Visual Basic .NET

bindingcontext question

by: JohnR | last post by:

I have a question on bindingcontext, bindings, and controlbindingscollection. I understand the very basic idea, and I think I should be able to do this, but I'm not sure how. First problem: I...

Visual Basic .NET

UserControl and BindingContext

by: MeowCow | last post by:

I have created a UserControl that encapsulates a third party data grid. My goal was to create my own DataSource and DataMember properties that forward the binding to the third party grid, then use...

C# / C Sharp

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing