Jumat, 03 Juni 2016

Tugas Buka Tambah Hapus Access


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