remove duplicates from datagridview - c#

Question

Hello In my windows form application I have a datagridview with four columns. my datagridview is NOT bound to a data source. but it reads data from different application during the runtime. How to prevent adding new rows during the run time if the Patient ID is already exist in the table? Example: PatientID PatientName Gender Age Abcd1234 xxxxxx xxxxxx xxxxxx FIxIlm568 xxxxxx xxxxxx xxxxxx na7a5419 xxxxxx xxxxxx xxxxxx If for example the patientId found twice on the list then the datagridview will not add another row with that patientID. the new row will be deleted automatically (if the patientID got duplicated). Can you help me on this plz?

Pankaj Kumar Choudhary · Answer

Hello @Eline if you want to prevent duplicate data then should first check that inserting data is already present in data grid view or not......... you can try this code List string > list = new List string >(); 02 for ( int i = 0; i 03 { 04 string str = dataGridView1.Rows[i].Cells[0].Value.ToString(); 05 if (!list.Contains(str)) 06 list.Add(dataGridView1.Rows[i].Cells[0].Value.ToString()); 07 else 08 { 09 dataGridView1.Rows.Remove(dataGridView1.Rows[i]); 10 } 11 12 }

Syed Shanu · Answer

Hi You can remove the duplicate record from DataTable before you set the datasource of Datagrid view. Check this links to remove duplicate records from DataTable. http://stackoverflow.com/questions/4415519/best-way-to-remove-duplicate-entries-from-a-data-table http://www.codeproject.com/Articles/540859/C-sharp-Removing-Duplicate-Records-From-DataTable http://www.aspsnippets.com/Red/Articles/Remove-Delete-Duplicate-Rows-Records-from-DataTable-using-C-and-VBNet.aspx

Dipankar Biswas · Answer

Hi.. Check this links to help... http://www.dreamincode.net/forums/topic/288427-how-to-remove-duplicates-copy-rows-from-datagridview/ How do I remove duplicates from an array Thanks...