Advertisement
Guest User

Untitled

a guest
Jan 21st, 2019
175
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.09 KB | None | 0 0
  1. string SQL = string.Format("SELECT * FROM Users WHERE UserName='{0}' AND Password='{1}'", MySQLEscape(Username), MySQLEscape(Password));
  2. MySqlCommand cmd = new MySqlCommand(SQL, this.connection);
  3.  
  4. private static string MySQLEscape(string str)
  5. {
  6.     return Regex.Replace(str, @"[\x00'""\b\n\r\t\cZ\\%_]",
  7.         delegate(Match match)
  8.         {
  9.             string v = match.Value;
  10.             switch (v)
  11.             {
  12.                 case "\x00":            // ASCII NUL (0x00) character
  13.                     return "\\0";  
  14.                 case "\b":              // BACKSPACE character
  15.                     return "\\b";
  16.                 case "\n":              // NEWLINE (linefeed) character
  17.                     return "\\n";
  18.                 case "\r":              // CARRIAGE RETURN character
  19.                     return "\\r";
  20.                 case "\t":              // TAB
  21.                     return "\\t";
  22.                 case "\u001A":          // Ctrl-Z
  23.                     return "\\Z";
  24.                 default:
  25.                     return "\\" + v;
  26.             }
  27.         });
  28. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement