Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#4.0
Hi,
 

This is my DataTable
 
 
Id       Item_Id
100       1
100       2
 
 
This is my DataTable here i want to check the condition.
 
for ex:
 
again i try to insert 100 (id) ,1(item_Id).Data has not to be inserted.
Id       Item_Id
100       1
100       2
100       1 ( not inserted)
 
can any one help me to solve this issue...
 

Thanks in advance....
Posted 2-Oct-12 21:51pm
Edited 2-Oct-12 23:14pm
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

u did not explain your table structure .if Item_Id column is primary or u unique then u cant insert same Item_Id again .what error u r getting can u explain ?
  Permalink  
Comments
solanki.net at 3-Oct-12 4:50am
   
can u show the code ?
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

you can make Id and Item_Id as a composite key. In case if you try to insert the same records then the SQL Server won't allow to insert and give Exception.
 

Thanks
  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 512
1 Maciej Los 445
2 Sergey Alexandrovich Kryukov 381
3 CPallini 170
4 PIEBALDconsult 148
0 Sergey Alexandrovich Kryukov 6,708
1 OriginalGriff 5,302
2 Peter Leow 3,837
3 Mika Wendelius 2,850
4 CHill60 2,748


Advertise | Privacy | Mobile
Web01 | 2.8.150224.1 | Last Updated 3 Oct 2012
Copyright © CodeProject, 1999-2015
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