tags:

views:

37

answers:

2

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

+1  A: 
DataColumnCollection columns = ds.Tables[0].Columns;
foreach (DataColumn column in columns)
{
    listBox1.Items.Add(column.ColumnName);
}
Ardman
MY return type is Datatable..
Shiny
@Shiny: You're asking how to add the columns to a ListBox.
Ardman
+1  A: 

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;
Pranay Rana