Click here to Skip to main content
12,955,842 members (65,846 online)
Rate this:
Please Sign up or sign in to vote.
See more:

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
Updated 2-Oct-12 22:14pm
Rate this: bad
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.

Rate this: bad
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 ?
Comments 3-Oct-12 4:50am
can u show the code ?

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
OriginalGriff 6,719
CHill60 3,550
Maciej Los 3,153
ppolymorphe 2,060
Jochen Arndt 1,975

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