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

C#

 
GeneralRe: Drawlines on different levels Pin
Dave Kreskowiak4-Jan-11 10:24
mveDave Kreskowiak4-Jan-11 10:24 
GeneralRe: Drawlines on different levels Pin
Paladin20004-Jan-11 10:51
Paladin20004-Jan-11 10:51 
GeneralRe: Drawlines on different levels Pin
AlexB474-Jan-11 13:58
AlexB474-Jan-11 13:58 
Questionhelp with realization Pin
polycom1234-Jan-11 4:54
polycom1234-Jan-11 4:54 
AnswerRe: help with realization Pin
Luc Pattyn4-Jan-11 5:00
sitebuilderLuc Pattyn4-Jan-11 5:00 
GeneralRe: help with realization Pin
polycom1234-Jan-11 18:38
polycom1234-Jan-11 18:38 
Questionhow to pass parameters and values with function name in url? Pin
roebuck-code3-Jan-11 22:17
roebuck-code3-Jan-11 22:17 
AnswerRe: how to pass parameters and values with function name in url? PinPopular
Keith Barrow4-Jan-11 0:22
professionalKeith Barrow4-Jan-11 0:22 
Firstly I would suggest do not build your query like this:
string sql = " insert into FX_Forecast2 (Symbol,DateTime) values( '"+s+"',"+d+")";

You leave yourself open to SQL Injection Attacks[^] Use a paramterised query[^] instead.

Secondly, you are not checking that d is a date: this is a recipie for disaster or, at least insert failure exceptions, which are costly in terms of performance.

Points 1 & 2 are especially true if the values are coming from outside you application, such as the WebServce you state.

Finaly, if the strings s and d are correct, your SQL will be generated correctly as far as I can tell, so the problem is probably with the code calling this method. Have you checked that values of s and d?

GeneralRe: how to pass parameters and values with function name in url? Pin
Dalek Dave4-Jan-11 0:59
professionalDalek Dave4-Jan-11 0:59 
GeneralRe: how to pass parameters and values with function name in url? Pin
roebuck-code4-Jan-11 2:31
roebuck-code4-Jan-11 2:31 
GeneralRe: how to pass parameters and values with function name in url? Pin
Keith Barrow4-Jan-11 3:01
professionalKeith Barrow4-Jan-11 3:01 
GeneralRe: how to pass parameters and values with function name in url? Pin
fjdiewornncalwe4-Jan-11 3:28
professionalfjdiewornncalwe4-Jan-11 3:28 
AnswerRe: how to pass parameters and values with function name in url? Pin
Not Active4-Jan-11 2:34
mentorNot Active4-Jan-11 2:34 
GeneralRe: how to pass parameters and values with function name in url? Pin
roebuck-code4-Jan-11 3:16
roebuck-code4-Jan-11 3:16 
GeneralRe: how to pass parameters and values with function name in url? [modified] Pin
Manfred Rudolf Bihy4-Jan-11 4:21
professionalManfred Rudolf Bihy4-Jan-11 4:21 
GeneralRe: how to pass parameters and values with function name in url? Pin
roebuck-code4-Jan-11 19:57
roebuck-code4-Jan-11 19:57 
GeneralRe: how to pass parameters and values with function name in url? Pin
Manfred Rudolf Bihy5-Jan-11 1:49
professionalManfred Rudolf Bihy5-Jan-11 1:49 
GeneralRe: how to pass parameters and values with function name in url? Pin
roebuck-code5-Jan-11 2:49
roebuck-code5-Jan-11 2:49 
GeneralRe: how to pass parameters and values with function name in url? Pin
Manfred Rudolf Bihy5-Jan-11 3:05
professionalManfred Rudolf Bihy5-Jan-11 3:05 
GeneralRe: how to pass parameters and values with function name in url? [modified] Pin
roebuck-code5-Jan-11 21:55
roebuck-code5-Jan-11 21:55 
AnswerRe: how to pass parameters and values with function name in url? Pin
roebuck-code12-Feb-11 20:13
roebuck-code12-Feb-11 20:13 
QuestionFail to read simple string from the registry ( code attached ) Pin
Yanshof3-Jan-11 21:46
Yanshof3-Jan-11 21:46 
AnswerRe: Fail to read simple string from the registry ( code attached ) Pin
JF20153-Jan-11 22:00
JF20153-Jan-11 22:00 
GeneralRe: Fail to read simple string from the registry ( code attached ) Pin
Yanshof3-Jan-11 22:15
Yanshof3-Jan-11 22:15 
GeneralRe: Fail to read simple string from the registry ( code attached ) Pin
JF20153-Jan-11 22:18
JF20153-Jan-11 22:18 

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.