private void BankMaster_Load(object sender, EventArgs e) { try { //txtBankName.AutoCompleteSource = AutoCompleteSource.CustomSource; //txtBankName.AutoCompleteMode = AutoCompleteMode.SuggestAppend; //AutoCompleteStringCollection daColl = new AutoCompleteStringCollection(); objDB = new SQLDB(); DataTable dtBankMas = objDB.ExecuteDataSet("SELECT DISTINCT BIM_BANK_NAME FROM BANK_IFSC_MICR_MAS ORDER BY BIM_BANK_NAME").Tables[0]; DataTable dtStateMas = objDB.ExecuteDataSet("SELECT DISTINCT BIM_STATE FROM BANK_IFSC_MICR_MAS ORDER BY BIM_STATE").Tables[0]; DataTable dtIFSC = objDB.ExecuteDataSet("SELECT DISTINCT BIM_BANK_IFSC_CODE FROM BANK_IFSC_MICR_MAS").Tables[0]; //string[] postSource = dt // .AsEnumerable() // .Select<System.Data.DataRow, String>(x => x.Field<String>("BIM_BANK_NAME")) // .ToArray(); //var source = new AutoCompleteStringCollection(); //source.AddRange(postSource); //txtBankName.AutoCompleteCustomSource = source; //txtBankName.AutoCompleteMode = AutoCompleteMode.SuggestAppend; //txtBankName.AutoCompleteSource = AutoCompleteSource.CustomSource; UtilityLibrary.AutoCompleteTextBox(txtBankName, dtBankMas, "", "BIM_BANK_NAME"); UtilityLibrary.AutoCompleteTextBox(txtState, dtStateMas, "", "BIM_STATE"); UtilityLibrary.AutoCompleteTextBox(txtIFSC, dtIFSC, "", "BIM_BANK_IFSC_CODE"); } catch { } finally { objDB = null; } dtpTo.Value = DateTime.Now; }
private void FillMajorCostNames() { string strCommand = ""; try { objSqlDB = new SQLDB(); strCommand = "SELECT MCC_MAJOR_COST_CENTRE_ID,MCC_MAJOR_COST_CENTRE_NAME FROM FA_MAJOR_COST_CENTRE where mcc_company_code='" + CommonData.CompanyCode + "'"; DataTable dtCCNameDetails = objSqlDB.ExecuteDataSet(strCommand).Tables[0]; UtilityLibrary.AutoCompleteTextBox(txtMajorCostCenterName, dtCCNameDetails, "", "MCC_MAJOR_COST_CENTRE_NAME"); objSqlDB = null; strCommand = ""; objSqlDB = new SQLDB(); strCommand = "SELECT MCC_MAJOR_COST_CENTRE_ID,MCC_SHORT_NAME FROM FA_MAJOR_COST_CENTRE where mcc_company_code='" + CommonData.CompanyCode + "'"; DataTable dtCCSNameDetails = objSqlDB.ExecuteDataSet(strCommand).Tables[0]; UtilityLibrary.AutoCompleteTextBox(txtMajorCostCenterSName, dtCCSNameDetails, "", "MCC_SHORT_NAME"); objSqlDB = null; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { objSqlDB = null; } }
private void FillAutoCompleteBox() { objDB = new SQLDB(); DataTable dtAccMas = new DataTable(); dtAccMas = objDB.ExecuteDataSet(" SELECT AM_ACCOUNT_ID,AM_ACCOUNT_NAME AccName FROM FA_ACCOUNT_MASTER WHERE AM_COMPANY_CODE='" + CommonData.CompanyCode + "' AND AM_ACCOUNT_GROUP_ID IS NULL ").Tables[0]; UtilityLibrary.AutoCompleteTextBox(txtAccountSearch, dtAccMas, "AM_ACCOUNT_ID", "AM_ACCOUNT_ID"); DataTable dtAccName = new DataTable(); dtAccName = objDB.ExecuteDataSet(" SELECT AM_ACCOUNT_ID,AM_ACCOUNT_NAME AccName FROM FA_ACCOUNT_MASTER WHERE AM_COMPANY_CODE='" + CommonData.CompanyCode + "' AND AM_ACCOUNT_GROUP_ID IS NULL ").Tables[0]; UtilityLibrary.AutoCompleteTextBox(txtName, dtAccName, "", "AccName"); }
private void txtBankName_Validated(object sender, EventArgs e) { try { objDB = new SQLDB(); DataTable dtBranchMas = objDB.ExecuteDataSet("SELECT DISTINCT BIM_BRANCH_NAME FROM BANK_IFSC_MICR_MAS " + "WHERE BIM_BANK_NAME = '" + txtBankName.Text + "' ORDER BY BIM_BRANCH_NAME").Tables[0]; UtilityLibrary.AutoCompleteTextBox(txtBankBranch, dtBranchMas, "", "BIM_BRANCH_NAME"); objDB = null; } catch { } finally { objDB = null; } }
private void frmEmpAwardsEntry_Load(object sender, EventArgs e) { txtEventName.Visible = false; chkAddEvent.Checked = false; btnAdd.Visible = false; dtpAwardDate.Value = DateTime.Today; FillFinYear(); FillCompanyData(); cbFinYear.SelectedValue = CommonData.FinancialYear; FillEventDetails(); try { objSQLdb = new SQLDB(); DataTable dt = objSQLdb.ExecuteDataSet("SELECT DISTINCT HEA_AWARD_TYPE " + " FROM HR_APPL_EMP_AWARDS_REWARDS " + " ORDER BY HEA_AWARD_TYPE asc").Tables[0]; UtilityLibrary.AutoCompleteTextBox(txtAwardType, dt, "", "HEA_AWARD_TYPE"); objSQLdb = null; } catch { } finally { objSQLdb = null; } try { objSQLdb = new SQLDB(); DataTable dt = objSQLdb.ExecuteDataSet("SELECT DISTINCT HEA_AWARD_NAME " + " FROM HR_APPL_EMP_AWARDS_REWARDS " + " ORDER BY HEA_AWARD_NAME asc").Tables[0]; UtilityLibrary.AutoCompleteTextBox(txtAwardName, dt, "", "HEA_AWARD_NAME"); objSQLdb = null; } catch { } finally { objSQLdb = null; } }
private void FillStationaryItemDetailsToGrid(string CatageoriId, string CompCode, string State, string BranchCode) { gvIndentDetails.Rows.Clear(); objSQLDB = new SQLDB(); DataTable dtItems = null; try { dtItems = Get_Stationary_Item_Details(CatageoriId, CompCode, State, BranchCode); if (dtItems.Rows.Count > 0) { UtilityLibrary.AutoCompleteTextBox(txtItemDesc, dtItems, "", "st_item_name"); for (int i = 0; i < dtItems.Rows.Count; i++) { DataGridViewRow tempRow = new DataGridViewRow(); DataGridViewCell cellSLNO = new DataGridViewTextBoxCell(); cellSLNO.Value = (i + 1).ToString(); tempRow.Cells.Add(cellSLNO); DataGridViewCell cellItemCompany = new DataGridViewTextBoxCell(); cellItemCompany.Value = dtItems.Rows[i]["st_company_code"].ToString(); tempRow.Cells.Add(cellItemCompany); DataGridViewCell cellItemState = new DataGridViewTextBoxCell(); cellItemState.Value = dtItems.Rows[i]["st_state_code"].ToString(); tempRow.Cells.Add(cellItemState); DataGridViewCell cellItemBranchCode = new DataGridViewTextBoxCell(); cellItemBranchCode.Value = dtItems.Rows[i]["st_branch_code"].ToString(); tempRow.Cells.Add(cellItemBranchCode); DataGridViewCell cellItemID = new DataGridViewTextBoxCell(); cellItemID.Value = dtItems.Rows[i]["st_item_code"].ToString(); tempRow.Cells.Add(cellItemID); DataGridViewCell cellItemCategory = new DataGridViewTextBoxCell(); cellItemCategory.Value = dtItems.Rows[i]["st_category"].ToString(); tempRow.Cells.Add(cellItemCategory); DataGridViewCell cellItemCompanyName = new DataGridViewTextBoxCell(); cellItemCompanyName.Value = dtItems.Rows[i]["st_company_name"].ToString(); tempRow.Cells.Add(cellItemCompanyName); DataGridViewCell cellItemStateName = new DataGridViewTextBoxCell(); cellItemStateName.Value = dtItems.Rows[i]["st_state_name"].ToString(); tempRow.Cells.Add(cellItemStateName); DataGridViewCell cellItemBranchName = new DataGridViewTextBoxCell(); cellItemBranchName.Value = dtItems.Rows[i]["st_branch_name"].ToString(); tempRow.Cells.Add(cellItemBranchName); DataGridViewCell cellItemName = new DataGridViewTextBoxCell(); cellItemName.Value = dtItems.Rows[i]["st_item_name"].ToString(); tempRow.Cells.Add(cellItemName); //DataGridViewCell cellItemCategoryName = new DataGridViewTextBoxCell(); //cellItemCategoryName.Value = dtItems.Rows[i]["st_categoryName"].ToString(); //tempRow.Cells.Add(cellItemCategoryName); DataGridViewCell cellItemPrice = new DataGridViewTextBoxCell(); cellItemPrice.Value = Convert.ToDouble(dtItems.Rows[i]["st_item_price"].ToString()).ToString("f"); tempRow.Cells.Add(cellItemPrice); DataGridViewCell cellItemStatus = new DataGridViewTextBoxCell(); if (dtItems.Rows[i]["st_active"].ToString() == "T") { cellItemStatus.Value = "ACTIVE"; } else { cellItemStatus.Value = "DEACTIVE"; } //cellItemStatus.Value = dtItems.Rows[i]["SIM_ACTIVE"].ToString(); tempRow.Cells.Add(cellItemStatus); gvIndentDetails.Rows.Add(tempRow); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { dtItems = null; objSQLDB = null; } }