how to make search between pages

Karolina Sanovic
Karolina Sanovic used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
GrahamSkanRetired
Top Expert 2012

Commented:
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.

Author

Commented:
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

Author

Commented:
I resolve freezing screen
WP_20170329_005.jpg
Expert Spotlight: Joe Anderson (DatabaseMX)

We’ve posted a new Expert Spotlight!  Joe Anderson (DatabaseMX) has been on Experts Exchange since 2006. Learn more about this database architect, guitar aficionado, and Microsoft MVP.

GrahamSkanRetired
Top Expert 2012
Commented:
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.

Author

Commented:
The screen is ok,but I m still trying to make search between pages,I wellcome any help
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

Author

Commented:
Hi Ark
thanks for help but that is old picture I do have more datatables. 6 pages and 6 data
unnamed.jpg
GrahamSkanRetired
Top Expert 2012

Commented:
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.)
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?

Author

Commented:
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
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 ....

Author

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

Author

Commented:
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

Author

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

Author

Commented:
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

Author

Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial