From: George L. <ge...@ra...> - 2003-04-02 05:30:35
|
Pavol, thank you. Actually, now I can update ONCE the data in my database. The second time I try to DataAdapter.Update I get the same error message. If I close the application and start it again, it works just fine. this is a part of code: { conn.ConnectionString=myConnectionString; TestDA.SelectCommand = new FbCommand("SELECT id_judet, Denumire_judet FROM judete"); TestDA.SelectCommand.Connection=conn; if (conn.State == ConnectionState.Closed) { conn.Open(); } txn = conn.BeginTransaction(); TestDA.SelectCommand.Transaction=txn; FbCommandBuilder custCB = new FbCommandBuilder(TestDA); TestDA.Fill(dataSetAdmin,"Judete"); this.dataGrid1.DataSource=this.dataSetAdmin.Tables["Judete"]; this.dataGrid1.Refresh(); } private void button_Update_Click(object sender, System.EventArgs e) { try { TestDA.Update(dataSetAdmin.Tables["Judete"]); txn.Commit(); } catch (System.Exception eUpdate) { System.Windows.Forms.MessageBox.Show(eUpdate.Message); } } George "Pavol STAREK" <pa...@st...> wrote in message news:3E8...@st...... > George LAZAR wrote: > > >Hello all! > > > >I try to use the Firebird.Net provider. > > > >i have a connection, a transaction and a data adapter. > >i have also a command builder. > > > >when i try to update the data into the database using the dataadapter, i > >receive the error message: > >"Command Connection is not equal to Transaction Connection" . > > > >any ideea? > > > >thank you > > > > > > > > > > > hi, > > you have to post us code, > > but i think, that problem is here: > probably you created trancaction by new clausule... Tray to create it by > FbConnction.BeginTransaction(). > > p. > > >============================================= > >George LAZAR > >============================================= > > > > > > > > > >------------------------------------------------------- > >This SF.net email is sponsored by: ValueWeb: > >Dedicated Hosting for just $79/mo with 500 GB of bandwidth! > >No other company gives more support or power for your dedicated server > >http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/ > >_______________________________________________ > >Firebird-net-provider mailing list > >Fir...@li... > >https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > > > > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: ValueWeb: > Dedicated Hosting for just $79/mo with 500 GB of bandwidth! > No other company gives more support or power for your dedicated server > http://click.atdmt.com/AFF/go/sdnxxaff00300020aff/direct/01/ > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |