Click here to Skip to main content
12,290,502 members (36,261 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C# 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 20:51pm
Edited 2-Oct-12 22: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 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160518.1 | Last Updated 3 Oct 2012
Copyright © CodeProject, 1999-2016
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