Click here to Skip to main content
15,904,416 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi All,
I have used a data source which has the following command
SQL
SelectCommand="SELECT  TaskID_Pk,
                            UserName,
                            Asignee,
                            StartDate,
                            Status,
                            Description
                     FROM   TaskList
                     Where  LOWER(Asignee) like LOWER(@Asignee)
                     AND    LOWER(Status)  like LOWER(@Status)
                     AND    LOWER (UserName) like LOWER(@UserName)
                     AND    StartDate >= @StartDate
                     AND    EndDate <= @EndDate";

XML
<SelectParameters>
    <asp:ControlParameter ControlID="drpDown_Asignee"
     Name="Asignee" PropertyName="SelectedValue" Type="String" />
    <asp:ControlParameter ControlID="drpDown_Status"
    Name="Status" PropertyName="SelectedValue" Type="String" />
    <asp:ControlParameter ControlID="drpDown_UserName"
    Name="UserName" PropertyName="SelectedValue" Type="String" />
    <asp:ControlParameter ControlID="StartDate_TextBox"
    Name="StartDate" PropertyName="Text" Type="DateTime" />
   <asp:ControlParameter ControlID="EndDate_TextBox"
    Name="EndDate" PropertyName="Text" Type="DateTime" />
</SelectParameters>


After building this file, I am getting warnings as If this attribute value is enclosed in quotation marks, the quotation marks must match

Note:
This error I am facing due to filtering the dates.

Can anyone give me a better idea to over come the warnings?
Posted
Updated 7-Sep-10 20:11pm
v3

1 solution

Couple of things I personally would check

1. check yout html / asp.net code above the area and check everything there is ok.

2. run the SQL Command directly on the database to see if the query runs ok and the values are as "expected"
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900