How to remove duplicates from datagridview?

Question

How can I remove duplicate rows from datagridview?

For example:

dataGridView1:

NAMES - LASTNAMES
mary         cash
john          money
john          bucks
jack          bank

I want to remove only duplicate names.

After duplicates removed:

NAMES - LASTNAMES
mary         cash
john          money
jack          bank

sathish N · Answer

use this namespace for Hash Table: =========================== using System.collections; using System.collections.Generic;

MetalGearSolid · Answer

Sorry your code didn't work on my C# project for dataGridView control. Perhaps I wasn't able to use it correctly =( Is there any easy/clear code to do this? (Without hash codes) Thanks

sathish N · Answer

protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack) { SqlConnection con = new SqlConnection("Data Source=Sathish; Initial Catalog=MySampleDB; Integrated Security=true"); con.Open(); SqlCommand cmd = new SqlCommand("select * from SampleTable", con); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds,"UserDetails"); DataTable dt = ds.Tables["UserDetails"]; RemoveDuplicateRows(dt, "UserName"); // Here UserName is Column name of table gvDetails.DataSource = ds; gvDetails.DataBind(); } } // This method is used to delete duplicate rows of table public DataTable RemoveDuplicateRows(DataTable dTable, string colName) { Hashtable hTable = new Hashtable(); ArrayList duplicateList = new ArrayList(); foreach (DataRow dtRow in dTable.Rows) { if (hTable.Contains(dtRow[colName])) duplicateList.Add(dtRow); else hTable.Add(dtRow[colName], string.Empty); } foreach (DataRow dtRow in duplicateList) dTable.Rows.Remove(dtRow); return dTable; }

Satyapriya Nayak · Answer

http://www.simple-talk.com/sql/t-sql-programming/removing-duplicates-from-a-table-in-sql-server/

How to remove duplicates from datagridview?

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)