asked on

Searching In VB

I have three three text boxes namely first name, last name and DOB

and one datagrid in which i am displaying the table "students"

I want when the user enters any value in any of the three boxes ( either the full first name, or last name or either the first three letters of first or last name , or only DOB), and click on "Search" button:-

The datagrid will only search on the basis of above criteria and will display the values from the database... in the datagrid...........................................

Please help me in VB only as i need it urgently

ASKER CERTIFIED SOLUTION

Ryan Chong

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rajender123

ASKER

Thanks.. for this... i want that when the serch results come in datagrid...(since i have multiple values of the same student with different dates) so the datagrid will display all the values......................... of ame student with different visit dates..........

Now i want if i select one row...... all the records will be displayed in the text boxes:- namely

name
first name
last name
visit date
dob
place

Also, the search results should also be present at the same time....................

Can u please help me out in VB.............................................

Ryan Chong

>>Now i want if i select one row...... all the records will be displayed in the text boxes:- namely
I think this is the new question from this thread, you can try:

1. Open a New Question with this requirement or
2. Increase this question's points

so that we can help here.

cheers

rajender123

ASKER

I have increased the points also