writing an sql statement inside an asp control

Question

How should i write an sql statement in an SqlDataSource control?

<% String inuser="john";%>
<asp:SqlDataSource ID="SqlDataSource1" 
                   runat="server" 
                   ConnectionString="..." 
                   SelectCommand="select from users where user='<%#inuser%>'??????????????" DeleteCommand="..." InsertCommand="..." 
                   UpdateCommand="...">
</asp:SqlDataSource>

Jacob · Accepted Answer · 2011-01-12 19:40:44Z

6

You'd be better served setting the value in the code-behind's load event handler:

var inuser = "john";
SqlDataSource1.SelectCommand = "select from users where user = @user";
SqlDataSource1.SelectParameters.Add("@user", inuser);

You can also do it through the markup:

<asp:SqlDataSource ID="SqlDataSource1" 
                   runat="server" 
                   ConnectionString="..." 
                   SelectCommand="select from users where user=@user">
    <selectparameters>
        <asp:Parameter name="user" DefaultValue="john"/>
    </selectparameters>
</asp:SqlDataSource>

edited Jan 12, 2011 at 19:40

answered Jan 12, 2011 at 19:29

Jacob

79k24 gold badges159 silver badges245 bronze badges

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

Collectives™ on Stack Overflow

writing an sql statement inside an asp control

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related