Insert a value using one function and compare that value with column in a table and return result

Question

0.00/5 (No votes)

See more:

Hi i have one table as follows.

C#

sno	name
1	george
2	michael
3	sturridge
4	bellamy
5	oliver kahn
6	torres
7	van persie
8	saurez
9	podolski

Now i have to insert a value and pass that value to one table by creating function. and then i have to Compare the newly inserted value with the name column in the above table. If both matches it should display the result as success,else fail.

Which is the best way to do this?

Posted 3-Sep-13 19:35pm

ARUN K P

Updated 3-Sep-13 20:25pm

Thanks7872

v2

Add a Solution

Comments

syed shanu 4-Sep-13 2:59am

Improve your question.not able to understand what you need

1 solution

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)

anuradha.sardesai · Accepted Answer · 2013-09-03T21:26:00

Are you talking about two database tables, and when value is getting inserted in one, do a check against another table? If that is the case,

1. you could create a trigger on first table's insert. In it, check if the value exists in the other table and
if yes, continue with insert and print success message.
else cancel the operation and print failure message

2. You can also write a user defined function to this

Please specify more details to be able to give a solution.