110,537
社区成员
发帖
与我相关
我的任务
分享
SqlConnection conn = new SqlConnection("Server=ZHANG-85CB2E418;User Id=sa;Password=123456;Database=order;");
string commandtext = "SELECT * from Customers";
SqlCommand cmd = new SqlCommand(commandtext, conn);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
this.cmbCompany.Items.Clear();
while (dr.Read())
{
this.cmbCompany.Items.Add(dr[1].ToString());
this.cmbCompany.ValueMember=dr[1].ToString() ;
}
dr.Close();
conn.Close();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
cmbPower.Items.Add(ds.Tables[0].Rows[i]["字段"].ToString());
}