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);
}
}
