private void InputCaiDanHao_Load(object sender, EventArgs e) { label1.Text = frmLabel; //List<ChiMa_Dapeibiao> list = cal.SelectChiMaDapei("").GroupBy(p => p.BiaoName).Select(pc => pc.First()).ToList<ChiMa_Dapeibiao>(); comboBox1.DisplayMember = "BiaoName"; comboBox1.ValueMember = "id"; List <ChiMa_Dapeibiao> list = new List <ChiMa_Dapeibiao>(); ChiMa_Dapeibiao cd = new ChiMa_Dapeibiao() { BiaoName = "RGL1", id = 1 }; ChiMa_Dapeibiao cd1 = new ChiMa_Dapeibiao() { BiaoName = "RGL2", id = 2 }; ChiMa_Dapeibiao cd2 = new ChiMa_Dapeibiao() { BiaoName = "SLIM", id = 3 }; ChiMa_Dapeibiao cd3 = new ChiMa_Dapeibiao() { BiaoName = "RGLJ", id = 4 }; ChiMa_Dapeibiao cd4 = new ChiMa_Dapeibiao() { BiaoName = "D.PANT", id = 5 }; ChiMa_Dapeibiao cd5 = new ChiMa_Dapeibiao() { BiaoName = "C.PANT", id = 6 }; list.Add(cd); list.Add(cd1); list.Add(cd2); list.Add(cd3); list.Add(cd4); list.Add(cd5); comboBox1.DisplayMember = "BiaoName"; comboBox1.ValueMember = "id"; comboBox1.DataSource = list; List <clsBuiness.KuanShiBiao> cdlist = cal.SelectKuanshi().GroupBy(g => g.STYLE).Select(pc => pc.First()).ToList <clsBuiness.KuanShiBiao>(); textBox1.DataSource = cdlist; textBox1.DisplayMember = "STYLE"; textBox1.ValueMember = "Id"; }
private void InputCreatYjcb_Load(object sender, EventArgs e) { List <JiaGongChang> jgc = df.selectJiaGongChang().GroupBy(j => j.Name).Select(sc => sc.First()).ToList <JiaGongChang>(); comboBox1.DataSource = jgc; comboBox1.DisplayMember = "Name"; comboBox1.ValueMember = "id"; List <clsBuiness.KuanShiBiao> cdlist = cal.SelectKuanshi().GroupBy(g => g.STYLE).Select(pc => pc.First()).ToList <clsBuiness.KuanShiBiao>(); textBox1.DataSource = cdlist; textBox1.DisplayMember = "STYLE"; textBox1.ValueMember = "Id"; }
public void bindDataGirdview() { List <KuanShiBiao> list = cal.SelectKuanshi(); DataTable dt = new DataTable(); dt.Columns.Add("Id", typeof(int)); for (int i = 0; i < dataGridView1.Columns.Count; i++) { if (!dataGridView1.Columns[i].HeaderCell.Value.ToString().Equals("Id")) { dt.Columns.Add(dataGridView1.Columns[i].HeaderCell.Value.ToString(), typeof(String)); } } foreach (KuanShiBiao s in list) { dt.Rows.Add(s.Id, s.STYLE, s.DESC, s.FABRIC, s.JACKET, s.PANT, s.mark1, s.ShuoMing, s.mark2); } dataGridView1.DataSource = dt; }