private void button5_Click(object sender, EventArgs e) { fillwithalljobs(); CID2text.Clear(); OPsearchbutt.Enabled = true; AllJobButt.Enabled = false; }
private void OPsearchbutt_Click(object sender, EventArgs e) { ConnectionManagerOffsite newconn = new ConnectionManagerOffsite(); newconn.OpenCon(); SqlDataAdapter sda1 = new SqlDataAdapter("select o.JobID, o.JobType, o.JobStatus, o.StartDate, o.CustomerNIC from OffSiteJob o where o.JobStatus = 'ON' ", ConnectionManagerOffsite.conn); DataTable dt = new DataTable(); sda1.Fill(dt); OffsitejobsdataGridView.DataSource = dt; CID2text.Clear(); OPsearchbutt.Enabled = false; AllJobButt.Enabled = true; }