Data Source Configuration Wizard

Question

User-389313458 posted

I'm am not sure if I used the DSCW correctly to construct my SQL statement.

I wanted to write SELECT InvoiceNumber FROM Invoices WHERE Total > 300.

Here is my code for my Data Source Control.

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"
            SelectCommand="SELECT InvoiceNumber FROM Invoices WHERE (Total &gt; ?)">
            <SelectParameters>
                <asp:Parameter DefaultValue="300" Name="Total" Type="Decimal" />
            </SelectParameters>
        </asp:SqlDataSource>

Answer 1

User-1716253493 posted

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
            SelectCommand="SELECT InvoiceNumber FROM Invoices WHERE (Total > @Total)"> 
            <SelectParameters> 
                <asp:Parameter DefaultValue="300" Name="Total" Type="Decimal" /> 
            </SelectParameters> 
        </asp:SqlDataSource>

Answer 2

User-389313458 posted

Can you explain how to do this in the Data Configuration Wizard.  When I'm in the Add WHERE clause dialog box, I do these steps:

1.) Column: Total

2.) Operator: >

3.) Source: None

4.) Value: 300

SQL Expression: 

[Total] > ?

Why do I get a question mark?  How do I get @Total to appear?

Answer 3

User-1716253493 posted

I try using wizard, > is encoded character, that worked.

WHERE ([testfield] > @testfield)

http://msdn.microsoft.com/en-us/library/ms525347(v=vs.90).aspx

 

Answer 4

User-389313458 posted

Did you follow the same steps that I listed above?  Why would I get a question mark and you got @Total if we followed the same steps?

Answer 5

User3866881 posted

Hi,

Your screenshot, please.