Hi everyone,
I have a drop down which gets data from database.
I want to show not all entries but the very last one ented by employee. Can you tell me what do i have to add to the sql script to get me very last entry and hide the rest. Thank you
this is my Sql data source:
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:CompanyInfoEventsConnectionString %>"
SelectCommand="SELECT [ID], [NameOne] FROM [Gpi_DayOff] ORDER BY [ID] DESC">
</asp:SqlDataSource>