private void button1_Click(object sender, EventArgs e) { SqlConnection sqlco = new SqlConnection( @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\plumz\OneDrive\Documents\Programming Project 2021\PROGRAM\Database\Gym_Management_DB.mdf;Integrated Security=True;Connect Timeout=30"); SqlCommand cmd = new SqlCommand( "SELECT * FROM log_data WHERE username = '" + username.Text.Trim() + "' AND password = '" + password.Text.Trim() + "' ", sqlco); SqlDataAdapter sda = new SqlDataAdapter(cmd); var dt = new DataTable(); sda.Fill(dt); string usertype = user_type.SelectedItem.ToString(); if (dt.Rows.Count > 0) { for (var i = 0; i < dt.Rows.Count; i++) //state rows in table { if (dt.Rows[i]["usertype"].ToString() == usertype) { MessageBox.Show("You are logged in as " + dt.Rows[i][2]); switch (user_type.SelectedIndex) { case 0: { customer customer1 = new customer(); customer1.Show(); this.Hide(); break; } case 1: { Staff staff1 = new Staff(); staff1.Show(); this.Hide(); break; } case 2: { Trainer trainer1 = new Trainer(); trainer1.Show(); this.Hide(); break; } default: MessageBox.Show("wah gwan"); break; } // end nested switch } //end check for user type } } // end row count else { MessageBox.Show("The username or password is incorrect,Try Again"); } } // end button LOG IN CLICK
string usertype = user_type.SelectedItem.ToString();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)