Conversion failed when converting date and or time from character string in ASP.Net

Hi

I need to get table values from this table "Transport" based on the loading date(ldate), here ldate is today date by default

but i got date conversion error

any one give me the solution.

 My Code:

<asp:SqlDataSource ID="sqlDataSourceGridView" runat="server" ConnectionString="<%$ ConnectionStrings:test %>" SelectCommand="SELECT [dno],[ddate],[ino],[ldate],[whremark] FROM [Transport] where ldate='<% DateTime.Now.ToString() %>'">

</asp:SqlDataSource>

Sathik