如何使用两个文本框在datagridview中进行多重搜索?

人气:1,021 发布:2022-10-16 标签: vb.net visual-studio vb VB10.0

问题描述

朋友们! 我想在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

525