Guest User

Untitled

a guest
Nov 23rd, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.99 KB | None | 0 0
  1. [WebMethod]
  2. public int connectoToMySql()
  3. {
  4. string Login = "emaildeteste";
  5. string Pass = "umasenhaforteai";
  6.  
  7. string connString = "SERVER=local" + ";" +
  8. "DATABASE=admin;" +
  9. "UID=root;" +
  10. "PASSWORD=*******;" +
  11. "Allow User Variables = True;";
  12.  
  13. MySqlConnection cnMySQL = new MySqlConnection(connString);
  14.  
  15. MySqlCommand cmdMySQL = cnMySQL.CreateCommand();
  16.  
  17. MySqlDataReader reader;
  18.  
  19. cmdMySQL.CommandText = "select * from core_members where `email` = @Login";
  20.  
  21. cnMySQL.Open();
  22.  
  23. reader = cmdMySQL.ExecuteReader();
  24.  
  25. DataTable dt = new DataTable();
  26. dt.Load(reader);
  27.  
  28. cnMySQL.Close();
  29.  
  30. if (dt.Rows.Count > 0)
  31. {
  32. return 1;
  33. Console.WriteLine("Pegou a ROW");
  34. }
  35. return 50; //so testando
  36.  
  37. cmdMySQL.CommandText = "select * from core_members where `email` = @Login";
  38. cmdMySQL.Parameters.AddWithValue("@Login", Login );
Add Comment
Please, Sign In to add comment