StriderX
asked on
DataGrid Question
Hi,
I've bound a datagrid to a recordset.
The recordset is coming from a query based on search criteria?
I've successfully bound the recordset to the datagrid.
Now, I have a button that if u click it'll go to the next one row in the datagrid that matches the search criteria.
If you click another button, it'll also goto previous row matching the criteria?
I'm having a trouble implmenting this feature.
Can someone shed a light on how I can do?
I believe I need to use recordset.find to go to next bookmark?
I've bound a datagrid to a recordset.
The recordset is coming from a query based on search criteria?
I've successfully bound the recordset to the datagrid.
Now, I have a button that if u click it'll go to the next one row in the datagrid that matches the search criteria.
If you click another button, it'll also goto previous row matching the criteria?
I'm having a trouble implmenting this feature.
Can someone shed a light on how I can do?
I believe I need to use recordset.find to go to next bookmark?
A recordset? using ADO or DAO? Any codes available? ..
if using ADODC
for backward search
Adodc1.Recordset.Find "EmployeeID=" & Text1.Text, , adSearchBackward
for forward search
Adodc1.Recordset.Find "EmployeeID=" & Text1.Text, , adSearchForward
replace find criteria with yours.
for backward search
Adodc1.Recordset.Find "EmployeeID=" & Text1.Text, , adSearchBackward
for forward search
Adodc1.Recordset.Find "EmployeeID=" & Text1.Text, , adSearchForward
replace find criteria with yours.
ASKER
I am using adodb.recordset and bound it to datagrid.
After forward and backward searching, how do I set the selected index to be on the DataGrid that match the same row?
Also, I 'd appreciate if someone could answer the question of how to get the index of datagrid when user double clicks?
When I use index or some other property it always gives me the previous index before I double clicked.
After forward and backward searching, how do I set the selected index to be on the DataGrid that match the same row?
Also, I 'd appreciate if someone could answer the question of how to get the index of datagrid when user double clicks?
When I use index or some other property it always gives me the previous index before I double clicked.
Please maintin your open questions:
Questions Asked 14
Last 10 Grades Given A A A B A B B A
Question Grading Record 8 Answers Graded / 8 Answers Received
Thanks,
Anthony
Questions Asked 14
Last 10 Grades Given A A A B A B B A
Question Grading Record 8 Answers Graded / 8 Answers Received
Thanks,
Anthony
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks