Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void db_connection()
- {
- try
- {
- conn = "";
- connect = new MySqlConnection(conn);
- connect.Open();
- }
- catch (MySqlException e)
- {
- throw;
- }
- }
- private bool validate_login(string user, string pass)
- {
- db_connection();
- MySqlCommand cmd = new MySqlCommand();
- cmd.CommandText = "Select * from table2 where username=@user and password=@pass";
- cmd.Parameters.AddWithValue("@user", user);
- cmd.Parameters.AddWithValue("@pass", pass);
- cmd.Connection = connect;
- MySqlDataReader login = cmd.ExecuteReader();
- if (login.Read())
- {
- connect.Close();
- return true;
- }
- else
- {
- connect.Close();
- return false;
- }
- }
- private void button1_Click(object sender, EventArgs e)
- {
- {
- string user = username.Text;
- string pass = password.Text;
- if (user == "" || pass == "")
- {
- MessageBox.Show("Empty Fields Detected ! Please fill up all the fields");
- return;
- }
- bool r = validate_login(user, pass);
- if (r)
- {
- conn = "";
- connect = new MySqlConnection(conn);
- connect.Open();
- SqlCommand command = new SqlCommand("Select UserID from table2 where username=@user");
- command.Parameters.AddWithValue("@user", "username");
- // int result = command.ExecuteNonQuery();
- using (SqlDataReader reader = command.ExecuteReader())
- {
- if (reader.Read())
- {
- Console.WriteLine(String.Format("{0}", reader["UserID"]));
- }
- }
- connect.Close();
- }
- {
- Form1 f1 = new Form1();
- this.Hide();
- var form1 = new Form1();
- form1.Closed += (s, args) => this.Close();
- form1.Show();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement