Guest User

Untitled

a guest
Jan 12th, 2018
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.74 KB | None | 0 0
  1.         public bool Validate(string user, string pass)
  2.         {
  3.             bool value = false;
  4.             OdbcConnection con = new OdbcConnection("Driver={MySQL ODBC 5.1 Driver};datasource=localhost;database=conexao;user=root;password=;");
  5.  
  6.             con.Open();
  7.  
  8.             string sql = "select * FROM users where user = '" + user + "' AND pass = '" + pass + "';";
  9.             OdbcDataAdapter adp = new OdbcDataAdapter(sql, con);
  10.             DataTable users = new DataTable();
  11.             adp.Fill(users);
  12.  
  13.             if (users.Rows.Count > 0)
  14.             {
  15.                 value =  true;
  16.             }
  17.             else
  18.             {
  19.                 value =  false;
  20.             }
  21.  
  22.             return value;
  23.            
  24.         }
Add Comment
Please, Sign In to add comment