How to handle data duplication in c#

Question

While clicking on add button data is saved in database but after 2-3 times refresh data in database there 2-4 copies of same data is shown.

How to get to fix this?

String cs = ConfigurationManager.ConnectionStrings["MyDBConnectionString1"].ConnectionString;

using (SqlConnection con = new SqlConnection(cs))
{
  SqlCommand cmd = new SqlCommand("Insert into tblBrands values('" + txtBrandName.Text + "')", con);
  con.Open();
  cmd.ExecuteNonQuery();
  txtBrandName.Text = string.Empty;
}

Your code clearly inserts data and it has no provisions or checks to prevent duplicates. Either don't call the code using the same data more than once, or if you can't avoid that, add code to check for existing data before inserting new data. — Peter B
– Peter B, Commented Aug 29, 2018 at 8:48

RVid · Accepted Answer · 2018-08-29 09:01:27Z

1

If you are trying to solve in SQL (assuming from your tags) you could check before inserting using:

if not exists (select * from tblBrands where ...)

Build your where clause based on your criteria - what would you consider duplicate entry

More info on exists in Microsoft Docs

answered Aug 29, 2018 at 9:01

RVid

1,3072 gold badges16 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to handle data duplication in c#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related