Like operator in SQL Query in SQL Datasource

Question

I have to use like operator for SQL Command in SQL Datasource, but it is not working. Did some one run into the issue? Please Advise.

<asp:SqlDataSource ID="gridSource" runat="server" ConnectionString="<%$ ConnectionStrings:connectionString %>"
     SelectCommand=" select * from [test where domain like '%@DomainID%'">
    <SelectParameters>
        <asp:ControlParameter Name="DomainID" PropertyName="SelectedValue" ControlID="ddlcu"></asp:ControlParameter>
    </SelectParameters>
</asp:SqlDataSource>

What exactly is not working?

Renats Stozkovs
– Renats Stozkovs

2017-02-23 21:24:32 +00:00
Commented Feb 23, 2017 at 21:24 — Renats Stozkovs
– Renats Stozkovs, Commented Feb 23, 2017 at 21:24

Renats Stozkovs · Accepted Answer · 2017-02-23 21:28:36Z

4

Do this:

WHERE Name LIKE '%' + @nameparam + '%'";

answered Feb 23, 2017 at 21:28

Renats Stozkovs

2,63510 gold badges24 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user1046415 · Accepted Answer · 2017-02-23 21:28:30Z

1

      where  Domain LIKE '%' + @DomainID + '%'" >

we need send this way in order to get the like operator work.Thanks

answered Feb 23, 2017 at 21:28

user1046415

7894 gold badges25 silver badges44 bronze badges

Collectives™ on Stack Overflow

Like operator in SQL Query in SQL Datasource

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related