Click here to Skip to main content
15,615,774 members
Home / Discussions / C#
   

C#

 
GeneralRe: Getting values from tasklist.exe /v Pin
CCodeNewbie8-Apr-12 9:06
CCodeNewbie8-Apr-12 9:06 
GeneralRe: Getting values from tasklist.exe /v Pin
CCodeNewbie8-Apr-12 9:11
CCodeNewbie8-Apr-12 9:11 
GeneralRe: Getting values from tasklist.exe /v - update Pin
CCodeNewbie7-Apr-12 23:24
CCodeNewbie7-Apr-12 23:24 
Questionprogrammatically log into yahoo or godaddy Pin
DanYELL6-Apr-12 16:55
DanYELL6-Apr-12 16:55 
Questionuse select statement inside insert statement in ado.net Pin
mrx1006-Apr-12 12:22
mrx1006-Apr-12 12:22 
AnswerRe: use select statement inside insert statement in ado.net Pin
PIEBALDconsult6-Apr-12 12:55
professionalPIEBALDconsult6-Apr-12 12:55 
AnswerRe: use select statement inside insert statement in ado.net Pin
JOAT-MON6-Apr-12 14:07
JOAT-MON6-Apr-12 14:07 
AnswerRe: use select statement inside insert statement in ado.net Pin
Luc Pattyn6-Apr-12 15:31
sitebuilderLuc Pattyn6-Apr-12 15:31 
I would use two SQL statements, one to get the place ID from its name, then the big insert which needs the result of the former statement.

And I would:
- never publish code in a proportional font (they invented PRE tags to get readable code here);
- not build such complex statements; why not building a string first, so you can see it, log it, whatever;
- not take user input without validating it;
- use SqlParameters.

And finally you could consider creating a stored procedure to do this.

Smile | :)
Luc Pattyn [My Articles] Nil Volentibus Arduum

QuestionCode Insertion Syntax Query Pin
mauricemcse6-Apr-12 6:39
mauricemcse6-Apr-12 6:39 
AnswerRe: Code Insertion Syntax Query Pin
Wes Aday6-Apr-12 6:59
professionalWes Aday6-Apr-12 6:59 
AnswerRe: Code Insertion Syntax Query Pin
Big Daddy Farang6-Apr-12 7:03
Big Daddy Farang6-Apr-12 7:03 
GeneralRe: Code Insertion Syntax Query Pin
mauricemcse6-Apr-12 10:11
mauricemcse6-Apr-12 10:11 
GeneralRe: Code Insertion Syntax Query Pin
Ennis Ray Lynch, Jr.6-Apr-12 10:24
Ennis Ray Lynch, Jr.6-Apr-12 10:24 
GeneralRe: Code Insertion Syntax Query Pin
Big Daddy Farang6-Apr-12 12:17
Big Daddy Farang6-Apr-12 12:17 
AnswerRe: Code Insertion Syntax Query Pin
Abhinav S6-Apr-12 7:32
Abhinav S6-Apr-12 7:32 
QuestionHow to restrict a class from other project Pin
NarVish6-Apr-12 0:45
NarVish6-Apr-12 0:45 
AnswerRe: How to restrict a class from other project Pin
V.6-Apr-12 1:02
professionalV.6-Apr-12 1:02 
AnswerRe: How to restrict a class from other project Pin
NarVish6-Apr-12 1:06
NarVish6-Apr-12 1:06 
GeneralRe: How to restrict a class from other project Pin
OriginalGriff6-Apr-12 1:15
mvaOriginalGriff6-Apr-12 1:15 
GeneralRe: How to restrict a class from other project Pin
NarVish6-Apr-12 2:02
NarVish6-Apr-12 2:02 
GeneralRe: How to restrict a class from other project Pin
OriginalGriff6-Apr-12 2:17
mvaOriginalGriff6-Apr-12 2:17 
GeneralRe: How to restrict a class from other project Pin
V.6-Apr-12 1:55
professionalV.6-Apr-12 1:55 
GeneralRe: How to restrict a class from other project Pin
NarVish6-Apr-12 2:03
NarVish6-Apr-12 2:03 
RantWait form Pin
cursore846-Apr-12 0:16
cursore846-Apr-12 0:16 
AnswerRe: Wait form Pin
V.6-Apr-12 1:03
professionalV.6-Apr-12 1:03 

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.