private void btn_secilenleri_oku_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); DataTable dt = new DataTable(); for (int i = 0; i < listBox1.Items.Count; i++) { ExcelBaglanOku.ExcelYol = listBox1.Items[i].ToString(); dt = ExcelBaglanOku.ExcelOku(); ds.Tables.Add(dt); } DataTable dtAll = ds.Tables[0].Copy(); for (var i = 1; i < ds.Tables.Count; i++) { dtAll.Merge(ds.Tables[i]); } dataGridView1.AutoGenerateColumns = true; dataGridView1.DataSource = dtAll; }
private void btn_oku_Click(object sender, EventArgs e) { dataGridView1.DataSource = ExcelBaglanOku.ExcelOku(); }