ComboBox数据的绑定

 1             //带有ComboBox控件点Load事件
 2         private void Library_Load(object sender, EventArgs e)
 3         {
 4             //创建连接字符串
 5             string strConn = "Data Source=.;Initial Catalog=Library;User Id=sa;Pwd=ok";
 6             //创建Connection对象
 7             SqlConnection conn = new SqlConnection(strConn);
 8             //创建DataSet对象
 9             DataSet ds = new DataSet();
10             //编写查询语句
11             string sql = "SELECT * FROM BookType";
12             //创建数据适配器对象
13             SqlDataAdapter adapter = new SqlDataAdapter(sql,conn);
14             //填充数据到数据集对象中
15             adapter.Fill(ds,"BookType");
16             //在此表中新建一行，显示的值为“请选择”,实际的值为-1
17             DataRow row = ds.Tables["BookType"].NewRow();
18             row[0] = -1;
19             row[1] = "请选择...";
20             ds.Tables["BookType"].Rows.InsertAt(row, 0);
21             //将数据绑定在ComboBox控件中
22             this.cboType.DataSource=ds.Tables["BookType"];
23             this.cboType.ValueMember = "TypeId";
24             this.cboType.DisplayMember = "TypeName";
25         }