how to make distinct dropdown list in ASP.Net

Question

using SqlDataAdapter sda  new SqlDataAdaptercmdConnection  conconOpenddlDataSource  cmdExecuteReaderddlDataTextField  textddlDataValueField  valueddlDataBindconClose

dharmendr · Accepted Answer

tyt2314 sayssqlStrAppendLineSELECT LoanTerm LoanRate From TDLoanRate      sqlStrAppendLinewhere GETDATE between LoanEffectFrom and LoanMaturityReplace the above with the below codesqlStrAppendLine34SELECT DISTINCT LoanTerm LoanRate From TDLoanRate 34sqlStrAppendLine34where GETDATE between LoanEffectFrom and LoanMaturitty34

how to make distinct dropdown list in ASP.Net

Company

Explore

Follow us

Contact Us