Need to modify the SelectCommand parameter for SqlDataSource from C#

Question

I have a SqlDataSource that I am trying to modify in C# ASP.NET from my code behind page. The code in the page is:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
      ConnectionString="<%$ ConnectionStrings:TEST_SERVER %>" 
      ProviderName="<%$ ConnectionStrings:TEST_SERVER.ProviderName %>" 
</asp:SqlDataSource>

I want to dynamically modify the SelectCommand parameter for SqlDataSource1 but in the codebehind page it does not seem to be available.

Am I just doing it wrong?

Does it show data? If yes then the DataSet and Adapter are configured elsewhere. Be glad. — Henk Holterman
– Henk Holterman, Commented Mar 14, 2012 at 19:18

Khan · Accepted Answer · 2012-03-14 19:28:12Z

1

The select command will be there as soon as you add your ending '>' to your open tag.

Try this:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
      ConnectionString="<%$ ConnectionStrings:TEST_SERVER %>" 
      ProviderName="<%$ ConnectionStrings:TEST_SERVER.ProviderName %>">
</asp:SqlDataSource>

Darn typos ;)

answered Mar 14, 2012 at 19:28

Khan

18.2k5 gold badges52 silver badges60 bronze badges

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

1 Comment

Geekender Over a year ago

Yup. That was the only issue.

Icarus · Accepted Answer · 2012-03-14 19:26:44Z

0

Yes, it is available, just do:

 SqlDataSource1.SelectCommand="Select a , b, c from table_c";

The SelectCommand property is as string. Read the documentation here.

If you want to modify the select CommandType, use the SelectCommandType as so (stored proc):

SqlDataSource1.SelectCommandType=SqlDataSourceCommandType.StoredProcedure;

answered Mar 14, 2012 at 19:26

Icarus

64.1k14 gold badges102 silver badges116 bronze badges

Collectives™ on Stack Overflow

Need to modify the SelectCommand parameter for SqlDataSource from C#

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related