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