C# 数据库如何绑定在comboBox(9999999999999999999)

[lovecsx]

我要把数据库一个表(A表)的其中一列(SORT)的所有数据都绑定在comboBox.让comboBox下拉选择.
还有新添加进去的数据也要能绑定在comboBox.

[jone999]

for example:
Binding bindId=new Binding("text",myDataSet,"book.id");
Binding bindName=new Binding("text",myDataSet,"book.name");
txtId.DataBinding.Add(bindId);
txtName.DataBinding.Add(bindName);

[nedvedlh]

strSql = "......";
DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.CONN_STRING_XJ_XL,
System.Data.CommandType.Text, strSql);

ctrlCmb.DataSource = ds;

string strTableName = ds.Tables[0].TableName;
ctrlCmb.DisplayMember = strTableName + "." + strDispFieldNm;
ctrlCmb.ValueMember = strTableName + "." + strValueFieldNm;