Example doesn't seem to use 'Selected' variable.

[Alex Jermy]

Hi,

I am slightly confused by the Syncfusion example provided here:

http://www.syncfusion.com/downloads/support/forum/144217/ze/DDLSql-212970872

Where is the 'Selected' variable being used in a SQL query? It doesn't seem to be used in a query anywhere in the example you have provided?

To me it looks like you are assigning the value of the drop down list to a session variable but that variable is not being used anywhere in a SQL 'WHERE' clause?

Thanks,

Alex

[Prince Oliver]

Hello Alex,  

 

Thank you for contacting us. 

 

Based on your requirement in forum 144217 , we have provided sample to store the selected value from DropDownList in a session variable. Now , we have modified the sample by passing this session variable value through SQL query on button click. The second DropDownList in the page will be populated based on this SQL query. Similarly you can pass query with the session variable and repopulate the charts with user’s selection based on your requirement. Please find the modified code and sample below 

 

<ej:DropDownList runat="server" ID="TradesDropDown" DataTextField="CustomerID" DataValueField="ShipCity" AutoPostBack="true" DataSourceID="SqlData" Width="200px" EnableIncrementalSearch="False" FilterType="Contains" SelectedIndex="0" OnValueSelect="TradesDropDown_ValueSelect"> 

    </ej:DropDownList> 

    <asp:SqlDataSource ID="SqlData" runat="server" ConnectionString="<%$ ConnectionStrings:SQLConnectionString %>" SelectCommand="SELECT * FROM [Orders]"> 

        <SelectParameters> 

            <asp:Parameter Name="ShipCity" Type="String" DefaultValue="Reims" /> 

        </SelectParameters> 

    </asp:SqlDataSource> 

    <ej:Button runat="server" ID="btn" OnClick="btn_Click" Text="Send Query"></ej:Button> 

    <asp:Label runat="server" Text="Items matching the selected ShipCity value will be bound as dataSource of the below DropDownList when send query button is clicked"></asp:Label> 

    <ej:DropDownList runat="server" ID="DropDownList1" DataTextField="CustomerID" DataValueField="ShipCity"> 

    </ej:DropDownList> 

 

Aspx.cs: 

 

protected void TradesDropDown_ValueSelect(object sender, Syncfusion.JavaScript.Web.DropdownListEventArgs e) 

        { 

            Session["ShipCity"] = e.Value; 

        } 

 

        protected void btn_Click(object Sender, Syncfusion.JavaScript.Web.ButtonEventArgs e) 

        { 

            string selected  = Session["ShipCity"].ToString(); 

            dt = new DataTable("Order"); 

            cmd.Connection = myConnection; 

            cmd.CommandText = "select [CustomerID] from [Orders] where [ShipCity]='" + selected + "'"; 

            cmd.CommandType = CommandType.Text; 

            SqlDataAdapter da = new SqlDataAdapter(); 

            da.SelectCommand = cmd; 

            if ((myConnection.State == ConnectionState.Closed)) 

            { 

                myConnection.Open(); 

            } 

            da.Fill(dt); 

            Session["NewDataSource"] = dt; 

            DropDownList1.DataSource = Session["NewDataSource"];  

        } 

 

Sample link: http://www.syncfusion.com/downloads/support/forum/144290/ze/SQLQuery_with_session_variable-838719682  

 

Let us know if you need any further assistance on this. 

 

Regards, 

Prince