berikut adalah source code buka tambah access
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace SulthanAndromeda_1506760990_bktmbhexcelaccs
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
System.Data.OleDb.OleDbConnection MyConnection;
System.Data.DataSet DtSet;
System.Data.OleDb.OleDbDataAdapter MyCommand;
openFileDialog1.ShowDialog();
MyConnection = new System.Data.OleDb.OleDbConnection(@"provider=Microsoft.Jet.OLEDB.4.0;Data Source='"
+ openFileDialog1.FileName.ToString() + "';Extended Properties=Excel 8.0;");
MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", MyConnection);
MyCommand.TableMappings.Add("Table", "Net-informations.com");
DtSet = new System.Data.DataSet();
MyCommand.Fill(DtSet);
dataGridView1.DataSource = DtSet.Tables[0];
MyConnection.Close();
}
private void button2_Click(object sender, EventArgs e)
{
dataGridView1.ColumnCount = 2;
dataGridView1.Columns[0].Name = "Nama";
dataGridView1.Columns[1].Name = "Alamat";
//int baris = System.Convert.ToInt32(textBox1.Text);
string nama = System.Convert.ToString(textBox2.Text);
string alamat = System.Convert.ToString(textBox3.Text);
string[] row = new string[] { nama, alamat };
dataGridView1.Rows.Add(row);
}
private void Form1_Load(object sender, EventArgs e)
{
}
}
}

Tidak ada komentar:
Posting Komentar