如何在文本框VB.NET中搜索具有单个值的表的所有列 [英] How to search all columns of a table with single value in textbox, VB.NET

问题描述

我有一个带有数据库访问应用程序的vb.net。

我有多个列，例如A1，A2，A3

要搜索A1列中IDtxt中的特定值，我正在使用此代码。

I have a vb.net with database access application.
I have multiple column e.g. A1, A2, A3
To search a particlular value in IDtxt in A1 column I am using this code.

Private Sub btnSearchID_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearchID.Click
        Me.VerifiedHPReportBindingSource.Filter = "[A1] = '" & Me.IDtxt.Text & "'"
    End Sub

我如何搜索A1，A2，A3栏中的特定值？



我正在使用数据绑定源来检索价值。



我尝试了什么：



我试过以下代码但没有工作

How can I search particular value in A1,A2,A3 column?

I am using databindingsource to retrive the value.

What I have tried:

I tried following codes but not working

Private Sub btnSearchID_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearchID.Click
        Me.VerifiedHPReportBindingSource.Filter = "[A1] = '" & Me.IDtxt.Text & "'"
        Me.VerifiedHPReportBindingSource.Filter = "[A2] = '" & Me.IDtxt.Text & "'"
        Me.VerifiedHPReportBindingSource.Filter = "[A3] = '" & Me.IDtxt.Text & "'"
    End Sub

推荐答案

您需要将过滤条件合并为一个字符串：

You'll need to combine the filter conditions into a single string:

Me.VerifiedHPReportBindingSource.Filter = String.Format("[A1] = '{0}' Or [A2] = '{0}' Or [A3] = '{0}'", Me.IDtxt.Text)

这篇关于如何在文本框VB.NET中搜索具有单个值的表的所有列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！