****winform combox动态绑定数据****
动态绑定数据
public void comboxlist()
{
this.comboBox1.Items.Clear();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=.;Initial Catalog=Lloct;User ID=sa;Password=123456;";
conn.Open();
string sqlstr = "select distinct WorkWearType from WorkWear";
SqlCommand com = new SqlCommand(sqlstr, conn);
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
this.comboBox1.Items.Add(dr[0].ToString());
this.Workwear.Items.Add(dr[0].ToString());
}
conn.Close();
}
~~单击datagridview~~
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
int id = dataGridView1.SelectedRows[0].Index;
string type = dataGridView1.Rows[id].Cells["WorkWeraType"].Value.ToString();
this.Workwear.Text = dataGridView1.Rows[id].Cells["WorkWeraType"].Value.ToString();
this.RowsNum.Text = dataGridView1.Rows[id].Cells["ShelfRow"].Value.ToString();
this.LedNum.Text = dataGridView1.Rows[id].Cells["Leds"].Value.ToString();
this.TagPosition.Text = dataGridView1.Rows[id].Cells["ElectronicLabelPosition"].Value.ToString();
}