Re: [Firebird-net-provider] Trying to use a dataset to update a table.

[Carlos G. A. <car...@te...>]

Hello:


>    fbConnection1.Open();
>    FirebirdSql.Data.Firebird.FbCommandBuilder builder = new
> FirebirdSql.Data.Firebird.FbCommandBuilder(fbDataAdapter1);
>    fbDataAdapter1.Fill(dataSet1,"TABLE1");
>    DataTable TABLE1 = dataSet1.Tables["TABLE1"];
>    for(int a = 0;a <= 100;++a)
>    {
>     DataRow newrow = TABLE1.NewRow();
>     newrow["NAME"] = "Test Me "+a.ToString();
>     newrow["IDNUMBER"] = a;
>     newrow["FIELD1"] = a;
>     TABLE1.Rows.Add(newrow);
>    }
>    fbCommand2 = builder.GetUpdateCommand();
>    textBox1.Text = fbCommand2.CommandText;
>    fbDataAdapter1.Update(TABLE1);
>    fbConnection1.Close();


Huummm try this:

fbConnection1.Open();
FbTransaction transaction = fbConnection1.BeginTransaction();	<-----
FirebirdSql.Data.Firebird.FbCommandBuilder builder = new
FirebirdSql.Data.Firebird.FbCommandBuilder(fbDataAdapter1);
fbDataAdapter1.Fill(dataSet1,"TABLE1");
DataTable TABLE1 = dataSet1.Tables["TABLE1"];
for(int a = 0;a <= 100;++a)
{
	DataRow newrow = TABLE1.NewRow();
	newrow["NAME"] = "Test Me "+a.ToString();
	newrow["IDNUMBER"] = a;
	newrow["FIELD1"] = a;
	TABLE1.Rows.Add(newrow);
}
fbCommand2 = builder.GetUpdateCommand();
textBox1.Text = fbCommand2.CommandText;
fbDataAdapter1.Update(TABLE1);

transaction.Commit();	<-----

fbConnection1.Close();

or


fbConnection1.Open();
FirebirdSql.Data.Firebird.FbCommandBuilder builder = new
FirebirdSql.Data.Firebird.FbCommandBuilder(fbDataAdapter1);
fbDataAdapter1.Fill(dataSet1,"TABLE1");
DataTable TABLE1 = dataSet1.Tables["TABLE1"];
for(int a = 0;a <= 100;++a)
{
	DataRow newrow = TABLE1.NewRow();
	newrow["NAME"] = "Test Me "+a.ToString();
	newrow["IDNUMBER"] = a;
	newrow["FIELD1"] = a;
	TABLE1.Rows.Add(newrow);
}
fbCommand2 = builder.GetUpdateCommand();
textBox1.Text = fbCommand2.CommandText;
fbDataAdapter1.Update(TABLE1);
builder.Dispose();	<------
fbConnection1.Close();




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain