protected void FillAllowableComponentsDdl(AjaxControlToolkit.ComboBox ddl)
{
{
ClassE calc = new ClassE(GetDirectory() + userDir);
calc = new ClassE(GetDirectory() + userDir);
calc.runsql("DELETE tblPossibleComp.* from tblPossibleComp;");
try
{
calc.MakePossibleTable(int.Parse(dropListProducts.SelectedValue));
}
catch (Exception) { }
calc.Close();
}
OleDbConnection connec = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + GetDirectory() + userDir + MAIN_USER_DATABASE + ";");
string commandRouting = "Select tblPossibleComp.* from tblPossibleComp ORDER BY ProdDesc;";
OleDbCommand cmd = new OleDbCommand(commandRouting, connec);
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd); //
{
try
{
connec.Open();
DataTable ds = new DataTable();
adapter.Fill(ds);
if (ddl != null)
{
ddl.Items.Clear();
for (int i = 0; i < ds.Rows.Count; i++)
{
ListItem item = new ListItem(ds.Rows[i]["ProdDesc"].ToString(), ds.Rows[i]["ProdID"].ToString());
ddl.Items.Add(item);
}
}
connec.Close();
}
catch (Exception ex)
{
try
{
connec.Close();
connec = null;
}
catch { }
string message = ex.Message;
}
}
}
protected void SetAllowableComponentData()
{
{
ClassE calc = new ClassE(GetDirectory() + userDir);
calc = new ClassE(GetDirectory() + userDir);
calc.runsql("DELETE * FROM tblPossibleComp;");
try
{
calc.MakePossibleTable(int.Parse(dropListProducts.SelectedValue));
}
catch (Exception) { }
calc.Close();
}
OleDbConnection connec = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + GetDirectory() + userDir + MAIN_USER_DATABASE + ";");
string commandRouting = "SELECT tblPossibleComp.* from tblPossibleComp ORDER BY ProdDesc;";
OleDbCommand cmd = new OleDbCommand(commandRouting, connec);
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd); //
{
try
{
connec.Open();
DataTable dt = new DataTable();
adapter.Fill(dt);
DataView dv = dt.DefaultView;
//need to bind this to a droplist
connec.Close();
}
catch (Exception ex)
{
try
{
connec.Close();
connec = null;
}
catch { }
string message = ex.Message;
}
}
}
