protected void btnGetCredentials_Click(object sender, EventArgs e) { ShowMessage("", true); if (ddlVendor.SelectedIndex == 0) { ShowMessage("PLEASE SELECT A VENDOR:", true); //ClearControls(); } else if (ddlUtility.SelectedIndex == 0) { ShowMessage("PLEASE SELECT A UTILITY:", true); } else { string vendorCode = ddlVendor.SelectedValue; string utilityCode = ddlUtility.SelectedValue; DataTable dt = datafile.GetUtilityCredentials(vendorCode, utilityCode); if (dt.Rows.Count > 0) { string username = dt.Rows[0]["UtilityUsername"].ToString(); string password = dt.Rows[0]["UtilityPassword"].ToString(); string bankCode = dt.Rows[0]["BankCode"].ToString(); txtUsername.Text = username; txtPassword.Text = password; txtBankCode.Text = bankCode; } else { ShowMessage("VENDOR:" + ddlVendor.SelectedItem.Text + " HAS NO CREDENTIALS FOR " + ddlUtility.SelectedItem.Text, true); ClearControls(); } } }