如何从数据库中获取项目以检查列表框? [英] How Can I Get Items From Database To Check List Box?
本文介绍了如何从数据库中获取项目以检查列表框?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
谁能从数据库中获取项目以检查列表框?
解决方案
从数据库中读取数据,例如你可以得到DataTable
myCheckedListBox.DataSource = fillDataTable();
myCheckedListBox.DisplayMember = DisplayColumnName;
myCheckedListBox.ValueMember = valueColumnName;
thst's it :)
public DataTable fillDataTable()
{
使用(SqlConnection sqlConn = new SqlConnection(conSTR))
使用(SqlCommand cmd = new SqlCommand( 从MyTable中选择DisplayColumnName,valueColumnName,sqlConn))
{
sqlConn.Open();
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
return dt;
}
}
参考: how-to-populate-access-and-check-items-in-checkedlistbox-control-in-csharp [ ^ 一>
who can i get items from database to check list box?
解决方案
read the datafrom database, for example you can getDataTable
myCheckedListBox.DataSource = fillDataTable(); myCheckedListBox.DisplayMember = "DisplayColumnName"; myCheckedListBox.ValueMember = "valueColumnName";
thst's it :)
public DataTable fillDataTable() { using(SqlConnection sqlConn = new SqlConnection(conSTR)) using(SqlCommand cmd = new SqlCommand("select DisplayColumnName,valueColumnName from MyTable" , sqlConn)) { sqlConn.Open(); DataTable dt = new DataTable(); dt.Load(cmd.ExecuteReader()); return dt; } }
Refer: how-to-populate-access-and-check-items-in-checkedlistbox-control-in-csharp[^]
这篇关于如何从数据库中获取项目以检查列表框?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文