数据表到列表框 [英] Datatable to listbox

问题描述

我想从数据表中添加1列数据到列表框，这是我无法实现的代码..！此处dt1是一个数据表.

Hi,

I wanna add 1 column data from datatable to listbox here is the code by which i am not able to achieve ..! here dt1 is a datatable.

for (i = 0; i < dt1.Rows.Count; i++)
{
    ListBox1.Items[i].value = dt1.Rows[i][1].ToString();
}

thanks in advance.

推荐答案

不用自己添加项目，只需使用DataSource DisplayMember和ValueMember，如下所示:

Instead of adding the items yourself, simply use the DataSource DisplayMember and ValueMember, like this:

listBox1.DataSource = dt1;
listBox1.DisplayMember = "Name";
listBox1.ValueMember = "ID";

名称和ID需要用表中的列替换.


如果您想查看更多列，请在这里查看:
http://www.codeproject.com/KB/combobox/multicolumnlistbox.aspx [ ^ ]

祝你好运！

Name and ID need to be replaced by columns in your table.


If you would like to see more columns, have a look here:
http://www.codeproject.com/KB/combobox/multicolumnlistbox.aspx[^]

Good luck!

试试这个:

Hi,
try this:

using (SqlConnection conn = new SqlConnection(CONN_STR))
using (SqlDataAdapter da = new sqlDataAdapter("roboticSiteNames", conn)) {
DataSet ds = new DataSet();
da.Fill(ds);
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;
}

问候
罗伯特

Regards
Robert

List<string> lst = new List<string>();
           foreach (DataRow r in dt.Rows)
           {
               lst.Add(r["ColumnName"].ToString());
           }
           listBox1.Items.Clear();
           listBox1.DataSource = lst;

这篇关于数据表到列表框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！