string sConn = "server=localhost;uid=test;pwd=test;database=CSGL"; SqlConnection conn = new SqlConnection(sConn); conn.Open(); DataSet ds = new DataSet(); string sql = "select * from stu"; SqlDataAdapter da = new SqlDataAdapter(sql, conn); try { da.Fill(ds); this.dataGridView1.DataSource = ds.Tables[0]; this.comboBox1.Items.Clear(); List<ComData> items = new List<ComData>(); items.Add(new ComData()); ComData tmp = null; foreach (DataRow dr in ds.Tables[0].Rows) { tmp = new ComData(); tmp.Code = (int)dr[0]; tmp.Name = (string)dr[1]; items.Add(tmp); } this.comboBox1.DataSource = items; this.comboBox1.ValueMember = "code"; this.comboBox1.DisplayMember = "name"; } catch { throw; } conn.Close(); 其中用到的类为: public class ComData { private int code; public int Code { get { return code; } set { code = value; } } private string name; public string Name { get { return name; } set { name = value; } } }