Re: [Firebird-net-provider] using FbCommandBuilder & DataSet ---> Works now

[Thomas <ja...@ma...>]

Hi Carlos.

Now it works :-)

A type error. my mistake.


Complete code:

FbConnection connection =3D
FirebirdUtilities.FirebirdConnection.Instance.MyConnection;

FbDataAdapter dataAdapter =3D new FbDataAdapter();

FbTransaction transaction =3D connection.BeginTransaction();


dataAdapter.SelectCommand =3D new FbCommand("SELECT * FROM " + tableName,
connection, transaction);

FbCommandBuilder commandBuilder =3D new FbCommandBuilder(dataAdapter);


System.Data.DataSet dataSet;

dataSet =3D new System.Data.DataSet("SYSTEMSETTINGS");

dataSet.ReadXml(savePath);

dataSet.Tables[0].TableName =3D "SYSTEMSETTINGS";


dataAdapter.Fill(dataSet,"SYSTEMSETTINGS");

dataAdapter.InsertCommand =3D commandBuilder.GetInsertCommand();

dataAdapter.Update(dataSet, "SYSTEMSETTINGS");


transaction.Commit();



Thanks for you'r help/support.

Regards
Thomas



----- Original Message -----=20
From: "Carlos Guzm=E1n =C1lvarez" <car...@te...>
To: "Thomas" <ja...@ma...>
Cc: <fir...@li...>
Sent: Sunday, May 09, 2004 9:17 PM
Subject: Re: [Firebird-net-provider] using FbCommandBuilder & DataSet


> Hello:
>
> > Can anyone see the error?
> >
> DataSet.ReadXml is loading the data in a table called "Table", try this=
:
>
>     DataSet dataSet =3D new DataSet("SYSTEMSETTINGS");
>     dataSet.ReadXml(savePath);
>     dataSet.Tables[0].TableName =3D "SYSTEMSETTINGS";
>     dataAdapter.Fill(dataSet,"SYSTEMSETTINGS");
>     dataAdapter.InsertCommand =3D commandBuilder.GetInsertCommand();
>     dataAdapter.Update(dataSet, "SYSTEMSETTINGS");
>
> It should work, let me know if it works for you.
>
>
>
> --
> Best regards
>
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain
>