how to display records to 2 listview in c# from sql database?

Question

I would like to display the record from database to c# in listview. When I display the record into 2 different listview, the record in the second listview does not appear.

In listview1, i would like to display the record where package = textbox4.text, then in listview2, i would like to display the record where package = textbox5.text.

Here is my line of code, only the records in first listview display.

Please help me. Thank you

//code for first listview
MySqlConnection.Open();
SqlCommand command1 = new SqlCommand("Select * from reservation_inventory where package='"+textBox4.Text+"'", MySqlConnection);

p_table.Clear();
SqlDataAdapter m_da = new SqlDataAdapter("Select * from reservation_inventory where package='" + textBox4.Text + "'", MySqlConnection);

m_da.Fill(p_table);
listView1.Items.Clear();

for (int i = 0; i < p_table.Rows.Count; i++)
{
    DataRow drow = p_table.Rows[i];

    if (drow.RowState != DataRowState.Deleted)
    {
        ListViewItem lvi = new ListViewItem(drow["id"].ToString());
        lvi.SubItems.Add(drow["equipment"].ToString());
        lvi.SubItems.Add(drow["status"].ToString());
        listView1.Items.Add(lvi);
    }
}

// code for second listview
SqlCommand command2 = new SqlCommand("Select * from reservation_inventory where package='" + textBox5.Text + "'", MySqlConnection);

p_table.Clear();
SqlDataAdapter m_da2 = new SqlDataAdapter("Select * from reservation_inventory where package='" + textBox5.Text + "'", MySqlConnection);

m_da.Fill(p_table);
listView2.Items.Clear();

for (int i = 0; i < p_table.Rows.Count; i++)
{
    DataRow drow = p_table.Rows[i];

    if (drow.RowState != DataRowState.Deleted)
    {
        ListViewItem lvi = new ListViewItem(drow["id"].ToString());
        lvi.SubItems.Add(drow["equipment"].ToString());
        lvi.SubItems.Add(drow["status"].ToString());
        listView1.Items.Add(lvi);
    }
}

why loop the objects making list view items... just go listView2.DataSource = p_table; listView2.DataBind(); — Adween
– Adween, Commented Mar 10, 2014 at 13:13

Adween · Accepted Answer · 2014-03-10 13:16:13Z

2

In your second loop change

listView1.Items.Add(lvi);

to

listView2.Items.Add(lvi);

answered Mar 10, 2014 at 13:16

Adween

2,8202 gold badges20 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

how to display records to 2 listview in c# from sql database?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related