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