Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB9.0 VB10.0
How to check duplicate records in the database before inserting using linq in vb.net
 
for example I have a table of general_categories, consists of cat_id and categories
 
when i click save to vb.net there will pop up message says that their is duplicate
 
records found when the file you want to save is existing..........
Posted 7-Jun-12 23:10pm
gsl20325

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

I think this is very basic engineering solution that your are trying .
 
Read this all link as I found this to be very helpful to understand basic functionality of LinQ .
 
http://msdn.microsoft.com/en-us/vstudio/bb688088.aspx[^]
 

Apart from this I would like to give solution for your issue not in the form of code but in the form of algorithm.
1) Connect the database
2) Use that connection to run LinQ Query
3) Declare one variable which will store YES/NO for result
4) Write SELECT query to find out the data in table If exists query will return YES otherwise NO
5) Make use of this condition to process further request.
 

Hope this helps , If yes then plz accept and vote the answer. Any queries / questions on this are always welcome.
 
Thanks & Regards
RDBurmon.Sr.Software Engineer
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 459
1 Maciej Los 325
2 Sergey Alexandrovich Kryukov 234
3 DamithSL 233
4 BillWoodruff 200
0 OriginalGriff 7,168
1 Sergey Alexandrovich Kryukov 6,377
2 DamithSL 5,461
3 Manas Bhardwaj 4,876
4 Maciej Los 4,450


Advertise | Privacy | Mobile
Web01 | 2.8.1411023.1 | Last Updated 8 Jun 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100