populate listview based on selected value from a dropdownlist using c#

Question

0.00/5 (No votes)

See more:

hey,im trying to populate my listview based on value selected in dropdownlist. actualy im not getting any errors, but listview is not displayed when user selects any dropdownlist value. DROPDOWNLIST1: i have a table say "cat" with columns-id,category and categoryid... i successfully populated its value from the database.
LISTVIEW1: based on category id i recieve from dropdownlist i need to update my listview
my code:

C#

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        DataTable table = new DataTable();
        //int id = Convert.ToInt32(DropDownList1.SelectedValue);
        // int id = int.Parse(DropDownList1.SelectedValue.ToString());
        string cat_id = DropDownList1.SelectedValue.ToString();
        int id;
        if (!(int.TryParse(cat_id.ToString(), out id)))
            return;
        using (SqlConnection con = new SqlConnection(constr))
        {
            string sql = "select id,name,description,category,image,price,categoryid from products WHERE categoryid=@cid ORDER BY categoryid";
            using (SqlCommand cmd = new SqlCommand(sql, con))
            {
                using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                {
                    cmd.Parameters.AddWithValue("@cid", cat_id);
                    da.Fill(table);
                }
            }

        }
        listview.DataSource = table;
        listview.DataBind();
    }
}

Posted 26-Aug-14 23:12pm

jin19

Updated 26-Aug-14 23:41pm

v3

Add a Solution

Comments

Gihan Liyanage 27-Aug-14 5:17am

Can you please debug and see where is the issue? Then you can post the code sample to get an answer. Or you can tell what you want clearly on here, then some times users will give you good links or advices. This type of large codes may not read by experts. This is only an advice for get quick answers for you . :)

jin19 27-Aug-14 5:45am

see i dont have any error,but when any value in dropdownlist is selected....im not getting any listview

Gihan Liyanage 27-Aug-14 5:51am

are you sure the Value of table Variable has filled out after select a specific dropdown list value ?

2 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)

ClimerChinna · Answer 1 · 2014-08-26T23:15:00

Solution 1

this link may be useful for you

http://stackoverflow.com/questions/14415189/get-value-of-listview-item-on-selectedindexchanged-on-dropdownlist-in-listview[^]

http://codeblog.shawson.co.uk/quick-ref/listview-using-a-dropdownlist-populated-using-code-behind/[^]

Posted 26-Aug-14 23:15pm

ClimerChinna

Updated 26-Aug-14 23:46pm

v2

Gihan Liyanage · Answer 2 · 2014-08-27T00:00:00

As I said earlier, if you get correct value to the datatable you have defined, then use this function to populate List view using the data table.

C#

private void LoadList()
{
// Clear the ListView control
            listView1.Items.Clear();
            int ColCount = dtable.Columns.Count;
            //Add columns
            for (int k = 0; k < ColCount; k++)
            {
               listView1.Columns.Add(dtable.Columns[k].ColumnName);
            }
            // Display items in the ListView control
            for (int i = 0; i < dtable.Rows.Count; i++)
            {
                DataRow drow = dtable.Rows[i];

                // Only row that have not been deleted
                if (drow.RowState != DataRowState.Deleted)
                {
                    // Define the list items
                    ListViewItem lvi = new ListViewItem(drow[0].ToString());
                    for (int j = 1; j < ColCount; j++)
                    {
                        lvi.SubItems.Add(drow[j].ToString());                        
                    }
                    // Add the list items to the ListView
                    listView1.Items.Add(lvi);
                }
            }
}