1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
| using System;
using System.Data;
using System.Data.OleDb;
using System.Windows.Forms;
namespace DataGridviewControl
{
public partial class Form1 : Form
{
OleDbCommand cmd;
OleDbDataAdapter da;
OleDbCommandBuilder cmdb;
DataSet ds;
DataTable dt;
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string connectionSourceOdsdatabaseAccdb = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=OdsDatabase.accdb";
string oledb = "SELECT * FROM dictionary";
OleDbConnection conn = new OleDbConnection(connectionSourceOdsdatabaseAccdb);
conn.Open();
cmd = new OleDbCommand(oledb, conn);
da = new OleDbDataAdapter(cmd);
cmdb = new OleDbCommandBuilder(da);
ds=new DataSet();
da.Fill(ds, "dictionary");
dt = ds.Tables["Dictionary"];
conn.Close();
dataGridView1.DataSource = ds.Tables["dictionary"];
dataGridView1.ReadOnly = true;
save_btn.Enabled = false;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
}
private void new_btn_Click(object sender, EventArgs e)
{
dataGridView1.ReadOnly = false;
save_btn.Enabled = true;
new_btn.Enabled = false;
delete_btn.Enabled = false;
}
private void delete_btn_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Do you want to delete this row?","Delete",MessageBoxButtons.YesNo)==DialogResult.Yes)
{
dataGridView1.Rows.RemoveAt(dataGridView1.SelectedRows[0].Index);
da.Update(dt);
}
}
private void save_btn_Click(object sender, EventArgs e)
{
da.Update(dt);
dataGridView1.ReadOnly = true;
save_btn.Enabled = false;
new_btn.Enabled = true;
delete_btn.Enabled = true;
}
}
} |
Partager