Click here to Skip to main content
15,899,313 members
Home / Discussions / C#
   

C#

 
GeneralRe: 2 tasks at the same time with Background Worker Pin
S. Senthil Kumar4-Feb-06 19:58
S. Senthil Kumar4-Feb-06 19:58 
GeneralRe: 2 tasks at the same time with Background Worker Pin
Ravi Bhavnani5-Feb-06 3:45
professionalRavi Bhavnani5-Feb-06 3:45 
QuestionTimed Backup Pin
Sean894-Feb-06 16:42
Sean894-Feb-06 16:42 
AnswerRe: Timed Backup Pin
Ravi Bhavnani4-Feb-06 17:31
professionalRavi Bhavnani4-Feb-06 17:31 
GeneralRe: Timed Backup Pin
Sean894-Feb-06 17:45
Sean894-Feb-06 17:45 
GeneralRe: Timed Backup Pin
Wayne Phipps5-Feb-06 2:35
Wayne Phipps5-Feb-06 2:35 
AnswerRe: Timed Backup Pin
Sean895-Feb-06 5:11
Sean895-Feb-06 5:11 
Questionsingle quote error in SQL Pin
emran8344-Feb-06 14:25
emran8344-Feb-06 14:25 
Hi,
I am getting an error in SQL UPDATE statement when user enters single quote character in textbox.
I used following regex to remove the single quote before submitting to SQL UPDATE Statement.
But still SQL is catching that single quote everytime even after filtering from regex. Very wondering. Can you tell me why is this happening !!

string question = rtxtInterViewQuestionSTAR.Text.Replace("\'", "").Trim();
string question = Regex.Replace(question, "\'", "", RegexOptions.Singleline | RegexOptions.Multiline).Trim();

UpdateCommand.CommandText = @"UPDATE star_interview_qa SET question ='" + question + "', strategy = '" + strategy + "', situation_task = '" + situation + "', action = '" + action + "', result = '" + result + "', sequence_no = " + sequence_noTextBoxSTAR.Text + " WHERE (id=" + lblIDqASTAR.Text + ")";


thanks and regards
EMRAN
AnswerRe: single quote error in SQL Pin
Colin Angus Mackay4-Feb-06 15:16
Colin Angus Mackay4-Feb-06 15:16 
GeneralRe: single quote error in SQL Pin
emran8344-Feb-06 17:22
emran8344-Feb-06 17:22 
GeneralRe: single quote error in SQL Pin
S. Senthil Kumar4-Feb-06 19:59
S. Senthil Kumar4-Feb-06 19:59 
GeneralRe: single quote error in SQL Pin
emran8344-Feb-06 21:19
emran8344-Feb-06 21:19 
GeneralRe: single quote error in SQL Pin
Colin Angus Mackay4-Feb-06 23:22
Colin Angus Mackay4-Feb-06 23:22 
GeneralRe: single quote error in SQL Pin
S. Senthil Kumar5-Feb-06 6:07
S. Senthil Kumar5-Feb-06 6:07 
GeneralRe: single quote error in SQL Pin
emran8345-Feb-06 10:25
emran8345-Feb-06 10:25 
GeneralRe: single quote error in SQL Pin
Roy Heil6-Feb-06 7:37
professionalRoy Heil6-Feb-06 7:37 
GeneralRe: single quote error in SQL Pin
emran8346-Feb-06 13:18
emran8346-Feb-06 13:18 
AnswerRe: single quote error in SQL Pin
Thomas Lau4-Feb-06 15:37
Thomas Lau4-Feb-06 15:37 
GeneralRe: single quote error in SQL Pin
emran8344-Feb-06 17:23
emran8344-Feb-06 17:23 
Questiontyped dataset Pin
fmardani4-Feb-06 10:23
fmardani4-Feb-06 10:23 
QuestionAccess Controls from another class Pin
tray_gator4-Feb-06 9:07
tray_gator4-Feb-06 9:07 
AnswerRe: Access Controls from another class Pin
kasik4-Feb-06 11:00
kasik4-Feb-06 11:00 
QuestionRe: Access Controls from another class Pin
tray_gator4-Feb-06 22:44
tray_gator4-Feb-06 22:44 
AnswerRe: Access Controls from another class Pin
Colin Angus Mackay4-Feb-06 15:22
Colin Angus Mackay4-Feb-06 15:22 
QuestionRe: Access Controls from another class Pin
tray_gator4-Feb-06 22:51
tray_gator4-Feb-06 22:51 

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.