saving not duplicated texts to DB

Expand Post »

Hello :

If I want to save the text of( textbox1) to entry inside a table(in access data base),every time I write texts it must write it to the DB,,in the next times if I enter in textbox1.text a text it's exist in database,,a message box error must appear(I mean inside dataBase there are no duplicated values)....any idea please???
Thanks in advance..

aminit

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

78 posts
since Feb 2008

Permalink

Apr 28th, 2008

Re: saving not duplicated texts to DB

Use a SQL stored procedure for the data integrity part of your task. Use an OUT parameter to indicate a successful write, or duplicate. Base your program logic on the OUT parameter.

tgreer

Team Colleague

Reputation Points: 227

Solved Threads: 37

Made Her Cry

Offline

1,697 posts
since Dec 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: how to make the password like stars

Next Thread in C# Forum Timeline: pls help me.....newbie in c# here..

DaniWeb Message

Cancel Changes

User Name
Password