// Event handler for button click


private void button1_Click(object sender, EventArgs e)

{



// Check if the text boxes have any text


if(string.IsNullOrEmpty(textBox1.Text))

	{ MessageBox.Show("You have to complete the username field!", "Error!", 	  MessageBoxButtons.OK, MessageBoxIcon.Stop);

        textBox1.Focus();

        }

  else
   if(string.IsNullOrEmpty(textBox2.Text))

       {

         MessageBox.Show("You have to complete the password field!", "Error!",          MessageBoxButtons.OK, MessageBoxIcon.Stop);

         textBox2.Focus();

       }


string connectionString = "Server = 127.0.0.1; Port = 3306; Database = db_admin; Uid = root;Pwd=;";

// Details for connection


//string connectionString = "Server = 192.168.1.113;

// Port = 3306; Database = db_A030;

// Uid = user_A030;

// Pwd = pass_A030";


string querry = "SELECT userType FROM users WHERE userName = '" + textBox1.Text + "' AND userPass = '" + textBox2.Text +"'";

// The querry for the database


connection = new MySqlConnection(connectionString);

// Create a connection with the database


command = new MySqlCommand(querry, connection);

// Create a command for the database



connection.Open();

// Connect to the database


string userType = command.ExecuteScalar() as string;

// Execute the command and return the result as a string


connection.Close();

// Close the connection to the database



// Check if any results have been returned.

// If there is no result, return an error to the user


if (string.IsNullOrEmpty(userType))

        {

          MessageBox.Show("Wrong username or password!", "Error!",                     MessageBoxButtons.OK,MessageBoxIcon.Error);

          textBox1.Text = "";

          textBox2.Text = "";

        }


// If there is a result, check if the user is an administrator or an user based on what the // database returned and

// open the form for the administrator or the user


    else
        if (userType.Equals("A"))

        {

         AdminForm f = new AdminForm();

         f.Show();

         this.Close();

        }

         else
             if (userType.Equals("U"))

		            {

                              UserForm f = new UserForm();

     			      f.Show();

                              this.Close();

		            }


     }