private void cmbCompanyName_SelectedIndexChanged(object sender, EventArgs e) { var t = new Task(() => { }); t.Start(); t.ContinueWith(task => { Connector databaseConnectCategory = new MYSQLDatabaseConnection(); companyId = databaseConnectCategory.SearchCompanyList(tempCompanyList, cmbCompanyName.SelectedItem.ToString()); if (databaseConnectCategory.establish() == true) { databaseConnectCategory.SetData(companyId); List <DatabaseColumn> CategoryList = databaseConnectCategory.GetCategoryNameForEachCompany(); foreach (DatabaseColumn databseColumn in CategoryList) { cmbCategoryName.Items.Add(databseColumn.category_name);//add category name into combo box tempCategoryList.Add(new DatabaseColumn() { category_name = databseColumn.category_name, category_id = databseColumn.category_id, } ); } } else { MessageBox.Show("connection error"); } }, System.Threading.CancellationToken.None, TaskContinuationOptions.None, TaskScheduler.FromCurrentSynchronizationContext()); }
private void SetCategoryListIntoCategoryComboBox() { var t = new Task(() => { }); t.Start(); t.ContinueWith(task => { Connector databaseConnectCategory = new MYSQLDatabaseConnection(); if (databaseConnectCategory.establish() == true) { DatabaseColumn databaseColumn = new DatabaseColumn(); databaseColumn.company_id = databaseConnectCategory.SearchCompanyList(TempCompanyList, cmbSearchCompanyName.SelectedItem.ToString()).company_id; databaseConnectCategory.SetData(databaseColumn); List <DatabaseColumn> CategoryList = databaseConnectCategory.GetCategoryNameForEachCompany(); cmbSearchCategoryName.Items.Clear(); cmbSearchCategoryName.Text = ""; foreach (DatabaseColumn databseColumn in CategoryList) { cmbSearchCategoryName.Items.Add(databseColumn.category_name);//add category name into combo box } } else { MessageBox.Show("connection error"); } }, System.Threading.CancellationToken.None, TaskContinuationOptions.None, TaskScheduler.FromCurrentSynchronizationContext()); }