---------------------- Windows Phone 7手机开发、.Net培训、期待与您交流! ----------------------
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(constr))
{//到数据库的连接
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{//cmd
cmd.CommandText = "select * from Sheet1";
using (SqlDataReader reader = cmd.ExecuteReader())
{
// "select * from Sheet1")
while (reader.Read())//开始逐条读取table中的数据
{
string ids = reader["" + "编号" + ""].ToString();
//string ids = reader["编号"].ToString();
if (ids != "")
{
cmbidlist.Items.Add(ids);//将所有的编号读入到可选下啦列表中
}
}
}
}
}
程序跑起来,如果对应的表格里边有数据,则读取得到数据并添加到下拉列表中