Solved

Create a Binding Source Filter in Visual Basic

Posted on 2008-10-06
1
473 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

729 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