Ejemplo de código fuente C# de la base de datos de Access
Usar System.Drawing
Usar System.Linq
Usar System.Text; .Windows.
OleDb;
espacio de nombres Getting_Started_Winforms_To_MDB__VS_2008__
{
clase pública parcial Form1: Formulario
{
OleDbConnection conn;
Adaptador OleDbDataAdapter;
DataTable dtCustomers;
form1 público()
{
InitializeComponent();
}
private void Form1_Load(remitente del objeto, EventArgs e)
{
conn = new OleDbConnection("Provider=Microsoft.Jet.OleDb. 4.0; Fuente de datos=Store.mdb; ");
conn.Open();
dtCustomers = new DataTable();
adapter = nuevo OleDbDataAdapter ("SELECT * FROM Clientes;",
conn);
adapter.Fill(dtCustomers)InsertCommand = cmdInsert
var cmdUpdate = new OleDbCommand(" ACTUALIZAR Clientes SET FullName = ?, PassportId = ? WHERE id = ?;", conn);
cmdUpdate.Parameters.Add("p1", OleDbType.BSTR, -1, "FullName = ?UpdateCommand = cmdUpdate;
var cmdDelete = new OleDbCommand("BORRAR DE Clientes DONDE id =?", conn);
cmdDelete.Parameters.Add("p1", OleDbType.Integer, 5 , "id");
adapter.AllCells;
var photoColumnWidth = dataGridView1.Columns["Photo"].Width
var rowHeights = new Listlt; ; intgt ();
for (int i = 0; i lt; dataGridView1.Rows.Count; i )
{
rowHeights.Add( dataGridView1.Rows[i].Height);
}
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
dataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.
dataGridView1.Columns["Photo"].Width = photoColumnWidth;
for (int i = 0; i lt; dataGridView1.Rows.Count; i )
{
dataGridView1.Rows[i].Height = rowHeights[i];
}
}
catch { }
textBox1.DataBindings.Add("dataGridViewAutoSizeRowsMode.None");
DataGridView1.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode. DataBindings.Add("Text", dtCustomers, "FullName");
}
vacío privado btnSave_Click(remitente del objeto, EventArgs e)
{
adapter.Update(dtClientes);
}
}
}
}