> Hallo everybody, i try to do something with firebird & .NET, and I'm stuck on this problem.
>
> I'm trying to explain as simple as possible, you should only need a database table, a trigger and little bits of code to understand my wish.
>
>
> The table:
>
> A table with this colums:
> tabNodeLang
> [PK] IDNode, INTEGER
> Displaytext, varchar(50)
> Changes, Timestap
>
> A trigger:
> (it sets the current Time (from Server) on every update
>
> CREATE TRIGGER TABNODELANG_TIMESTAMP FOR TABNODELANG
> ACTIVE BEFORE INSERT OR UPDATE
> POSITION 0
> AS
>
> BEGIN
> /* Trigger body */
> NEW.Changes = CURRENT_TIMESTAMP;
> END;
>
> The code:
>
> The form is quite simple, it has 2 buttons, button3 loads the data, button4 saves the data, and a Datagrid (dataGrid1) shows & edits the data.
>
>
> This code loads data from the Database
>
> private void button3_Click(object sender, RoutedEventArgs e)
> {
> FbDataAdapter da = new FbDataAdapter("select IDNODE, DISPLAYTEXT, CHANGES from tabnodelang", connection);
>
> ds = new DataSet();
> da.Fill(ds, "tabnodelang");
> dt = ds.Tables["tabnodelang"];
>
> this.dataGrid1.AutoGenerateColumns = true;
> this.dataGrid1.ItemsSource = dt.DefaultView ;
> this.dataGrid1.DataContext = dt;
> }
>
>
> This code saves the changed data
>
> private void button4_Click(object sender, RoutedEventArgs e)
> {
> FbDataAdapter da = new FbDataAdapter("select * from tabnodelang", connection);
>
> DataTable dt = ds.Tables["tabnodelang"];
> FbCommandBuilder fbc = new FbCommandBuilder(da);
> int i;
> da.UpdateCommand = fbc.GetUpdateCommand();
> i=da.Update(dt);
> label1.Content = i + " rows updatet";
> }
>
>
> The problem:
> When I change data in the grid and press the save button (=button4_Click), the data is saved correctly, but I don't see the new timestamp in the "changes" column which is set in the trigger.
>
> What I want:)
> When I save data with da.Update(dt), the new timestamps should be read back into the dataset, and shown in the Datagrid.
>
> Is this possible, can someone help me?

Only by re-querying the table/record.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/