hi i have a window application, wherein i have to choose the database,its table and rowfields present in the table at runtime. Now i want to remove all the duplicates from database. my database is access and whichever row field the user chooses the duplicates should be removed leaving the latest updated row. Please help me my code is as below.. string str = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + txtPath.Text; OleDbConnection con = new OleDbConnection(str); string t = "select * from " + cmbtables.SelectedItem.ToString(); OleDbDataAdapter adt = new OleDbDataAdapter(t, str); con.Open(); DataSet ds = new DataSet(); adt.Fill(ds); DataTable dt = ds.Tables[0]; con.Close(); dt = RemoveDuplicateRows(dt, cmbRow.SelectedItem.ToString()); private DataTable RemoveDuplicateRows(DataTable dTable, string colName) { Hashtable hTable = new Hashtable(); ArrayList duplicateList = new ArrayList(); foreach (DataRow drow in dTable.Rows) { if (hTable.Contains(drow[colName])) duplicateList.Add(drow); else hTable.Add(drow[colName], string.Empty); } foreach (DataRow dRow in duplicateList) dTable.Rows.Remove(dRow); return dTable; } when i use datatable.update it is giving me error hoping for your co-operation Thank you

Hi, You can achieve that using DISTINCT keyword which will remove duplicate rows. Manoj Shinde Useful Softwares