private void CB_3_DropDown(object sender, EventArgs e)
{
if (CB_3.DataSource == null && CB_1.Text != "" && CB_2.Text != "")
{
AccessDBC aa = new AccessDBC();
aa.Dic_in.Add(CB_1.Tag.ToString(), CB_1.Text);
aa.Dic_in.Add(CB_2.Tag.ToString(), CB_2.Text);
CB_3.DataSource = aa.GetData(aa.Dic_in, "Capacitorsheet", CB_3.Tag.ToString());//data source accept list
}
}
private void Form1_Load(object sender, EventArgs e)
{//required to define location for database here
EIndex = ToExcelC.rowcounts;
AccessDBC.connection_str = AccessDBC.Database_LOC("SMB.accdb");
//@@## nead to add database check module that if remote database not reachable close application
AccessDBC a = new AccessDBC();
CB_1.DataSource = a.GetData(null, "DOL", CB_1.Tag.ToString());
}
private void CB_1_SelectedIndexChanged(object sender, EventArgs e)
{
if (!Locker)
{
if (CB_1.Text == "")
{
CB_2.DataSource = null;
CB_2.Text = "";
}
else
{
AccessDBC aa = new AccessDBC();
aa.Dic_in.Add(CB_1.Tag.ToString(), CB_1.Text);
CB_2.DataSource = aa.GetData(aa.Dic_in, "Capacitorsheet", CB_2.Tag.ToString());//data source accept list
}
}
}
private void Load_Load(object sender, EventArgs e)
{
AccessDBC a = new AccessDBC();
CB_Order.DataSource = a.GetData(null, "usersave", "order");
}