http://www.c-sharpcorner.com/2/DataBoundControlsCSMCB.asp数据绑定代码例子如下: string conStr = "Provider=Microsoft.JET.OLEDB.4.0;data source=c:\\northwind.mdb"; string sqlStr = "SELECT * FROM Employees";
// Create connection object
OleDbConnection conn = new OleDbConnection(conStr);
// Create data adapter object
OleDbDataAdapter da = new OleDbDataAdapter(sqlStr,conn);
// Create a dataset object and fill with data using data adapter's Fill method DataSet ds = new DataSet();
da.Fill(ds, "Employees");
// Attach dataset's DefaultView to the datagrid control
DataView dv = ds.Tables["Employees"].DefaultView; comboBox1.DataSource = dv; comboBox1.DisplayMember = "FirstName";
// Create connection object
OleDbConnection conn = new OleDbConnection(conStr);
// Create data adapter object
OleDbDataAdapter da = new OleDbDataAdapter(sqlStr,conn);
// Create a dataset object and fill with data using data adapter's Fill method DataSet ds = new DataSet();
da.Fill(ds, "Employees");
// Attach dataset's DefaultView to the datagrid control
DataView dv = ds.Tables["Employees"].DefaultView; comboBox1.DataSource = dv; comboBox1.DisplayMember = "FirstName";
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货