combobox绑定至数据库

SQL绑定 private void Form1_Load(object sender, System.EventArgs e) { //在formload时绑定数据表yg到comboBox1 SqlConnection conn=new SqlConnection("server=.;uid=sa;pwd=;database=gz"); conn.Open(); SqlDataAdapter da=new SqlDataAdapter("select * from yg",conn); DataSet ds=new DataSet(); da.Fill(ds,"yg"); DataRow dr = ds.Tables["yg"].NewRow(); dr["ygid"] = "0"; dr["ygname"] = "-请选择-"; ds.Tables["yg"].Rows.InsertAt(dr, 0); this.comboBox1.DataSource=ds.Tables["yg"]; this.comboBox1.DisplayMember="ygname"; //显示的列 this.comboBox1.ValueMember="ygid"; //数据列,次列会在selectedvalue中显示 conn.Close(); } access数据库的绑定 using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace WindowsApplication1 {     public partial class Form1 : Form     {                public Form1()         {             InitializeComponent();         }        private void Form1_Load(object sender, EventArgs e)         {                       string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = Company.mdb";             OleDbConnection myConn = new OleDbConnection(strCon);             string strCom = " SELECT * FROM company ";             //创建一个 DataSet             DataSet myDataSet = new DataSet();             myConn.Open();             //用 OleDbDataAdapter 得到一个数据集             OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);             //把Dataset绑定company数据表             myCommand.Fill(myDataSet, "company");             //关闭此OleDbConnection             myConn.Close();             this.CmbName.DataSource = myDataSet;             this.CmbName.DisplayMember = "company.Name";             this.CmbName.ValueMember = "company.Name";         }                                     private void CmbName_SelectedIndexChanged(object sender, EventArgs e)         {             string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = Company.mdb";             OleDbConnection myConn = new OleDbConnection(strCon);             myConn.Open();             string strSQL = "select * from company where company.Name='" + this.CmbName.Text + "'";             OleDbCommand com = new OleDbCommand(strSQL, myConn);             OleDbDataReader read = com.ExecuteReader();             if (read.Read())             {                 Address.Text = read["Address"].ToString();                 Tel.Text = read["Tel"].ToString();             }         }          } }