Hi sbatcha,

Refer the below link. What you have to do is store the datetime in hiddenfield. Then pass the hiddenfield value to sqldatasource as control parameter as in the below article.

Pass encrypt querystring value to sqlDataSource SelectCommand in ASP.Net

Or you can pass from code behind like below also.

sqlDataSourceGridView.SelectCommand = "SELECT [dno],[ddate],[ino],[ldate],[whremark] FROM [Transport] where ldate= '" + DateTime.Now.ToString() + "'";

 Or you can use GETDATE() function same as DateTime.Now.ToString() like below.

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    SelectCommand="SELECT [dno],[ddate],[ino],[ldate],[whremark] FROM [Transport] where ldate = CONVERT(VARCHAR(10), GETDATE(), 101)" 
    ConnectionString="<%$ ConnectionStrings:constr %>">
</asp:SqlDataSource>