[es] - ne moze da mi izvrsi update

mvasicdo
Mladen Vasic
Doboj

Član broj: 104294
Poruke: 226
*.teol.net.

Profil

^{16.01.2007. u 10:55 - pre 210 meseci}

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

Odgovor na temu

Dejan Vesic
Dejan Vesic
CEO
IGT Ogranak Beograd
Beograd

Član broj: 84929
Poruke: 217
*.finsoft.co.yu.

Sajt: www.vesic.org

+1 Profil

Re: ne moze da mi izvrsi update

^{16.01.2007. u 11:19 - pre 210 meseci}

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.

http://www.vesic.org | Blog: http://www.vesic.org/blog | Programming:
http://www.vesic.org/english/blog

Odgovor na temu