private void supplier_suoyin_Load(object sender, EventArgs e) { supplierdao s = new supplierdao(); List <supplier> ss = new List <supplier>(); ss = s.find_all(); Console.Write(ss); DataSet ds = new DataSet(); DataTable dt = new DataTable("Table_New"); dt.Columns.Add("类型", typeof(string)); dt.Columns.Add("编号", typeof(string)); dt.Columns.Add("名称", typeof(string)); dt.Columns.Add("负责人", typeof(string)); dt.Columns.Add("联系电话", typeof(string)); dt.Columns.Add("地址", typeof(string)); int i = 0; foreach (supplier s1 in ss) { dt.Rows.Add(s1.Type, s1.Supplier_number, s1.Supplier_name, s1.Charge_name, s1.Telephone, s1.Address); i++; } dataGridView1.DataSource = dt; foreach (DataGridViewColumn co in dataGridView1.Columns) { if (co.Index != 0) { co.ReadOnly = true; } } data = dataGridView1; textBox1.Focus(); }
private void TuikuanSchedule_Load(object sender, EventArgs e) { supplierdao sdao = new supplierdao(); List <supplier> ss = new List <supplier>(); ss = sdao.find_all(); foreach (supplier s in ss) { comboBox1.Items.Add(s.Supplier_number + " " + s.Supplier_name); } }
private void purchaseDetail2_Load(object sender, EventArgs e) { supplierdao sdao = new supplierdao(); List <supplier> ss = new List <supplier>(); ss = sdao.find_all(); foreach (supplier s in ss) { comboBox1.Items.Add(s.Supplier_number + " " + s.Supplier_name); } label6.Text = "0"; }