Nisam uspio. Evo kod koji sam prepravio sluzeci se primjerom:
Code:
private void cmdUpdCosts_Click(object sender, EventArgs e)
{
OleDbCommandBuilder cb = new OleDbCommandBuilder(daCijene);
OleDbConnection cn = new OleDbConnection(connString);
OleDbCommand cmd;
cb.DataAdapter.SelectCommand = new OleDbCommand("SELECT ID_Br, Tab, Tarifa, FL_Charge, FL_Duration, Unit_Charge, Unit_Duration FROM Cijene", cn);
cmd = new OleDbCommand();
OleDbParameter parm = new OleDbParameter();
cmd.CommandText = "UPDATE Cijene SET FL_Charge = @FL_Charge, SET FL_Duration = @FL_Duration, " +
"SET Unit_Charge = @Unit_Charge, SET Unit_Duration = @Unit_Duration " +
"WHERE ID_BR = @ID_BR AND Tab = @Tab AND Tarifa = @Tarifa";
cmd.Parameters.Add("@FL_Charge", OleDbType.Currency, 15, dgCosts.Columns[3].ToString());
cmd.Parameters.Add("@FL_Duration", OleDbType.Numeric, 15, dgCosts.Columns[4].ToString());
cmd.Parameters.Add("@Unit_Charge", OleDbType.Currency, 15, dgCosts.Columns[5].ToString());
cmd.Parameters.Add("@Unit_Duration", OleDbType.Numeric, 15, dgCosts.Columns[6].ToString());
parm = cmd.Parameters.Add("@ID_BR", OleDbType.Char, 50, dgCosts.Columns[1].ToString());
parm = cmd.Parameters.Add("@Tab", OleDbType.Char, 50, cmbCostTrunk.Text);
parm = cmd.Parameters.Add("@Tarifa", OleDbType.Char, 50, dgCosts.Columns[2].ToString());
parm.SourceVersion = DataRowVersion.Current;
daCijene.UpdateCommand = cmd;
try
{
daCijene.Update(Cijene);
}
catch (InvalidOperationException ioe)
{
System.Diagnostics.Debug.WriteLine(ioe.Message.ToString());
MessageBox.Show(ioe.Message);
}
}
Kod mene je situacija malo komplikovanija nego u onom primjeru.
Neznam tacno kako bi update binding grida radi , ali kontam da se update izvrsava ovako: adapter protrcava kroz grid i na osnovu kljuca kojg sam mu definisao preko OleDbParameter, updejtuje u polja koja sam definisao cmd.Parameters-om?
SELECT * FROM หน่วยงานหลัก WHERE ยสันติ LIKE 'โดย%'