■ サンプル
デザイン部
* DataGridView を追加(Anchor : Top, Bottom, Left, Right)
プログラム部 / Form1.cs
using System;
using System.Data;
using System.Data.OleDb;
using System.Windows.Forms;
namespace SampleShowAccessData
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
OleDbConnection ocn = new OleDbConnection(
@"Provider=Microsoft.Jet.OLEDB.4.0;"
+ @"data source=C:\customerDB.mdb");
ocn.Open();
OleDbCommand ocmd = new OleDbCommand();
ocmd.CommandText = "SELECT * FROM customer";
ocmd.Connection = ocn;
OleDbDataAdapter oda = new OleDbDataAdapter();
oda.SelectCommand = ocmd;
DataSet ds = new DataSet();
oda.Fill(ds, "data");
dataGridView1.DataSource = ds.Tables[0];
}
}
}