private void Form2_Load(object sender, EventArgs e) { string sql = "select distinct cycle from db2admin.view_quantities where year>'2019年' order by cycle desc"; ExcelTodb2 dt = new ExcelTodb2(); string [][] item2 = dt.DataTableToArray(sql); comboBox1.DataSource = dt.ArrayToItem(item2); }
/* public string[] getxiaxia(string[][] st1) * { * * Datatabletoarr sp = new Datatabletoarr(); * string[] st2 = new string[st1.Length ]; * st2=sp.Toarr1(st1); * if (st2.Length == 0 || st2 == null) * { * return null; * } * else * { * return st2; * } * } * /* public string[][] Getdd(string sql) * { * DataTable dl = new DataTable(); * Getdata gt = new Getdata(); * dl = gt.Getdat_db2(sql); * string[][] st = null; * Datatabletoarr st1 = new Datatabletoarr(); * st = st1.Toarry(dl); * return st; * * * }*/ private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { string sql = "select distinct productdesc,productcode from db2admin.view_quantities where cycle='" + comboBox1.Text + "' order by productcode"; ExcelTodb2 dt = new ExcelTodb2(); DataTable tb = new DataTable(); Item1 = dt.DataTableToArray(sql); Item = dt.ArrayToItem(Item1); comboBox2.DataSource = Item; }
private void button1_Click(object sender, EventArgs e) { //向父窗体传递新增周期参数 weituo2(pam); // _ = new DataSet(); //ds = ExcelTodb2.ReadExcel(label2.Text); //查询是否已经导入过文件周期的数据 ExcelTodb2 tt = new ExcelTodb2(); string sql = string.Format("select distinct cyclname,cyclcode from db2admin.sales_cycle where cyclcode='{0}'", label9.Text); // DataSet ds = tt.UpToDb2(sql); string[] st = tt.ArrayToItem(tt.DataTableToArray(sql)); if (st == null) { MessageBox.Show("数据库查询错误,请联系管理员"); } else if (st.Length > 0) { MessageBox.Show("数据库已有相关记录"); } else { foreach (string tex in path) { tt.UpToDb2(tex); } } //MessageBox.Show(ds.Tables.Count.ToString ()); //dataGridView1.DataSource =ds.Tables ["pam"]; // dataGridView1 . // DataRow [] dr = ds.Tables[0].Select("F5 like '%标准%'"); this.Dispose(); }