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);
        }

    }
}

Code:


update novo = new update();

            BindingSource bSource = new BindingSource();
            bSource.DataSource = novo.eto();
            dataGridView1.DataSource = bSource;
             

Code:

novo.azuriraj();