Code:
query = "SELECT n.Number, c.Kategory, c.FL_Charge, c.FL_Duration, c.Unit_Charge, " +
"c.Unit_Duration FROM Costs c INNER JOIN ColledNumber n ON c.id_BR = n.id_bR";
daCijene = new OleDbDataAdapter(query, connString);
Cijene = new DataTable();
daCijene.Fill(Cijene);
bSource = new BindingSource();
bSource.DataSource = Cijene ;
dgCosts.DataSource = bSource;
query = "SELECT n.Number, c.Kategory, c.FL_Charge, c.FL_Duration, c.Unit_Charge, " +
"c.Unit_Duration FROM Costs c INNER JOIN ColledNumber n ON c.id_BR = n.id_bR";
daCijene = new OleDbDataAdapter(query, connString);
Cijene = new DataTable();
daCijene.Fill(Cijene);
bSource = new BindingSource();
bSource.DataSource = Cijene ;
dgCosts.DataSource = bSource;
Nakon unosa podataka dataAdapter bi trebao da update-uje samo ove kolone: 'c.FL_Charge, c.FL_Duration, c.Unit_Charge, c.Unit_Duration '
Sledeca komanda vraca exception.
Code:
try
{
daCijene.Update(Cijene);
}
catch (InvalidOperationException ioe)
{
MessageBox.Show(ioe.Message);
}
try
{
daCijene.Update(Cijene);
}
catch (InvalidOperationException ioe)
{
MessageBox.Show(ioe.Message);
}
Kako da dataAdapteru napravim update comandu?
SELECT * FROM หน่วยงานหลัก WHERE ยสันติ LIKE 'โดย%'