Imas nekoliko nacina da to uradis. Primjeri su u C# i koriste SQLCE. Lagano ti je korigovati za bazu koju ti koristis, kao i sam jezik.
Klasa koja se konektuje:
Code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlServerCe;
namespace DBTESTACCESS
{
class update
{
private DataTable dTable;
private SqlCeDataAdapter dAdapter;
public DataTable eto()
{
string connString = @"Data Source = |DataDirectory|\intercom.sdf";
//create the database query
string query = "SELECT * FROM prodaja";
//create an OleDbDataAdapter to execute the query
dAdapter = new SqlCeDataAdapter(query, connString);
//create a command builder
SqlCeCommandBuilder cBuilder = new SqlCeCommandBuilder(dAdapter);
//create a DataTable to hold the query results
dTable = new DataTable();
dAdapter.Fill(dTable);
return (dTable);
}
public void azuriraj()
{
dAdapter.Update(dTable);
}
}
}
Punjenje gridview-a (mozes staviti u formload, na button, gdje vec zelis
Code:
update novo = new update();
BindingSource bSource = new BindingSource();
bSource.DataSource = novo.eto();
dataGridView1.DataSource = bSource;
Azuriranje same baze sa vrijednostima iz gridview-a (ako je bilo izmjena).
Code:
novo.azuriraj();
Valjda ce ti pomoci :)
C# datagridview punjenje
