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 = "";
}