[C#] Restart Problem
#21

Basic SQL:

Strings are quoted with single(apostrophes) or double quotes.

 

UPDATE `newproject_db`.`t_characters` SET `a_enable` = 0 WHERE `t_characters`.`a_Name` = Tast;

 

And in C# it would be something like this(quotes in strings you could write with \something\ or \" something\"):

string PlayerId = maskedTextBox1.Text;
string query = "SELECT * FROM `t_characters` a_index WHERE `a_name` = \" + PlayerId + "\;"; // And how can i Include the string PlayerID ?

Or this (C# specific for writing string literals):

string PlayerId = maskedTextBox1.Text;
string query = @"SELECT * FROM `t_characters` a_index WHERE `a_name` = " + PlayerId + ";"; // And how can i Include the string PlayerID ?

 

C# basic string concatenation.



Messages In This Thread
[No subject] - by Nikolee - 04-27-2012, 09:50 PM
[No subject] - by Nikolee - 04-27-2012, 10:20 PM
[No subject] - by HateMe - 04-28-2012, 12:03 PM
[No subject] - by Nikolee - 04-28-2012, 01:07 PM
[No subject] - by HateMe - 04-28-2012, 01:28 PM
[No subject] - by Nikolee - 04-28-2012, 04:36 PM
[No subject] - by Nikolee - 04-28-2012, 07:55 PM
[No subject] - by HateMe - 04-28-2012, 10:38 PM
[No subject] - by Nikolee - 05-01-2012, 10:09 PM
[No subject] - by HateMe - 05-01-2012, 11:06 PM
[No subject] - by Nikolee - 05-02-2012, 10:54 AM
[No subject] - by Nikolee - 05-03-2012, 01:24 PM
[No subject] - by someone - 05-03-2012, 11:35 PM
[No subject] - by HateMe - 05-04-2012, 12:00 AM
[No subject] - by Nikolee - 05-05-2012, 11:47 AM
[No subject] - by someone - 05-05-2012, 12:26 PM
[No subject] - by HateMe - 05-05-2012, 12:30 PM
[No subject] - by Nikolee - 05-05-2012, 12:37 PM
[No subject] - by HateMe - 05-05-2012, 01:11 PM
[No subject] - by Nikolee - 05-05-2012, 10:57 PM
[No subject] - by someone - 05-05-2012, 11:37 PM
[No subject] - by Nikolee - 05-06-2012, 04:09 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)