private void viewunderproductioncs_Load(object sender, EventArgs e) { if (!BGworker.IsBusy) { RetriveTableData TObj = new RetriveTableData(); DGview.Rows.Clear(); BGworker.RunWorkerAsync(TObj); } }
private void Viewtoolingisseu_Load(object sender, EventArgs e) { if (!BGworker.IsBusy) { RetriveTableData TObj = new RetriveTableData(); //SELECT * FROM ToolingReturnedhistory WHERE ToolingIssue_Yes = 'Yes' DGview.Rows.Clear(); BGworker.RunWorkerAsync(TObj); } }
private void BGworker_DoWork(object sender, DoWorkEventArgs e) { RetriveTableData Obj = (RetriveTableData)e.Argument; try { SqlConnection connection = new SqlConnection(Mydb.connectionstring); SqlCommand cmd = new SqlCommand(Querysql, connection); connection.Open(); using (SqlDataReader Reader = cmd.ExecuteReader()) { while (Reader.Read()) { Obj.ToolingNumber1 = Reader["ToolingNumber"].ToString().Trim(); Obj.ToolsName1 = Reader["ToolsName"].ToString().Trim(); Obj.PartNumber1 = Reader["PartNumber"].ToString().Trim(); Obj.ProductFamily1 = Reader["ProductFamily"].ToString().Trim(); Obj.dateTimeReturned1 = Reader["dateTimeReturned"].ToString().Trim(); Obj.Returnby1 = Reader["Returnby"].ToString().Trim(); Obj.ReturnedQTY1 = Reader["ReturnedQTY"].ToString().Trim(); Obj.ToolsStatus1 = Reader["ToolsStatus"].ToString().Trim(); Obj.Reasonnotcompleted1 = Reader["Reasonnotcompleted"].ToString().Trim(); Obj.Usedby1 = Reader["Usedby"].ToString().Trim(); Obj.ToolingIssue_Yes1 = Reader["ToolingIssue_Yes"].ToString().Trim(); Obj.TechnicianansFeedback1 = Reader["TechnicianansFeedback"].ToString().Trim(); Obj.Lifetimeusage1 = Reader["Lifetimeusage"].ToString().Trim(); System.Threading.Thread.Sleep(100); BGworker.ReportProgress(0, Obj); } connection.Close(); } } catch (Exception) { throw; } }
private void BGworker_DoWork(object sender, DoWorkEventArgs e) { RetriveTableData Obj = (RetriveTableData)e.Argument; try { SqlConnection connection = new SqlConnection(Mydb.connectionstring); SqlCommand cmd = new SqlCommand(Querysql, connection); connection.Open(); using (SqlDataReader Reader = cmd.ExecuteReader()) { while (Reader.Read()) { Obj.ToolingNumber1 = Reader["ToolingNumber"].ToString().Trim(); Obj.StorageLocation1 = Reader["StorageLocation"].ToString().Trim(); Obj.ActualToolsQty1 = Reader["ActualToolsQty"].ToString().Trim(); Obj.ToolsName1 = Reader["ToolsName"].ToString().Trim(); Obj.PartNumber1 = Reader["PartNumber"].ToString().Trim(); Obj.ProductFamily1 = Reader["ProductFamily"].ToString().Trim(); Obj.DateTimeout1 = Reader["DateTimeout"].ToString().Trim(); Obj.TakenBy1 = Reader["TakenBy"].ToString().Trim(); Obj.ToolingoutQty1 = Reader["ToolingoutQty"].ToString().Trim(); Obj.WONumber1 = Reader["WONumber"].ToString().Trim(); Obj.WOQty1 = Reader["WOQty"].ToString().Trim(); Obj.Note1 = Reader["Note"].ToString().Trim(); Obj.Status1 = Reader["Status"].ToString().Trim(); System.Threading.Thread.Sleep(100); BGworker.ReportProgress(0, Obj); } connection.Close(); } } catch (Exception) { throw; } }