Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void loginButton_Click(object sender, EventArgs e)
- {
- AdamPanel blarg = new AdminPanel();
- string pass, user;
- string password = "";
- string username = "";
- user = usernameBox.Text;
- pass = passwordBox.Text;
- DataSet bb = new DataSet();
- string connectionString = "datasource=stuff;database=users";
- MySqlConnection mysql = new MySqlConnection(connectionString);
- MySqlDataAdapter adapter = new MySqlDataAdapter();
- adapter.SelectCommand = new MySqlCommand("SELECT * FROM RegularUsers WHERE Username = '" + user + "' AND Password = '" + pass + "'", mysql);
- adapter.Fill(bb);
- if(bb.HasRows)
- blarg.Show();
- return 0;
- }
- }
- }
- public int Load()
- {
- string connectionString = "datasource=STUFF YOU SHOULDNT SEEdatabase=users";
- MySqlConnection mysql = new MySqlConnection(connectionString);
- MySqlDataAdapter adapter = new MySqlDataAdapter();
- mysql.SelectCommand = new MySqlCommand("SELECT * FROM [RegularUsers] WHERE Username = '" + this.username + "' AND Pass = '" + this.password + "'", conn);
- mysql.Fill(dataset);
- if (dataset.HasRows)
- return 1;
- return 0;
- }
- public MySqlConnection NewConnection()
- {
- string cstr = String.Format(
- "SERVER={0};PORT={1};DATABASE={2};UID={3};PWD={4}",
- sett.DBHost, sett.DBPort, sett.DBDatabase,
- HotelDB.user, HotelDB.password);
- MySqlConnection conn = new MySqlConnection(cstr);
- try { conn.Open(); }
- catch (Exception ex)
- {
- conn = null;
- }
- return conn;
- }
- private MySqlCommand NewCommand(MySqlConnection conn, string cmd, params object[] parameters)
- {
- if (conn==null) return null;
- MySqlCommand command;
- try
- {
- command = new MySqlCommand(cmd, conn);
- if (parameters != null)
- {
- int index = 0;
- while (index < parameters.Length)
- {
- command.Parameters.Add(
- new MySqlParameter((string)parameters[index], parameters[index + 1]));
- index += 2;
- }
- }
- }
- catch { command = null; }
- return command;
- }
- private string MD5(string Value)
- {
- System.Security.Cryptography.MD5CryptoServiceProvider x = new System.Security.Cryptography.MD5CryptoServiceProvider();
- byte[] data = System.Text.Encoding.ASCII.GetBytes(Value);
- data = x.ComputeHash(data);
- string ret = "";
- for (int i=0; i < data.Length; i++)
- ret += data[i].ToString("x2").ToLower();
- return ret;
- }
- MySqlConnection conn = NewConnection(.....);
- MySqlCommand cmd = NewCommand(conn,"SELECT userid,useractive FROM table WHERE username=@user AND MD5(password)=@pwd","user",username,"pwd",MD5(pwd));
- MySqlDataReader rd = cmd.ExecuteReader();
- private void button Click
- {
- MySqlConnection mcon = new MySqlConnection("Yourconnection");
- MySqlDataAdapter adapter;
- DataTable table = new DataTable();
- adapter = new MySqlDataAdapter("Select * From database.table where Username = '" + textbox1.Text + "' and password = '" + textbox2.Text + "'", mcon);
- adapter.Fill(table);
- if (table.Rows.Count <= 0)
- {
- //message something
- }
- else
- {
- //show main form
- }
- }
- public bool ValidateLogin(string username, string password)
- {
- MySqlConnection conn = new MySqlConnection("[YOURCONNECTIONSTRING]");
- MySqlDataAdapter adapter = new MySqlDataAdapter();
- adapter.SelectCommand = new MySqlCommand("SELECT * FROM [YOURUSERTABLE] WHERE Username = ? AND Pass = ?", conn);
- adapter.SelectCommand.Parameters.Add("@Username", username);
- adapter.SelectCommand.Parameters.Add("@Password", password);
- adapter.Fill(dataset);
- If (dataset.HasRows)
- {
- // User is logged in maybe do FormsAuthentication.SetAuthcookie(username);
- return true;
- } else {
- // Authentication failed
- return false;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement