private void requistionDate(string sql) { HY_BLL.HY_SupplierBLL hysuplist = new HY_SupplierBLL(); this.listView1.View = View.Details; this.listView1.FullRowSelect = true; SqlDataReader sdr = hysuplist.f_SupplierLiset(sql); while (sdr.Read()) { ListViewItem lv = new ListViewItem(sdr[0].ToString()); lv.SubItems.Add(sdr[1].ToString()); lv.SubItems.Add(sdr[2].ToString()); this.listView1.Items.Add(lv); } }
private void HY_SupplierList_Load(object sender, EventArgs e) { HY_BLL.HY_SupplierBLL hysuplist = new HY_SupplierBLL(); this.listView1.View = View.Details; this.listView1.FullRowSelect = true; string sql = "select s_gyName,s_jName,s_Area,s_Name,s_Tel,s_cpName from HY_Supplier"; SqlDataReader sdr = hysuplist.f_SupplierLiset(sql); while (sdr.Read()) { ListViewItem lv = new ListViewItem(sdr[0].ToString()); lv.SubItems.Add(sdr[1].ToString()); lv.SubItems.Add(sdr[2].ToString()); lv.SubItems.Add(sdr[3].ToString()); lv.SubItems.Add(sdr[4].ToString()); lv.SubItems.Add(sdr[5].ToString()); lv.ImageIndex = 1; this.listView1.Items.Add(lv); } }