Example #1
0
 private void btnEdit2_Click(object sender, EventArgs e)
 {
     try
     {
         if (!(string.IsNullOrWhiteSpace(cmbService.Text)))//makes sure that the service is not empty
         {
             connection.Open();
             MySqlCommand command = new MySqlCommand();
             command.Connection  = connection;
             command.CommandText = "Select Servicenum FROM tblservice WHERE ServiceName='" + cmbService.Text + "'";
             MySqlDataReader reader  = command.ExecuteReader();
             int             servNum = 0;
             while (reader.Read())
             {
                 servNum = Convert.ToInt16(reader["ServiceNum"].ToString());//gets the service num
             }
             reader.Close();
             connection.Close();
             AdminEdit AdminEdit = new AdminEdit(cmbService.Text, servNum);//passes the name and the number so it can be edited in to other form so it can be displayed there
             AdminEdit.ShowDialog();
         }
         else
         {
             MessageBox.Show("Choose Service Name");
         }
     }
     catch (Exception a)
     {
         MessageBox.Show(a.ToString());
         connection.Close();
     }
 }
Example #2
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            AdminEdit AdminEdit = new AdminEdit();//takes you to the other form with no information because the user willl input new infomation there

            AdminEdit.ShowDialog();
        }