Search the gridview control

Question

Hi
I need help in gridview Control Search.
I have a gridview control with nearly 4000 records. I am using a textbox to enter a search string to search for a match in the gridview records. If there is a match of that word is find in the gridview control either cursor has to point to that record or that particular record should be highlighted with some color say yellow. If more than one record is found with that string, obviously the pointer should be on the first record having match or highlight the first record that is having matching string.
If we can use 'find Next' like in MS-Word, that will be great too.
If there is any idea from anybody, will be a great help. Thank you.
Prasad

Prasad Vempati · Answer

Mr.Martin
Thank you for the reply. I believe that, the Cell property in gridview does not refer to gridview row cell. It refers to table Cell.
That is the reason, when I use row.Cells[2].Text, it is not returning any text for comparision. Since the if statement failed, it goes to else statement and coloring all the gridview rows instead those rows having the search text.
Thank you
Prasad

PJ Martins · Answer

My apologies, my answer was based on the windows DataGridView, for the web grid view:
private int _lastRowIndex = -1; // global variable for find next
bool rowFound = false ;
foreach ( GridViewRow row in GridView1.Rows)
{
if (row.Cells[0].Text == " >" && row.RowIndex > _lastRowIndex)
{
row.BackColor = Color .Yellow;
_lastRowIndex = row.RowIndex;
rowFound = true ;
break ;
}
else
{
row.BackColor = Color .Yellow;
}
}
// reset last found index if nothing was found
if (!rowFound)
_lastRowIndex = -1;

Prasad Vempati · Answer

Hi.Patel
Thank you for your reply. The end user wants when particular row is having search string, the entire row should be either selected and colored or just a pointer points to that record.
Prasad

Prasad Vempati · Answer

Mr.Martins
Thank you for your reply. Here I am using gridview control. In gridview control I cannot access the cell value, like row.Cells[1].Value because there is no property like that. What is the other property that i can use which replaces the 'Value' property of the Cell ?
Thank you
Prasad

arshi patel · Answer

make one button say btnsearch. on click event of button write code for fetch record using like% query. which resuld come that bind in gridview so, u can only get result which are match. and onther button cancel. on btncacel click event bind original result.
.. Hope may be useful

PJ Martins · Answer

you could try something like this:
private int _lastRowIndex = -1; // global variable for find next
bool rowFound = false ;
foreach ( DataGridViewRow row in dataGridView1.Rows)
{
if (row.Cells[ " >" ].Value != null && row.Cells[ " >" ].Value.ToString() == " >" && row.Index > _lastRowIndex)
{
row.DefaultCellStyle.BackColor = Color .Yellow;
row.Selected = true ;
_lastRowIndex = row.Index;
rowFound = true ;
break ;
}
else
{
row.DefaultCellStyle.BackColor = Color .White;
row.Selected = false ;
}
}
// reset last found index if nothing was found
if (!rowFound)
_lastRowIndex = -1;