quote:

---

Let's now tie in the Calendar control to filter the activities based on the dates. To achieve this, go the FilterParameters collection property in the Property window and click the "..." button. When the Parameter Collection Editor pops up, click the Add Parameter button. Rename the parameter to dtDateOfActivity, set the parameter source to Control, from the ControlID drop down menu select calActivity, and leave the default value blank. Click the OK button to close the editor. Next, in the FilterExpression field, enter dtDateOfActivity='@dtDateOfActivity'. Configure the odsActivitiesUnpublished data source in the exact same manner, except set the bIsPublished parameter's default value to False.

---

<asp:SqlDataSource ID="SqlDataSource1" Runat="server"
            ConnectionString="<%$ ConnectionStrings:testandoConnectionString %>"
            SelectCommand="SELECT * FROM [tblActivity]" FilterExpression="dtDateOfActivity='@dtDateOfActivity'" OnSelecting="SqlDataSource1_Selecting" EnableCaching="True">
            <FilterParameters>
                <asp:ControlParameter Name="dtdateOfActivity" ControlID="Calendar1" PropertyName="SelectedDate" Type="DateTime" DefaultValue=""></asp:ControlParameter>
            </FilterParameters>
        </asp:SqlDataSource>

quote:

---

Cannot perform '=' operation on System.DateTime and System.String.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.EvaluateException: Cannot perform '=' operation on System.DateTime and System.String.

---

 FilterExpression="dtDateOfActivity=#{0}#"