private void displayLessees()
        {
            contractLesseesflowLayoutPanel.Controls.Clear();
            int sp = 3;
            int ep = 3;

            try
            {
                _cc.getLesseePaymentDetails();
                foreach (DataRow row in _cc.QueryExe().Rows)
                {
                    Button b = new Button();
                    b.Name      = row["lessee_id"].ToString();
                    b.Text      = row["l_lastname"].ToString() + " ," + row["l_firstname"].ToString();
                    b.Location  = new Point(sp, ep);
                    b.Height    = 41;
                    b.Width     = 204;
                    b.FlatStyle = FlatStyle.Popup;
                    b.BackColor = SystemColors.Control;
                    contractLesseesflowLayoutPanel.Controls.Add(b);
                    ep      += 10;
                    b.Click += delegate(object sender, EventArgs evt) { btn_Click(sender, evt, row); };
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
 private void duePaymentsBtn_Click(object sender, EventArgs e)
 {
     try
     {
         paymentsClass p = new paymentsClass();
         p.getLesseePaymentDetails();
         crypt.Load(domainName + "duePaymentsCrystalReport.rpt");
         crypt.SetDataSource(p.datasetQuery("stall_contract"));
         reportsCrystalReportViewer.ReportSource = crypt;
         reportsCrystalReportViewer.Refresh();
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }