How to display data from a sql query in a listview?

[sentimental37]

hi i m using the following code

            SqlCommand cm2 = new SqlCommand("Select * from cand_details where cand_id='"+candid+"'",con);
            dr = cm2.ExecuteReader();
 
 

this return the following :
Max Payne
timmy smoth
abc aha
and so on.............

I want to display this data in a list view i have on the form named listView1. How could i do this?

[Subin Ninan]

Hi,
to add items to a list view (details view) :

while(dr.read())
{
listview1.Items.Add(dr[0].ToString());
 
// if your result have more that one column, use
 
listview1.Items.Add(dr[0].ToString()).SubItems.Add(dr[1].ToString());
}