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>