public partial class Form1 : Form {
public Form1()
{
InitializeComponent();
}
String connect = @"provider=microsoft.jet.oledb.4.0;" + @"data source=" + Application.StartupPath + "/dbs.mdb";
OleDbConnection con;
OleDbCommand command;
OleDbDataAdapter adapter;
DataTable objDataTable;
private void load()
{
try
{
con = new OleDbConnection(connect);
con.Open();
string query = "select madde,family,name,ncode,emha from zirna";
command = new OleDbCommand();
command.CommandText = query;
command.Connection = con;
adapter = new OleDbDataAdapter();
adapter.SelectCommand = command;
objDataTable = new DataTable();
adapter.Fill(objDataTable);
con.Close();
dataGridView1.DataSource = objDataTable;
dataGridView1.Columns[0].HeaderText = "ماده";
dataGridView1.Columns[0].Width = 80;
dataGridView1.Columns[1].HeaderText = "ردیف";
dataGridView1.Columns[1].Width = 100;
dataGridView1.Columns[2].HeaderText = "بند";
dataGridView1.Columns[2].Width = 70;
dataGridView1.Columns[3].HeaderText = "شرح مواد آئین نامه";
dataGridView1.Columns[3].Width = 70;
dataGridView1.Columns[4].HeaderText = "وضعیت امحاء";
dataGridView1.Columns[4].Width = 70;
}
catch { MessageBox.Show("سیستم به بانک اطلاعاتی وصل نشده است"); this.Dispose(); }
}
private void Form1_Load(object sender, EventArgs e)
{
load();
}