how to get records in listview on dropdown selection

Question

1.00/5 (1 vote)

See more:

please any one let me know how can i get records in listview on dropdown selection where both the dropdownlist is databound to sqldatasource. and on selection of dropdown i need to display the list of records in listview so that i can bind this records with gridview

Posted 7-Nov-11 21:39pm

priti2010

Updated 24-May-19 0:26am

Add a Solution

Comments

[no name] 24-May-19 7:07am

https://forums.asp.net/t/1357900.aspx?SelectedIndexChanged+of+a+DropDownList+which+is+inside+a+ListView

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tejas Vaishnav · Answer 1 · 2011-11-07T22:01:00

Fro displaying Record on the basis of dropdown selected index you need to do like this....

1) Attach a selected index change event to your drop down...

2) write a method or function fro selecting records from database with a where cause to filter resulted data... select query like this....

SQL

SELECT * FROM PRODUCT WHERE PRODUCT_ID = @PRODUCTID

3) then call that function inside you dropdown selected index change event and pass a value which you want to pass for select query parameter... here i use a productID as a dropdown data value filed and product name as drop down data text filed... so my code like this...

C#

protected void ddl_SelectedIndexChanged(object sender, EventArgs e)
{
    int productid = Convert.ToInt32(ddlReportSelection.SelectedValue.ToString());
    loadDataToListBox(productid);
}       
private void loadDataToListBox(int productid)
{
    string query = "SELECT * FROM PRODUCT WHERE PRODUCTID = @PRODUCTID";
    ///code for fill data table or data set goes here....
    ///
    lstview.DataSource = ds;
    lstview.DataBind();
}

i hope it will solve your problem....

P.Salini · Answer 2 · 2011-11-07T22:05:00

Solution 2

Check this

http://forums.asp.net/t/1306363.aspx/1/10[^]

Posted 7-Nov-11 22:05pm

P.Salini

priti2010 · Answer 3 · 2011-11-07T23:04:00

XML

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:sqlConstr %>" SelectCommand="SELECT * FROM [Servers]"></asp:SqlDataSource>
   <asp:DropDownList ID="ddlServer" runat="server" CssClass="dropdownlistLarge" Font-Size="10"
            AutoPostBack="true" OnSelectedIndexChanged="ddlServer_SelectedIndexChanged" DataTextField="Server_Name"
             DataValueField="Server_ID" DataSourceID="SqlDataSource1">
                      </asp:DropDownList>

XML

<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:sqlConstr %>" SelectCommand="SELECT * FROM [Services]"></asp:SqlDataSource>
   <asp:DropDownList ID="ddlService" runat="server" CssClass="dropdownlistLarge" OnSelectedIndexChanged="ddlService_SelectedIndexChanged" AutoPostBack="true" Font-Size="10"
    DataSourceID="SqlDataSource2" DataTextField="Service_Name"
           DataValueField="Service_ID"></asp:DropDownList>

These are my two dropdownlist where in if i select ddlServer i should get list of Services applicable in a format like

XML

<asp:SqlDataSource ID="SqlDataSource3" runat="server"
          ConnectionString="<%$ ConnectionStrings:sqlConstr %>"
          SelectCommand="SELECT Service_ID,Service_Name from Services where Applicable_Servers like '%1,%' ">
      </asp:SqlDataSource>

and if second dropdownlist ddlService then i should get list of applicable servers
so how can i write select index code for this and this listview values to bind to my main table

how to get records in listview on dropdown selection

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0