How to delete duplicate column in acces

Please write me the required

(look thet photomdb file name)

commandOleDbCommand cmd1 = new OleDbCommand(??????????????????????, connection);cmd1.ExecuteNonQuery();

C:\data.mdb

table name : muhtasar

column name : "a"

Note :Other forum sites users did not solve the problem : (

THANK YOU I FIND

int kdvsil1, kdvsil2;

private void kdvtemizle()
{
string hedef = System.Windows.Forms.Application.StartupPath + "\\tutanaklar\\" + FF3.Text + "_" + altcombo.Text + "_" + comboBox3.Text + "-" + textBox15.Text + "_" + SS7.Text + "-" + SS8.Text
+ "_" + SS9.Text + "-" + SS10.Text + "_" + comboBox3.Text + ".mdb";

OleDbConnection con = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source=" + hedef);
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter("select * from kdv", con);
con.Open();
da.Fill(ds, "kdv");
for (int i = 0; i < ds.Tables["kdv"].Rows.Count; i++)
{
DataRow row = ds.Tables["kdv"].Rows[i];
kdvsil2++;
for (int j = kdvsil2; j < ds.Tables["kdv"].Rows.Count; j++)
{
DataRow row2 = ds.Tables["kdv"].Rows[j];
if (row.ItemArray.GetValue(1).ToString() == row2.ItemArray.GetValue(1).ToString())
{
if (row.ItemArray.GetValue(3).ToString() == row2.ItemArray.GetValue(3).ToString())
{
kdvsil1 = int.Parse(row2.ItemArray.GetValue(0).ToString());
kdvsila(kdvsil1);
}
}
}
}
con.Close();
}

private void kdvsila(int num)
{

string hedef = System.Windows.Forms.Application.StartupPath + "\\tutanaklar\\" + FF3.Text + "_" + altcombo.Text + "_" + comboBox3.Text + "-" + textBox15.Text + "_" + SS7.Text + "-" + SS8.Text
+ "_" + SS9.Text + "-" + SS10.Text + "_" + comboBox3.Text + ".mdb";

OleDbConnection con = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source=" + hedef);
con.Open();
OleDbCommand c = new OleDbCommand("Delete from kdv where ID =?", con);
c.Parameters.AddWithValue("ID", num);
c.ExecuteNonQuery();
con.Close();
}

3 Replies

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

Puneet Kankar9y ago
please check this link https://stackoverflow.com/questions/29357834/find-and-delete-duplicates-only-if-two-fields-have-matching-data-ms-access
Mehmet Yilmaz9y ago
THANK YOU I FIND

int kdvsil1, kdvsil2;
private void kdvtemizle()
{
string hedef = System.Windows.Forms.Application.StartupPath + "\\tutanaklar\\" + FF3.Text + "_" + altcombo.Text + "_" + comboBox3.Text + "-" + textBox15.Text + "_" + SS7.Text + "-" + SS8.Text
+ "_" + SS9.Text + "-" + SS10.Text + "_" + comboBox3.Text + ".mdb";
OleDbConnection con = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source=" + hedef);
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter("select * from kdv", con);
con.Open();
da.Fill(ds, "kdv");
for (int i = 0; i < ds.Tables["kdv"].Rows.Count; i++)
{
DataRow row = ds.Tables["kdv"].Rows[i];
kdvsil2++;
for (int j = kdvsil2; j < ds.Tables["kdv"].Rows.Count; j++)
{
DataRow row2 = ds.Tables["kdv"].Rows[j];
if (row.ItemArray.GetValue(1).ToString() == row2.ItemArray.GetValue(1).ToString())
{
if (row.ItemArray.GetValue(3).ToString() == row2.ItemArray.GetValue(3).ToString())
{
kdvsil1 = int.Parse(row2.ItemArray.GetValue(0).ToString());
kdvsila(kdvsil1);
}
}
}
}
con.Close();
}

private void kdvsila(int num)
{
string hedef = System.Windows.Forms.Application.StartupPath + "\\tutanaklar\\" + FF3.Text + "_" + altcombo.Text + "_" + comboBox3.Text + "-" + textBox15.Text + "_" + SS7.Text + "-" + SS8.Text
+ "_" + SS9.Text + "-" + SS10.Text + "_" + comboBox3.Text + ".mdb";
OleDbConnection con = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source=" + hedef);
con.Open();
OleDbCommand c = new OleDbCommand("Delete from kdv where ID =?", con);
c.Parameters.AddWithValue("ID", num);
c.ExecuteNonQuery();
con.Close();
}
Manikandan Murugesan9y ago
Refer the following Link : https://support.office.com/en-us/article/Find-hide-or-eliminate-duplicate-data-3CC805A2-2A13-4439-B0D3-6B23C7D60FBB

https://support.office.com/en-us/article/Find-and-remove-duplicate-data-438d54b9-f52a-4b82-a3e1-42a3e49c63ae

http://www.techrepublic.com/article/eliminate-duplicate-records-with-this-built-in-access-query/