datagridview

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 < columnCount; 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");
            }
        }

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kirtan Patel17y ago
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 < columnCount; 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");
            }
        }
0
Roei Bar17y ago
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
0