how to make distinct dropdown list in ASP.Net

tyt2314 says:

sqlStr.AppendLine("SELECT LoanTerm, LoanRate From TDLoanRate ");

     sqlStr.AppendLine("where GETDATE() between LoanEffectFrom and LoanMaturity");

Replace the above with the below code.

sqlStr.AppendLine("SELECT DISTINCT LoanTerm, LoanRate From TDLoanRate ");
sqlStr.AppendLine("where GETDATE() between LoanEffectFrom and LoanMaturitty");