473,799 Members | 2,834 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

BindingContext between Query Table

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
1 2159
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************* *@exisconsultin g.com

"fhiemstra0 507" <fh***********@ rogers.com> wrote in message
news:pz******** ***********@new s01.bloor.is.ne t.cable.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1596
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 is that when I move the position of the BindingContext the datagrids reflect the change but the textboxes and comboboxes don't. -- El que persevera insiste Sergio Florez M. Medellín, Colombia
0
1488
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 code, but appears an error about the duplicate primary key, I suppose that this code is valid if I don´t use the databindings of the textboxes : DataTable myTable = dataSetUsuario1.Tables;
1
3321
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 controls at design time to dataSet12's employee table. Now I want to move through the data by pressing a button.... This code will change the data in the text boxes: this.BindingContext.Position += 1;
0
1397
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 the data in the appropriate textboxes, etc. I would also like to have the entire table opened (i.e., not just the one record I've found) as I would like to navigate through the records My table is called "AP_TBL_Vendors. The problem is that I...
0
1441
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 work. Let me explain... I have a form which displays records from a dataset in a textboxes.
2
2913
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, "Seasons").Position = (Me.BindingContext(objSeasonsDS, "Seasons").Position + 1) The position is always 0. If I hit the next button, it becomes 1, then when I hit it again, it's back to 0 and gets set to 1 again. The (objSeasonsDS.Tables("Seasons").Rows.Count...
0
859
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 not be saved. Any idea ?? Thx DoOmX (I shrink the code because there is to much class involved)
2
2013
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 have a combobox and a textbox on a form. I also have a "Customers" table loaded into a dataset. I set the combobox.datasource to the table in the dataset, and add a binding to the text property of the combobox for the 'Name' field. I also add...
6
12142
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 binding like normal. The problem I am running into is that my UserControl ends up with a different BindingContext then the ParentForm it is contained in and thus all other controls on the parent form. (I want various controls on the form to...
0
9687
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10485
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10231
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10027
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9073
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5463
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5585
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4141
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2938
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.