//----------------------------------------------------------------------------------------------------------------// //-----------------------------------------GET DATA TO COMBOBOX IN OPTION-----------------------------------------// //----------------------------------------------------------------------------------------------------------------// private void cmbModel_SelectedIndexChanged(object sender, EventArgs e) { grOption.Enabled = true; sql.getComboBoxData("select distinct site from processtbl where model ='" + cmbModel.Text + "' order by site asc", ref cmbSite); sql.getComboBoxData("select distinct factory from processtbl where model ='" + cmbModel.Text + "' order by factory asc", ref cmbFac); sql.getComboBoxData("select distinct line from processtbl where model ='" + cmbModel.Text + "' order by line asc", ref cmbLine); sql.getComboBoxData("select distinct process from processtbl where model ='" + cmbModel.Text + "' order by process asc", ref cmbProc); }
private void frmLogin_Load(object sender, EventArgs e) { sql = new TfSQL(); sql.getComboBoxData("select userid from usertbl", ref cmbUserID); cmbUserID.Focus(); }
private void frmXBar_Load(object sender, EventArgs e) { sql = new TfSQL(); sql.getComboBoxData("select distinct model from procinsplink order by model asc", ref cmbModel); }
private void frmMain_Load(object sender, EventArgs e) { //Get model name into combobox sql = new TfSQL(); sql.getComboBoxData("select distinct model from procinsplink order by model asc", ref cmbModel); }