private void vistaButton1_Click(object sender, EventArgs e) { try { excel = new Konektor_Excel(); ds = new DataSet(); openFileDialog1.Filter = "Excel File (*.xlsx)| *.xlsx;"; openFileDialog1.FilterIndex = 2; openFileDialog1.Title = "Cari File Excel"; openFileDialog1.RestoreDirectory = true; if (openFileDialog1.ShowDialog() == DialogResult.OK) { textBox1.Text = openFileDialog1.FileName; } ds = excel.GetDataExcel(textBox1.Text); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Columns[0].HeaderText = "No Induk"; dataGridView1.Columns[0].Width = 150; dataGridView1.Columns[1].HeaderText = "Nama Siswa"; dataGridView1.Columns[1].Width = 250; dataGridView1.Columns[2].HeaderText = "Alamat"; dataGridView1.Columns[2].Width = 180; dataGridView1.Columns[3].HeaderText = "Kelas"; dataGridView1.Columns[3].Width = 80; dataGridView1.Columns[4].HeaderText = "Nama Wali"; dataGridView1.Columns[4].Width = 250; dataGridView1.Columns[5].HeaderText = "Nomer HP"; dataGridView1.Columns[5].Width = 180; } catch (Exception) { MessageBox.Show("Buka File Excelnya Dulu !!","Warning !!",MessageBoxButtons.OK,MessageBoxIcon.Warning); } }
private void vistaButton1_Click(object sender, EventArgs e) { try { excel = new Konektor_Excel(); ds = new DataSet(); openFileDialog1.Filter = "Excel File (*.xlsx)| *.xlsx;"; openFileDialog1.FilterIndex = 2; openFileDialog1.Title = "Cari File Excel"; openFileDialog1.RestoreDirectory = true; if (openFileDialog1.ShowDialog() == DialogResult.OK) { textBox1.Text = openFileDialog1.FileName; } ds = excel.GetDataExcel(textBox1.Text); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Columns[0].HeaderText = "No Induk"; dataGridView1.Columns[0].Width = 150; dataGridView1.Columns[1].HeaderText = "Nama Siswa"; dataGridView1.Columns[1].Width = 250; dataGridView1.Columns[2].HeaderText = "Alamat"; dataGridView1.Columns[2].Width = 180; dataGridView1.Columns[3].HeaderText = "Kelas"; dataGridView1.Columns[3].Width = 80; dataGridView1.Columns[4].HeaderText = "Nama Wali"; dataGridView1.Columns[4].Width = 250; dataGridView1.Columns[5].HeaderText = "Nomer HP"; dataGridView1.Columns[5].Width = 180; } catch (Exception) { MessageBox.Show("Buka File Excelnya Dulu !!", "Warning !!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }