firebird-net-provider

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

[James G. <Ja...@jn...>]

I am trying to insert records into a table using C#builder and firebird.net
provider 1.5. The code runs but when I check the table no updates have been
commited. Could someone let me know where I have gone wrong?

Thanks,

James Gill

   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();

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