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 { }
}
