Populating the SQLDatasource SelectCommand

Question

How do I take this string and drop it into the select command?

    String SqlC = "select * from dbo.FindIt where " + SqlStr;

The object is to populate the SelectCommand:

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
     ConnectionString="<%$ ConnectionStrings:M3ConnectionString %>" 
     SelectCommand = SqlC >
</asp:SqlDataSource>

Does this answer your question? Creating a SelectCommand in code behind which works identically to creating one in the SQLDataSource — Jim G.
– Jim G., Commented Jan 20, 2023 at 20:34

Jim G. · Accepted Answer · 2023-01-23 19:17:50Z

0

protected void Page_Load(object sender, EventArgs e)
{
    var runx = Request.QueryString.GetValues("run") != null ? Request.QueryString.GetValues("run")[0] : "";
    if (runx != "") {
       var sqlStr = "RUN= '" + Runx + "'";
       var sqlC = "select * from dbo.FindIt where " + sqlStr;
       SqlDataSource1.SelectCommand = sqlC;
    }
    else {
       // TODO: Handle this situation.
    }
}

edited Jan 23, 2023 at 19:17

answered Jan 20, 2023 at 20:33

Jim G.

15.4k23 gold badges109 silver badges183 bronze badges

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

4 Comments

Juliemac Over a year ago

If I go to the Design tab and double click the form, it created a Page_Load script. but I get the error "the name SqlC does not exist in the current context."

Juliemac Over a year ago

Start of the page ``` <%@ Page Language="C#" %> <% String Runx = Request.QueryString.GetValues("run") != null ? Request.QueryString.GetValues("run")[0] : ""; if (Runx != "") { SqlStr = "RUN= '" + Runx + "'"; } String SqlC = "select * from dbo.FindIt where " + SqlStr; %> <!DOCTYPE html> <script runat="server"> protected void Page_Load(object sender, EventArgs e) { SqlDataSource1.SelectCommand = SqlC; } </script> ```

Jim G. Over a year ago

@Juliemac Please see my revision. Can you simply move all of that logic into the Page_Load method?

Juliemac Over a year ago

That was it. Perfect!

Collectives™ on Stack Overflow

Populating the SQLDatasource SelectCommand

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related