How to prevent duplicate records in Wpf datagrid?

Question

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

Sachin Singh · Answer

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.

Rijwan Ansari · Answer

You can create a validation function or check before insert. sample: private void CheckDuplicate() { bool IsDuplicate = false ; for ( int i = 0; 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(); }

Srinivasan Ramamoorthi · Answer

In the DataGrid.AddingNewItem Event, you have to check the text box value is present in the dataset binded to the grid.

Asma Khalid · Answer

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