Click here to Skip to main content
15,890,336 members
Home / Discussions / C#
   

C#

 
GeneralRe: SaveFileDialog and OverwritePrompt Pin
GenJerDan25-Jan-13 3:13
GenJerDan25-Jan-13 3:13 
AnswerRe: SaveFileDialog and OverwritePrompt Pin
micke.andersson28-Jan-13 2:44
micke.andersson28-Jan-13 2:44 
GeneralRe: SaveFileDialog and OverwritePrompt Pin
GenJerDan28-Jan-13 3:10
GenJerDan28-Jan-13 3:10 
QuestionThread with Message Pump Pin
Richard Andrew x6424-Jan-13 1:56
professionalRichard Andrew x6424-Jan-13 1:56 
AnswerRe: Thread with Message Pump Pin
Eddy Vluggen24-Jan-13 2:49
professionalEddy Vluggen24-Jan-13 2:49 
AnswerRe: Thread with Message Pump Pin
Paulo Zemek24-Jan-13 3:49
mvaPaulo Zemek24-Jan-13 3:49 
AnswerRe: Thread with Message Pump Pin
BobJanova24-Jan-13 4:22
BobJanova24-Jan-13 4:22 
QuestionEnding session and back button after logout Pin
sahavasiwebwonders24-Jan-13 0:24
sahavasiwebwonders24-Jan-13 0:24 
AnswerRe: Ending session and back button after logout Pin
Simon_Whale24-Jan-13 0:36
Simon_Whale24-Jan-13 0:36 
GeneralRe: Ending session and back button after logout Pin
sahavasiwebwonders24-Jan-13 0:41
sahavasiwebwonders24-Jan-13 0:41 
AnswerRe: Ending session and back button after logout Pin
BobJanova24-Jan-13 1:28
BobJanova24-Jan-13 1:28 
GeneralRe: Ending session and back button after logout Pin
sahavasiwebwonders24-Jan-13 18:59
sahavasiwebwonders24-Jan-13 18:59 
QuestionTally Integration Pin
Atul Ankush Bhabal23-Jan-13 22:38
Atul Ankush Bhabal23-Jan-13 22:38 
AnswerRe: Tally Integration Pin
Pete O'Hanlon23-Jan-13 22:43
mvePete O'Hanlon23-Jan-13 22:43 
QuestionHow check if a record exists before running the code to delete the record? Pin
Member 964160223-Jan-13 22:37
Member 964160223-Jan-13 22:37 
AnswerRe: How check if a record exists before running the code to delete the record? Pin
dan!sh 23-Jan-13 22:57
professional dan!sh 23-Jan-13 22:57 
AnswerRe: How check if a record exists before running the code to delete the record? Pin
Richard MacCutchan23-Jan-13 23:01
mveRichard MacCutchan23-Jan-13 23:01 
AnswerRe: How check if a record exists before running the code to delete the record? Pin
Eddy Vluggen24-Jan-13 0:43
professionalEddy Vluggen24-Jan-13 0:43 
AnswerRe: How check if a record exists before running the code to delete the record? Pin
V.24-Jan-13 1:57
professionalV.24-Jan-13 1:57 
if you delete it while it doesn't exist SQL will return something like: "0 rows deleted".

SQL
Delete from tableX where myconstraint='Myconstraint';

--> query returned in 10 ms: 0 rows deleted


If you do it in code you can get that by reading out the NrOfRowsAffected property when doing an ExecuteNonQuery statement. Same goes for Insert and Update queries eg.
as someone already replied, checking if it exists is inaccurate at best and doesn't add any functional advantage.

if you really, really must check it. Perform a select query perhaps with a count.

SQL
Select count(id) from tableX where myconstraint='Myconstraint'

if count > 0 , the record exists.

hope this helps.

AnswerRe: How check if a record exists before running the code to delete the record? Pin
PIEBALDconsult24-Jan-13 4:40
mvePIEBALDconsult24-Jan-13 4:40 
AnswerRe: How check if a record exists before running the code to delete the record? Pin
pt140125-Jan-13 9:15
pt140125-Jan-13 9:15 
Questionneed the project code in c# Pin
Member 978198223-Jan-13 21:58
Member 978198223-Jan-13 21:58 
GeneralRe: need the project code in c# Pin
PIEBALDconsult23-Jan-13 22:01
mvePIEBALDconsult23-Jan-13 22:01 
AnswerRe: need the project code in c# Pin
Pete O'Hanlon23-Jan-13 22:18
mvePete O'Hanlon23-Jan-13 22:18 
AnswerRe: need the project code in c# Pin
pt140125-Jan-13 9:16
pt140125-Jan-13 9:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.