combox与SQL数据库的一个列绑定并且显示 详细的帮我讲解一下 最好有代码

Question

数据库名：Driver
数据库表明：Prefix
数据库表列名：（UID，PName）
绑定combox1上 在上面显示PName列里的所有从UID0-32的信息

Answer 1

private static SqlConnection conn;
        public static SqlConnection Conn
        {            get
            {
                try
                {                    string connstr = "server=.;database=Driver;User ID=sa;Password=123456";
                    if (conn == null)
                        conn = new SqlConnection(connstr);
                    if (conn.State == ConnectionState.Closed)
                        conn.Open();
                    if (conn.State == ConnectionState.Broken)
                    {
                        conn.Close();
                        conn.Open();
                    }
                    return conn;                }
                catch (Exception ex)
                {                    throw;
                }
            }
        }
        //查询:得到DataTable
        public static DataTable GetTable(string SqlStr)
        {
            try
            {      
            SqlDataAdapter dap = new SqlDataAdapter(SqlStr, Conn);
            DataSet ds = new DataSet();
            dap.Fill(ds);
            conn.Close();
            return ds.Tables[0];
            }
            catch (Exception ex)
            {                throw;
            }
        }
string sql="select UID，PName from  Prefix";DataTable dt=GetTable(sql);
  combox1.DataSource = Deptsdt;
   combox1.DisplayMember = "PName";
   combox1.ValueMember = "UID";

Answer 2

combox1.DataSource = 通过代码获得你的表;
combox1.DisplayMember = "UID";
combox1.ValueMember = "PName";