Record already exist in DataTable no need to be inserted

Question

0.00/5 (No votes)

See more:

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

pranathis012

Updated 2-Oct-12 22:14pm

v2

Add a Solution

2 solutions

Add a Solution

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

solanki.net · Answer 1 · 2012-10-02T21:26:00

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 ?

Posted 2-Oct-12 21:26pm

solanki.net

Comments

[no name] 3-Oct-12 4:13am

datatable is temprory datatable

solanki.net 3-Oct-12 4:50am

can u show the code ?

AshishChaudha · Answer 2 · 2012-10-02T22:33:00

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

Posted 2-Oct-12 22:33pm

AshishChaudha

Comments

[no name] 3-Oct-12 4:37am

my 5

Record already exist in DataTable no need to be inserted

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Record already exist in DataTable no need to be inserted

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us