select parameter in sql data source

Question

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:GSProjectConnectionString %>" SelectCommand="SELECT * FROM [Table] where Owner like '%@username%' ">
             <SelectParameters>
                 <asp:Parameter Name="username" Type="String"/>
             </SelectParameters>
        </asp:SqlDataSource>

The above is my code wherein i am trying to use a variable username which is defined in .cs file.

It does not take the value of username.

Where am I going wrong ?

Any idea anyone ?

try change the SelectCommand to SelectCommand="SELECT * FROM [Table] where Owner like @username"> — uowzd01
– uowzd01, Commented Mar 31, 2015 at 5:35

Damith · Accepted Answer · 2015-03-31 05:37:06Z

1

change it as

 SelectCommand="SELECT * FROM [Table] where Owner like @username

when you set parameter value you can add the '%%' as below

SqlDataSource1.SelectParameters["username"].DefaultValue = string.Format("%{0}%", paramvalue);

answered Mar 31, 2015 at 5:37

Damith

63.2k13 gold badges105 silver badges154 bronze badges

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

2 Comments

Damith Over a year ago

there is a difference between @username and '@username', 2nd one is no longer a parameter, it consider as string value.

TRY123 Over a year ago

I initially tried data binding actually,something like <%#username%> but that did not work either.

Collectives™ on Stack Overflow

select parameter in sql data source

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related