Ahmed Khalid

Ahmed Khalid

  • NA
  • 114
  • 5.4k

Display DataGrid Value based on a date variable

Nov 24 2022 5:05 AM

Hi,

I have a DataGrid in my webpage. I want to display grid data when the page is first loaded or when its updated. But i want to show only today's data. i have i hidden text field that contains today's date. Kindly see the code below. I need to change the hard coded date with a string variable and that is today's date. Thanks 

 

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:akkdbConnectionString %>" SelectCommand="SELECT [FullName], [TaskDate], [TaskType], [TaskStatus] FROM [TaskTransMaster_Tbl] where [TaskDate]= '11/24/2022' ORDER BY [PrayerDate] DESC"></asp:SqlDataSource>
                          
                          


Answers (3)