WindForm中的Combox的数据绑定

最新推荐文章于 2018-11-13 17:30:00 发布

KnowNothingLikeEat

最新推荐文章于 2018-11-13 17:30:00 发布

阅读量1.3k

点赞数

分类专栏：控件

本文链接：https://blog.csdn.net/Sara_xie/article/details/45391953

版权

控件专栏收录该内容

11 篇文章 0 订阅

订阅专栏

void BindStation()   //绑定岗位
        {
            cb_Station.Items.Clear();
            string conn = System.Configuration.ConfigurationSettings.AppSettings["conn"].ToString();
            SqlConnection sqlconn = new SqlConnection(conn);
            sqlconn.Open();
            SqlCommand cmd = sqlconn.CreateCommand();
            cmd.CommandText = "select * from lab_Station";
            SqlDataReader reader = cmd.ExecuteReader();

           while(reader.Read())
           {
               cb_Station.Items.AddRange(new object[] { reader["StationName"] });
           }
            reader.Close();
            sqlconn.Close();
        }

 void BindStation()   //绑定岗位
        {
            cb_Station.Items.Clear();
            string conn = System.Configuration.ConfigurationSettings.AppSettings["conn"].ToString();
            SqlConnection sqlconn = new SqlConnection(conn);
            sqlconn.Open();
            SqlDataAdapter adp = new SqlDataAdapter("select * from lab_Station", sqlconn);
            DataSet dataSet = new DataSet();
            adp.Fill(dataSet);
            DataTable dt = dataSet.Tables[0];
            if (dt != null && dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    cb_Station.Items.Add(dr["StationName"].ToString());
                }
            }