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:
Who is Participating?

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

x
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.

GrahamSkanRetiredCommented:
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.
0
Karolina SanovicAuthor 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
0
Karolina SanovicAuthor Commented:
I resolve freezing screen
WP_20170329_005.jpg
0
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

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

0
Karolina SanovicAuthor Commented:
Hi Ark
thanks for help but that is old picture I do have more datatables. 6 pages and 6 data
unnamed.jpg
0
GrahamSkanRetiredCommented:
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.)
0
ArkCommented:
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?
0
Karolina SanovicAuthor 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
0
ArkCommented:
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 ....
0

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:
Do I put text box and button in my Form for this search and where sould write "Using:....."
0
Karolina SanovicAuthor 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
0
Karolina SanovicAuthor Commented:
also how to put error msg if that number (text) in search is not value
0
Karolina SanovicAuthor 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
0
Karolina SanovicAuthor 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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.