Visual Basic.NET
Visual Basic.NET

how to make search between pages

Hi,I have another problem.I have form with 5 pages,each page contains same data table,how to put search button in form so it can search all pages,all data tables at the same time

Karolina SanovicAsked: 2017-03-29

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

Experts Exchange Solution brought to you by

Enjoy your complimentary solution view.

Get every solution instantly with Premium. Start your 7-day free trial.

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LVL 77

GrahamSkanRetiredCommented: 2017-03-29

Can you clarify which application you are using? Is it VB6 as the topic 'Visual Basic Classic' would suggest?
It would help to post your code.

Karolina SanovicAuthor Commented: 2017-03-29

I am using Visual Basic,and at the moment I made something,not sure what,but my form is frozen cant do anything on switching pages or change anything on the form,help please

Karolina SanovicAuthor Commented: 2017-03-29

I resolve freezing screen
WP_20170329_005.jpg

LVL 77

GrahamSkanRetiredCommented: 2017-03-29

If the screen is still frozen, have you tried opening Task Manager and using it to stop the application? If that doesn't help I suggest that you restart your computer.

Karolina SanovicAuthor Commented: 2017-03-29

The screen is ok,but I m still trying to make search between pages,I wellcome any help

LVL 28

ArkCommented: 2017-04-03

Hmm.
>>each page contains same data table
>>search all pages,all data tables
Do you have 1 or 5 datatables? According your photo you have only one BindingSource. In this case code should be smth like this

Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
    Dim idx = Solina1BindingSource3.Find(YourStringColumnName, "Whatever1")
    'or Dim idx = Solina1BindingSource3.Find(YourIntegerColumnName, 5)
    If idx >-1 then Solina1BindingSource3.Position = idx
End Sub

Open in new window

Karolina SanovicAuthor Commented: 2017-04-04

Hi Ark
thanks for help but that is old picture I do have more datatables. 6 pages and 6 data
unnamed.jpg

LVL 77

GrahamSkanRetiredCommented: 2017-04-04

Karolina,
It is better to send a screen capture instead of a photograph. You can get this on one of two ways.
You can put the picture into the Windows clipboard by pressing the PrintScrn button. Then you can open Windows Paint and paste into a new image.
Alternatively you can use the Windows Snipping tool. The allows you to select and copy only a part of the whole screen.

(I can't help with you particular problem as I am only a novice with VB.Net.)

LVL 28

ArkCommented: 2017-04-04

1. Is there same criteria to search for each datatable or there are different criteria for each?
2. Are you binding data with bindingsource for each datatable?

Karolina SanovicAuthor Commented: 2017-04-05

I would like to have search by keyword and to make search in all datatables.
My datatables have each bindingsource for it self ,Solina1BindingSource ....Solina1BindingSource5
screen-12.30.50-05.04.2017-.png

LVL 28

ArkCommented: 2017-04-05

Private Sub SearchData(searchColumn As String, searchValue As Object, ParamArray sources As BindingSource())
    For Each bs In sources
        Dim idx = bs.Find(searchColumn, searchValue)
        If idx > -1 Then bs.Position = idx
    Next
End Sub

Open in new window

Using:
SearchData("YourColumnName", TextBox1.Text, Solina1BindingSource, Solina2BindingSource, Solina3BindingSource ....

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial

Karolina SanovicAuthor Commented: 2017-04-06

Do I put text box and button in my Form for this search and where sould write "Using:....."

Karolina SanovicAuthor Commented: 2017-04-24

Thanks,Ark
this is working when I am searching one datasource
but- example when I save more informations for one column(this example shows date column) when Iam searching it shows only first information,how to make it show all informations for that date.
search.png

Karolina SanovicAuthor Commented: 2017-04-25

also how to put error msg if that number (text) in search is not value

Karolina SanovicAuthor Commented: 2017-04-26

Hi I found code that I needed but I have error could anyone see and try to resolve my error,Please.
Here is picture.
screen-search-form_load.png
search-err.png
screen-datum-..png
screen-datum-.png
screen-datum.-.png
screen-datum.png
screen-matica-godina-.png
screen--matica-godina.png

Karolina SanovicAuthor Commented: 2017-04-27

Hello,just because I am not a geek I dont see why someone souldnt help me.I really want to make it work but I need help.The date search works but other two dont,I know the problem is in writting two words košnica br(the number of hive) and matica godina(queen year bearth) I tried writte them together,separately but dont know how to resolve it.
PLEASE HELP