Data not being populated in dropdown using sqlDataSource

Question

I need to populate the data from database in Dropdown using sqlDataSource. The SqlDataSource is using a querystring. The data is not being populated in dropdown. Can you please suggest what I am doing wrong here?

Code for Dropdown:

<ajaxToolkit:ComboBox ID="SelectDropDown1" runat="server" DropDownStyle="DropDownList"
                    AutoCompleteMode="SuggestAppend" AppendDataBoundItems="true" Width="200px" Height="16pt"
                    Font-Size="8pt"  DataSourceID="SqlDataSource1" DataTextField="Rubric"
                 DataValueField="Rubric">

               <asp:ListItem Value="all">All</asp:ListItem>

                </ajaxToolkit:ComboBox>

Code for SqlDataSource:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Education_Data %>"

        SelectCommand="SELECT DISTINCT [Rubric] FROM [table1] WHERE ([Program] = @Program)">

        <SelectParameters>
            <asp:QueryStringParameter Name="Program" QueryStringField="Program" 
                Type="String" />
        </SelectParameters>

    </asp:SqlDataSource>

SELECT DISTINCT [Rubric] FROM [table1] WHERE ([Program] = YourRequestQueryString Run this query to your SQL and see if its returning some values. Also try adding SelectCommandType in your SQLDataSource tag — rach
– rach, Commented Jun 6, 2013 at 20:26
where program='YourRequestQuerystring'. I believe program's datatype is varchar — rach
– rach, Commented Jun 6, 2013 at 20:37
How are you setting the QueryStringParameter? You need to bind it to something or set it somehow using ControlId and PropertyName — rivarolle
– rivarolle, Commented Jun 6, 2013 at 20:54

rivarolle · Accepted Answer · 2013-06-06 21:28:32Z

0

The @program needs to be set somehow.

This MSDN article will show you how to do it. Go to section "Passing Parameters to SQL Statements"

answered Jun 6, 2013 at 21:28

rivarolle

1,53811 silver badges18 bronze badges

Add a comment |

Collectives™ on Stack Overflow

Data not being populated in dropdown using sqlDataSource

1 Answer 1

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related