C# Winform with Sqlite database duplicated insertion

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(); }

2 Replies

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

Phothong Dungpasearch5y ago
@Suraj Dubey
Thanks for your answer. I found that I accidently add two method of Product Insertion.
I'll close this topic now.
0
Suraj Dubey5y ago
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(); }
```
0