如何使用两个文本框在datagridview中进行多重搜索? [英] How to multisearch in datagridview using two textbox?

问题描述

朋友们！
我想在datagridview中使用两个文本框进行搜索. vb.net
在我的datagridview1中有:

_________________________________________________
| NUMBER_RECEIPT |描述|价格|
| 1 | USB 8GB | 7 $ |
| 1 | USB 16GB | 12 $ |
| 1 | USB 32GB | 20 $ |
| 2 | USB 64GB | 35 $ |
_________________________________________________

在 textbox1 中，我要搜索" NUMBER_RECEIPT "和 textbox2 " DESCRIPTION "
第一次:如果在 textbox1 中搜索:" 1 "要显示:

_________________________________________________
NUMBER_RECEIPT |描述|价格|
| 1 | USB 8GB | 7 $ |
| 1 | USB 16GB | 12 $ |
| 1 | USB 32GB | 20 $ |
_________________________________________________

第二时间:在textbox1中搜索后，我想在 textbox2 中搜索:"Usb 8"
我想展示:

_________________________________________________
NUMBER_RECEIPT |描述|价格|
| 1 | Usb 8 gb | 7 $ |
_________________________________________________

我尝试过的事情:

我试图在互联网上找到.
我找到了一些代码，但对我来说却无法正常工作，例如:

Hi friends!
I want to search with two textbox in datagridview. vb.net
In my datagridview1 have:

_________________________________________________
|NUMBER_RECEIPT | DESCRIPTIONS | PRICE |
| 1 | Usb 8gb | 7$ |
| 1 | Usb 16gb | 12$ |
| 1 | Usb 32gb | 20$ |
| 2 | Usb 64gb | 35$ |
_________________________________________________

In textbox1 I want to search "NUMBER_RECEIPT" and textbox2 "DESCRIPTION"
FIRST TIME: If search in textbox1: "1" want to show:

_________________________________________________
NUMBER_RECEIPT | DESCRIPTIONS | PRICE |
| 1 | Usb 8gb | 7$ |
| 1 | Usb 16gb | 12$ |
| 1 | Usb 32gb | 20$ |
_________________________________________________

SECOND TIME: And after search in textbox1, I want to search in textbox2: "Usb 8"
I want to show:

_________________________________________________
NUMBER_RECEIPT | DESCRIPTIONS | PRICE |
| 1 | Usb 8gb | 7$ |
_________________________________________________

What I have tried:

I tried to find in internet.
I found some codes but for me does not work properly, for example:

BindingSource7.Filter = "[NUMBER_RECEIPT] LIKE '" & TextBox1.Text & "%'" Or
BindingSource7.Filter = "[DESCRIPTIONS] LIKE '" & TextBox2.Text & "%'"

请你能帮我吗?
非常感谢:)

Please can you help me for this ?
THANK YOU VERY MUCH :)

推荐答案

|
| 1 | USB 16GB | 12

|
| 1 | Usb 16gb | 12

|
| 1 | USB 32GB | 20

|
| 1 | Usb 32gb | 20

|
| 2 | USB 64GB | 35

|
| 2 | Usb 64gb | 35

这篇关于如何使用两个文本框在datagridview中进行多重搜索?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！