<dx:ASPxComboBox ID="cmbYear" runat="server" ClientIDMode="AutoID" DataSourceID="yearDataSource" ValueType="System.String" ValueField="Years" TextField="Years" SelectedIndex="-1"> <Columns> <dx:ListBoxColumn Caption=" " FieldName="Years" /> </Columns> </dx:ASPxComboBox> <asp:SqlDataSource ID="yearDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:vsCustomizationRequestConnectionString %>" SelectCommand="SELECT DISTINCT YEAR(CreateDate) AS Years FROM CRF_Project ORDER BY Years DESC"> </asp:SqlDataSource>
cmbYear.Items.Insert(0, new ListEditItem("Latest"," ")); if (cmbYear.SelectedItem != null) { if (cmbYear.SelectedItem.Text == "Latest") { yearsStatus = DateTime.Now.ToString("yyyy"); } else { yearsStatus = cmbYear.SelectedItem.Text.TrimEnd(); } } else { yearsStatus = DateTime.Now.ToString("yyyy"); ; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)