private void ClearControls() { strSQL = "SELECT BRANCH_ID," + " BRANCH_NAME " + "FROM MST_SETUP " + "ORDER BY BRANCH_NAME "; dmlService.J_PopulateComboBox(strSQL, ref cmbBranch, J_ComboBoxDefaultText.NO); // 1. Table Name // 2. Column Name // 3. Column Data Type // 4. No. of space string[,] strArray = { { "MST_FAYEAR", "FA_BEG_DATE", "D", "3" }, { "MST_FAYEAR", "FA_END_DATE", "D", "3" } }; strSQL = "SELECT FAYEAR_ID," + " " + dmlService.J_ConcateColumns(strArray) + " AS FA_DATE " + "FROM MST_FAYEAR " + "WHERE INACTIVE_FLAG = 0 " + "ORDER BY FA_BEG_DATE DESC"; dmlService.J_PopulateComboBox(strSQL, ref cmbFAYear, J_ComboBoxDefaultText.NO); txtPassword.Text = ""; }