Reputation: 1083
I have Datatable collected with my Column Names.. I want to add them in listbox.. Many column are there.. So need to use For each how can i achieve this
Upvotes: 1
Views: 633
Reputation: 48587
DataColumnCollection columns = ds.Tables[0].Columns;
foreach (DataColumn column in columns)
{
listBox1.Items.Add(column.ColumnName);
}
Upvotes: 0
Reputation: 176956
using DisplayMember and ValueMember
DataTable dt = ds.Tables[0];
// 1. set DisplayMember and ValueMember
lbSiteCode.DisplayMember = dt.Columns[0].ColumnName;
lbSiteCode.ValueMember = dt.Columns[1].ColumnName;
// 2. set DataSource
lbSiteCode.DataSource = dt;
Upvotes: 1