[ mvasicdo @ 16.01.2007. 10:55 ] @
evo problema:
na moze da mi se izvrsi update komanda, izbaci mi sledecu gresku:

Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.

A evo i kompletnog koda:

Code:
public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private OleDbConnection CN = new OleDbConnection();
        private DataTable zaGrid;

        private void Form1_Load(object sender, EventArgs e)
        {
            string sProvider = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\projects\\c#\\Registar\\Registar\\bin\\Debug\\Data\\data.mdb;Persist Security Info=False;Jet OLEDB:Database Password=";
            CN.ConnectionString = sProvider;
            CN.Open();

            zaGrid = new DataTable();
            DataColumn colStatus = new DataColumn("zavrseno", typeof(bool));
            DataColumn colSubjekat = new DataColumn("tema", typeof(string));
            DataColumn colIme = new DataColumn("ime", typeof(string));
            DataColumn colImeOca = new DataColumn("ime_oca", typeof(string));
            DataColumn colPrezime = new DataColumn("prezime", typeof(string));
            DataColumn colRJ = new DataColumn("rj", typeof(string));
            DataColumn colDatum = new DataColumn("datum", typeof(string));
            DataColumn colVrijeme = new DataColumn("vrijeme", typeof(string));
            DataColumn colAlarm = new DataColumn("alarm", typeof(bool));
            DataColumn colID = new DataColumn("id", typeof(long));

            zaGrid.Columns.Add(colID);
            zaGrid.Columns.Add(colIme);
            zaGrid.Columns.Add(colImeOca);
            zaGrid.Columns.Add(colPrezime);
            zaGrid.Columns.Add(colRJ);
            zaGrid.Columns.Add(colDatum);
            zaGrid.Columns.Add(colVrijeme);
            zaGrid.Columns.Add(colSubjekat);
            zaGrid.Columns.Add(colAlarm);
            zaGrid.Columns.Add(colStatus);

            dataGridView1.DataSource = zaGrid;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            OleDbDataAdapter adapter;
            adapter = new OleDbDataAdapter("select * from task",CN);
            adapter.Fill(zaGrid);
        }

        private void button2_Click(object sender, EventArgs e)
        {
            OleDbDataAdapter adapter = new OleDbDataAdapter("select * from task", CN);
            OleDbCommandBuilder mySqlCommandBuilder = new OleDbCommandBuilder(adapter);
           
//ovdje mi izbaci gresku...
            adapter.Update(zaGrid);
        }
    }
[ Dejan Vesic @ 16.01.2007. 11:19 ] @
Lepo ti kaže:

Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.

Nemaš primarni ključ u tabeli.
[ mvasicdo @ 16.01.2007. 11:27 ] @
Nema sta, ko zna zna....
Hvala to je to....