datagridview row search.

Question

0.00/5 (No votes)

See more:

my datagridview is present in one windows form can i search datagrideview rows using another form ,like name wise,email wise etc

Posted 22-Jan-13 0:50am

Manas Malik

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Frans Jan · Answer 1 · 2013-01-22T02:21:00

This is how I search my DGV per row:

C#

int rowIndex = -1;
bool found = false; 

dgvProjects.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
try
{
    int searchValue = int.Parse(tbSearchValue.Text);

    foreach (DataGridViewRow row in dgvProjects.Rows)
    {
        int compareValue = int.Parse(row.Cells[2].Value.ToString());

        if (compareValue.Equals(searchValue))
        {
            found = true; 
            rowIndex = row.Index;
            dgvProjects.Rows[row.Index].Selected = true; 
            dgvProjects.FirstDisplayedScrollingRowIndex = rowIndex; 
            break;
        }
    }

    if (!found)
        MessageBox.Show("Project number not found.\n\nBe sure you're searching for the right project number.", "Project not found",
            MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (FormatException)
{
    MessageBox.Show("Your input is not a number.", "Input Error",
        MessageBoxButtons.OK, MessageBoxIcon.Error);
}

In this line:

C#

int compareValue = int.Parse(row.Cells[2].Value.ToString());

row.Cells[2].Value stands for the second column of my DGV. I wanted my program to match the text in the textbox with the text in the second column.

Dineshshp · Answer 2 · 2013-01-22T01:15:00

Solution 2

Try this :

on search textbox onchange event :

C#

DataTable tbl = (DataTable)grd.DataSource;
DataView dv = tbl.DefaultView;

dv.RowFilter = "Name Like '" + txtSearch.Text + "%'";

Posted 22-Jan-13 1:15am

Dineshshp

Amol Rawke Pune · Answer 3 · 2013-01-22T01:11:00

You can do that using delegate and then use following ways:
Way 1.
if your DataGridView is using DataTable or a DataView then
Create a BindingSource and make BindingSource.DataSource set your DataGridView.DataSource to the BindingSource.
now you can use BindingSource.Filter to filter as per query.

Way 2.
first collect DataTable.DefaultView in DAtaView object then Use DataView.RowFilter. apply filter as per query.

datagridview row search.

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0