C# Winform with Sqlite database duplicated insertion

Question

Hi there, I have a c# winform app. I'm using Dapper to insert a bunch of data to database table called tbProducts when it insert I get duplicated rows of an insertion. I pass ProductModel class to db.InsertNewProductModel method. I uploaded my code. Anyhelp is appreciated

Phothong Dungpasearch · Answer

@Suraj Dubey Thanks for your answer. I found that I accidently add two method of Product Insertion. I'll close this topic now.

Suraj Dubey · Answer

Hear is the answer -the simple logic is you have to first find using query that. is there any same record exist in database if record is exist then do not insert the new record in the database, otherwise the insert the record in the database. Note:- by using for each loop you can achive your requirement sample of code ------------------------------------ In this example you can see first it will check the name is name is exist or not if name is exists in database it will toast the message "record is allready exists" other wise the insert query will exiquted. String name = edtName.getText().toString().trim(); String query = "Select * From STUDENTS where name = '"+name+"'";if(sqLiteHelper.getData(query).getCount()>0) { Toast.makeText(getApplicationContext(), "Already Exist!", Toast.LENGTH_SHORT).show();}else{ sqLiteHelper.insertData(name,edtPrice.getText().toString().trim(),imageViewToByte(imageView)); Toast.makeText(getApplicationContext(), "Added successfully!", Toast.LENGTH_SHORT).show(); }