Re: Re: [Firebird-net-provider] Cannot update the data on database

2005-11-07 Thread ille7
Hi, This code NOT update the underlying database. This code can't update your database because your data in the datgrid are not changed! That's the main reason. the HasChanged property of the fbDataset1 return false. Only if this property returns true the database will be update. What is

Re: [Firebird-net-provider] Cannot update the data on database

2005-11-07 Thread Arn
Hi. Sorry to bother the List, but I cannot resolve what seems to me a too much simple issue. this is a NOT WORKING snippet: private void Grid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { fbConnection1.Open(); FirebirdSql.D

Re: [Firebird-net-provider] Cannot update the data on database

2005-11-07 Thread Arn
[EMAIL PROTECTED] wrote: Hello: FirebirdSql.Data.Firebird.FbTransaction Tran = Connessione.BeginTransaction(); Could you check here the HasChanges property of the DataSet please ?? FbDataAdapter1.Update( fbDataset1 ); Tran.Commit();

Re: [Firebird-net-provider] Cannot update the data on database

2005-11-07 Thread [EMAIL PROTECTED]
Hello: > FirebirdSql.Data.Firebird.FbTransaction Tran = >Connessione.BeginTransaction(); Could you check here the HasChanges property of the DataSet please ?? > FbDataAdapter1.Update( fbDataset1 ); > Tran.Commit(); > fbConnection1. Close(); >

Re: [Firebird-net-provider] Cannot update the data on database

2005-11-06 Thread Arn
Hi Arn, I think your mistake is that you call the AcceptChanges()-Method from your DataGrid BEFOR you update the data! In this case the Update()-Methode can't find any changes in your DataGrid because the RowState Property of all DataRows was set to unchanged. Call first the Update()-Methode

Re: [Firebird-net-provider] Cannot update the data on database

2005-11-06 Thread ille7
Hi Arn, I think your mistake is that you call the AcceptChanges()-Method from your DataGrid BEFOR you update the data! In this case the Update()-Methode can't find any changes in your DataGrid because the RowState Property of all DataRows was set to unchanged. Call first the Update()-Methode an

[Firebird-net-provider] Cannot update the data on database

2005-11-06 Thread Arn
Hi All. I can open the connection and SEE the data but if Edit them cannot save changes in the underlying database. I have read the forum, but no answer ... Here is the code I use in UpdateCommand of a Grid. It fires After i push the Update button of the grid. private void Grid1_Update