Solved

Create a Binding Source Filter in Visual Basic

Posted on 2008-10-06
1
464 Views
Last Modified: 2013-11-26
I have a visual basic 2005 form, Form1, with 20+ controls(textboxes, comboboxes) on it, each bound to a column in an ms access table DataPoints. The controls are bound using tableadapter taDataPoints and BindingSource bsDataPoints.

The form also has a BindingNavigator, bnDataPoints. I would like to add a button to the BindingNavigator that will allow the user to filter by the text selected in the active control.

For example; textbox1 is bound to the column DataPointName, the user selects the text "SteamPressure" in textbox1 and clicks the filter button on the Bindingnavigator. I would like the code to build the statement  "DataPointName='SteamPressure'", which will be used as the filter in the BindingSource.


Does anyone have any code that can write a Filter statement for the binding source by detecting which column in the table the active control is bound to? I am having trouble picking up the bound-to column from the control.

Any help would be appreciated. Thanks,

John
0
Comment
Question by:GIANTOCR
1 Comment
 

Accepted Solution

by:
GIANTOCR earned 0 total points
ID: 22664351
I reposted this in a differnt zone and a solution was posted at below

http://www.experts-exchange.com/Microsoft/Development/Q_23794905
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question