本文主要是介绍WindForm中的Combox的数据绑定,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
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());
}
}
}
这篇关于WindForm中的Combox的数据绑定的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!