saving not duplicated texts to DB

Please support our C# advertiser: Intel Parallel Studio Home
Reply

Join Date: Feb 2008
Posts: 63
Reputation: aminit is an unknown quantity at this point 
Solved Threads: 0
aminit's Avatar
aminit aminit is offline Offline
Junior Poster in Training

saving not duplicated texts to DB

 
0
  #1
Apr 28th, 2008
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..
Reply With Quote Quick reply to this message  
Join Date: Dec 2004
Posts: 1,655
Reputation: tgreer is an unknown quantity at this point 
Solved Threads: 35
Team Colleague
tgreer tgreer is offline Offline
Made Her Cry

Re: saving not duplicated texts to DB

 
0
  #2
Apr 28th, 2008
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.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Other Threads in the C# Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC