private void btnAddedCLOs_Click(object sender, EventArgs e)
 {
     using (SqlConnection con = new SqlConnection(constr))
     {
         using (SqlCommand cmd = new SqlCommand("SELECT * FROM dbo.Clo", con))
         {
             cmd.CommandType = CommandType.Text;
             using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
             {
                 using (DataTable dt = new DataTable())
                 {
                     sda.Fill(dt);
                     CLOsDataGridView.DataSource = dt;
                 }
             }
         }
     }
     CLOsDataGridView.Show();
     //ListOfAddedCLOsForm l = new ListOfAddedCLOsForm();
     //this.Hide();
     //l.Show();
     lblCLOName.Hide();
     txtCLOName.Hide();
     lblCreatedDate.Hide();
     dtpCreatedDate.Hide();
     btnAddCLOs.Hide();
 }
 private void button1_Click(object sender, EventArgs e)
 {
     lblCLOName.Show();
     txtCLOName.Show();
     lblCreatedDate.Show();
     dtpCreatedDate.Show();
     btnAddCLOs.Show();
     CLOsDataGridView.Hide();
 }
 private void AddNewCLOsForm_Load(object sender, EventArgs e)
 {
     CLOsDataGridView.Hide();
 }