This is my DataTable
This is my DataTable here i want to check the condition.
again i try to insert 100 (id) ,1(item_Id).
Data has not to be inserted.
100 1 ( not inserted)
can any one help me to solve this issue...
Thanks in advance....
Edited 2-Oct-12 23:14pm
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 ?
you can make
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.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)