private void ucJobFeesAddEdit_VisibleChanged(object sender, EventArgs e) { Connection con = new Findstaff.Connection(); connection = con.dbConnection(); if (this.Visible == true) { connection.Open(); cmd = "Select Jorder_id from joborder_t where cntrctstat = 'Active';"; com = new MySqlCommand(cmd, connection); dr = com.ExecuteReader(); while (dr.Read()) { cbJobOrder1.Items.Add(dr[0]); } dr.Close(); cmd = "Select feename from genfees_t;"; com = new MySqlCommand(cmd, connection); dr = com.ExecuteReader(); while (dr.Read()) { cbFees1.Items.Add(dr[0]); } dr.Close(); connection.Close(); } }
private void ucJobFeesAddEdit_VisibleChanged(object sender, EventArgs e) { Connection con = new Findstaff.Connection(); connection = con.dbConnection(); connection.Open(); cmd = "select jo.jorder_id'Job Order ID', count(jf.fee_id)'No. of Fees' from joborder_t jo join jobfees_t jf on jo.jorder_id = jf.jorder_id"; using (connection) { using (MySqlDataAdapter adapter = new MySqlDataAdapter(cmd, connection)) { DataSet ds = new DataSet(); adapter.Fill(ds); dgvJobFees.DataSource = ds.Tables[0]; } } connection.Close(); }