Question

C#checkedListBox绑定数据库的问题

checkedListBox绑定数据库的代码

class DBcon
{
public string strSQL;
public string connectionString;
public SqlConnection myConnction;
public SqlCommandBuilder sqlCmdBld;
public DataSet ds = new DataSet();
public SqlDataAdapter da;
}
private void checkedListBox1_SelectedIndexChanged(object sender, EventArgs e)
{
DBcon db = new DBcon();
this.checkedListBox1.DataSource = db.ds.Tables["point"];
this.checkedListBox1.ValueMember = listBox1.ValueMember;
this.checkedListBox1.DisplayMember = "pname";
}
最近才用C#和数据库，很多地方查了好多还是很茫然。
那个怎么能在checkedListBox控件中显示出point表中需要显示的字段。是listBox1中选定科目，checkedListBox中显示该科目的知识点~
求助，谢谢大家啦。

Answer 1

绑定时有2个值
一个是TEXT另外一个是VALUE
CheckBoxList1.DataTextField = "NAME";//数据库字段
CheckBoxList1.DataValueField = "ID";
谢谢

Answer 2

this.checkedListBox1.DataSource = db.ds.Tables["point"];
在这语句之前添加依据 this.checkedListBox1.DataSource = null;

Answer 3

在checkedListBox1_SelectedIndexChanged函数中添加 this.checkedListBox1.DataBind();