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