How to prevent duplicate records in Wpf datagrid?

Hasti Fallah

4y2.1k

Hi.

I have Datagrid that I want to check the value it's getting from text box and validate if it's not duplicated records

Then if it's validate it continues posting api into my datagrid

Here's my code :

if (txtName.Text==usergrid)
{
MessageBox.Show("channel already exists!");

}
else
{
return;
}

Can you please help me what should I add?

Thanks

4 Replies

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

Rijwan Ansari4y ago
You can create a validation function or check before insert.

sample:
private void CheckDuplicate()
    {
        bool IsDuplicate = false;
        for (int i = 0; i < usergrid.Rows.Count; i++)
        {
            if (txtName.Text == usergrid.Rows[i].Cells[0].Value.ToString())
            {
                IsDuplicate = true;
                MessageBox.Show("duple");
                break;
            }
        }
        if (!IsDuplicate)
            usergrid.Rows.Add(txtName.Text.Trim(), OtherColumn1.Text, OtherColumn2.Text);

        txtName.SelectAll();
        txtName.Focus();
    }
+1
Sachin Singh4y ago
you will need to search all rows.
foreach (DataGridViewRow row in this.usergrid.Rows)
                {
                    if (row.Cells[0].Value.Equals(txtName.Text))
                    {

                        MessageBox.Show("Row already exists");
                        break;
                    }
                }
better you make your name column unique in database table and bind dataGrid to that table.
+2
Srinivasan Ramamoorthi4y ago
In the DataGrid.AddingNewItem Event, you have to check the text box value is present in the dataset binded to the grid.
+1
Asma Khalid4y ago
You can not compare string with grid object. Compare a particular text value with your text input

Mark answer as accepted if helpful

Thanks & Regards,
Asma Khalid

For More Visit: www.asmak9.com or www.bytezaar.com

+1