public void GetWorkerByType(string p, int t, TextBox txt, DropDownList ddl) { WORKERTableAdapter daWorker = new WORKERTableAdapter(); if (p != null) { try { daWorker.FillBy(dsNBD.WORKER, t, Convert.ToInt32(p)); } catch { } rows = dsNBD.WORKER.Select(); } else { try { daWorker.Fill(dsNBD.WORKER); } catch { } rows = dsNBD.WORKER.Select("wrkTypeID=" + t); } foreach (DataRow row in rows) { if (txt != null) { txt.Text = row.ItemArray[1].ToString() + " " + row.ItemArray[2].ToString(); } else if (ddl != null) { ddl.Items.Add(row.ItemArray[1].ToString() + " " + row.ItemArray[2].ToString()); } } }
public void GetWorkerByType(string p, int t, TextBox txt, DropDownList ddl) { // Get a list of workers by their work type WORKERTableAdapter daWorker = new WORKERTableAdapter(); // If a project id exists, search workers by project ID if (p != null) { try { daWorker.FillBy(dsNBD.WORKER, t, Convert.ToInt32(p)); } catch { } rows = dsNBD.WORKER.Select(); } // Other wise just select by type else { try { daWorker.Fill(dsNBD.WORKER); } catch { } rows = dsNBD.WORKER.Select("wrkTypeID=" + t); } // Check if control is textbox or ddl and fill in accordingly foreach (DataRow row in rows) { if (txt != null) { txt.Text = row.ItemArray[1].ToString() + " " + row.ItemArray[2].ToString(); } else if (ddl != null) { ddl.Items.Add(row.ItemArray[1].ToString() + " " + row.ItemArray[2].ToString()); } } }
static Home() { dsNBD = new NBDDataSet(); PROJECTTableAdapter daProject = new PROJECTTableAdapter(); CLIENTTableAdapter daClient = new CLIENTTableAdapter(); WORKERTableAdapter daWorker = new WORKERTableAdapter(); PROD_TEAMTableAdapter daProdTeam = new PROD_TEAMTableAdapter(); try { daProject.Fill(dsNBD.PROJECT); daClient.Fill(dsNBD.CLIENT); daWorker.Fill(dsNBD.WORKER); daProdTeam.Fill(dsNBD.PROD_TEAM); } catch { } }