C# listview header name=value from database

Vuk Stanojevic

Hi Everyone,

I'm trying to create listview where column header name is retrieved from database (its number)

When i execute my code i get as column name System.Data.DataRow but it should be number from database.

My code is:

SqlConnection con = new SqlConnection(@"Data Source=MAIN-PC\SQLEXPRESS;Integrated Security=True");
SqlCommand cmd = new SqlCommand("USE "+comboBox1.Text+" ; Select StoreCode FROM stores",con);
DataTable dt = new DataTable();
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
ListView view = new ListView();
view.View = View.Details;
listView1.Columns.Add("Store", 90, HorizontalAlignment.Left);
foreach(DataRow row in dt.Rows)
{
listView1.Columns.Add(row.ToString(), 90, HorizontalAlignment.Left);
}

Result is:

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar6y ago
Accepted answer
row[You should Pass index here].ToString(). This works in your case : row[0].ToString() Refer below sample https://stackoverflow.com/questions/7939146/how-to-foreach-a-column-in-a-datatable-using-c
Salman Beg6y ago
Hi.Put breakpoint and check what is the value you are getting in row. I think in row you are getting value but row is having some properties that you need to use with row. In immediate window also you can check what is the value of row and which property you need to use. Thanks.