datagridview

Question

how to find a particular value from datagridview when it is connected to a database

Kirtan Patel · Answer

Hi Friend , Here is What you want it will Search The DataGridView and Tell you in Which Row it is Located :) dont forget to mark " Do you like answer " please it will give me some credits :) private void btnSearch_Click( object sender, EventArgs e) { bool Found = false ; int FoundRowIndex=0 , FoundColIndex=0 ; string SearchText = txtSearch.Text.Trim(); foreach ( DataGridViewRow r in dataGridView1.Rows) { if (Found == false ) { int rindex = r.Index; int columnCount = dataGridView1.Columns.Count-1; for ( int i = 0; i { if (dataGridView1.Rows[rindex].Cells[i].Value.ToString() == SearchText) { FoundRowIndex = r.Index; FoundColIndex = i; Found = true ; } } } else { break ; } } if (Found == true ) { MessageBox .Show( "Found at Row =" + FoundRowIndex); } else { MessageBox .Show( "Value Not Found" ); } }

Roei Bar · Answer

i think this is what you need : DataRow[] theFilteredResults = theDataSet.Tables [Index] .Select("[ ColumnName ] LIKE '" + this.theName.Text + "'); this will provide you with fitered rows containing the value you looked for hope this helps

datagridview

Answers (2)