Programming Forums - View Single Post - Preforming a binary(SQL) search on a datagrid.

Sane · Jan 10th, 2008, 11:33 AM

Will the parameter that's being searched for either be an exact match or not?

If it is a 'match or no match' situation, can you not perform a MySQL SELECT statement that searches for that particular row? Then retrieve the row number of that record.

Using the row number you can do whatever you need to your data grid, since the row number should correspond to the same row in your graphical interface's table. I'm assuming your data is being represented in the same order and size as your MySQL table. Or am I missing something?

Jan 10th, 2008, 11:33 AM	#2
Sane Programming Guru Join Date: Apr 2005 Posts: 1,799 Rep Power: 5	Re: Preforming a binary(SQL) search on a datagrid. Will the parameter that's being searched for either be an exact match or not? If it is a 'match or no match' situation, can you not perform a MySQL SELECT statement that searches for that particular row? Then retrieve the row number of that record. Using the row number you can do whatever you need to your data grid, since the row number should correspond to the same row in your graphical interface's table. I'm assuming your data is being represented in the same order and size as your MySQL table. Or am I missing something?