private void LoadingHouse_Load(object sender, EventArgs e)
{
string dbstr = "server=.;uid=sa;pwd=sa;database=lianxi_data";//创建连接数据库语句
SqlConnection conn = new SqlConnection(dbstr);//把数据库语句传进去 准备好连接数据库
conn.Open();//打开数据
string sql = "SELECT DISTINCT position FROM dweller where type = '空房'";//定义好sql语句
string sql2 = "SELECT DISTINCT roomnumber FROM dweller where type = '空房'";//第二句sql
SqlCommand cmd = new SqlCommand(sql, conn);//准备执行传入的sql语句
SqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
combobox1.Items.Add(dataReader["position".ToString()]);
}
dataReader.Close();
}