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
2010-06-21 09:50:36
MY return type is Datatable..
Shiny
2010-06-21 10:38:27
@Shiny: You're asking how to add the columns to a ListBox.
Ardman
2010-06-21 10:46:41
+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
2010-06-21 09:51:21