How to add all listbox item except those which present in table previously

Question

0.00/5 (No votes)

See more:

I have a list box . I want that when submit is clicked then all the items added into the database except those which present in the database previously . All the items have productid and adminid which enters with them .

For example , i have product 1,2,3,4 for admin 1 and product 3 is already present in table for admin 1 then product 1,2,4 will be added and 3 will not as it is already added for admin 1 .

Posted 30-Oct-11 21:11pm

Vimalrashamra

Updated 30-Oct-11 23:17pm

v3

Add a Solution

Comments

Sander Rossel 31-Oct-11 3:27am

What tools are you using to communicate with the database?

Amir Mahfoozi 31-Oct-11 3:29am

Do you want the sql or the c# code ? and are you using an ORM or use direct access to DB ?

Vimalrashamra 31-Oct-11 3:32am

i want the insertion code in ado.net

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Zubair Alie · Answer 1 · 2011-10-31T03:21:00

1st but not the best solution may be, you first check in table by query that either it is already saved or not. which is time taking.
secondly, why don't you apply composite unique key constraint on both of the columns..that if prodID will repeat for admin-id.. do not let it save it in database and catch the exception with empty body... :)

for second solution, you require to only to make change in table structure by applying composite key constraint on table and in code end only to handle database call within try block with empty catch block.

Bala Selvanayagam · Answer 2 · 2011-10-31T03:30:00

Solution 3

there was a similar question before Can I validate a listbox so that i dont repeat the same values[^]

Posted 31-Oct-11 3:30am

Bala Selvanayagam