marzena escribio:
> Hi,
> 
> I am using Provider 2.0 RC 5 downloaded on Friday last week. I'm sure this
> is not new bug previous versions (at least RC3 and RC4) was doing it the
> same way.
> 
> Marek
> 
> 
>> Date: Wed, 7 Jun 2006 09:14:53 -0700
>> From: "JCardinal" <[EMAIL PROTECTED]>
>> Subject: Re: [Firebird-net-provider] Bug in FbDataAdapter exception
>>      handling
>> To: [email protected]
>> Message-ID: <[EMAIL PROTECTED]>
>>
>> Which version of the provider are you using? I reported a 
>> long time ago that 
>> it was throwing a null reference exception instead of 
>> reporting the non 
>> existant column in an exception and I thought it was fixed.
>>
> 
> 
> 
> OK, will send test case today.
> 
> 
>> Date: Wed, 07 Jun 2006 18:10:39 +0200
>> From: Carlos Guzm?n ?lvarez <[EMAIL PROTECTED]>
>> Subject: Re: [Firebird-net-provider] Bug in FbDataAdapter exception
>>      handling
>> To: "For users and developers of the Firebird .NET providers"
>>      <[email protected]>
>> Message-ID: <[EMAIL PROTECTED]>
>>
>> Hello:
>>> The conclusion:
>>> 1) Could you please correct the exception handling in this 
>> method in order
>>> to obtain always the correct exception with correct message?
>>>   
>> I have committed a change to CVS hope it's correct, let me 
>> know if not.
>>> 2) And next - when I found the "correct" message "dataType' 
>> argument cannot
>>> be null. Parameter name: dataType" I was bit confused 
>> because in my program
>>> is no such parameter! IMHO there must be another bug when 
>> generating this
>>> exception message.
>>>   
>> Could you send a tets case please.
>>
>>
>> -- 
>> Carlos Guzm?n ?lvarez
>> Vigo-Spain
> 
> 
> 
> 
> _______________________________________________
> Firebird-net-provider mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> 
(Sorry for my bad English)

What was happen with this problem?
Becose I'm using 1.7 Provider, and I have a problem that seems to be 
related:

Unhandled Exception: System.NullReferenceException: Referencia a objeto 
no establecida como instancia de un objeto.
    at FirebirdSql.Data.Firebird.FbDataAdapter.Update(DataRow[] 
dataRows, DataTableMapping tableMapping)
    at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)
    at PF.WinForms.Usuario.Form1..ctor(MmConnection conexion)
    at sigeme.ContextoAplicacion..ctor(Boolean loginAutomatico)
    at sigeme.ContextoAplicacion.Main(String[] args)

And my code is this:

dataadapter.SelectCommand = new FbCommand("Select NOMBRE, TIPO, VALOR 
from SPESTADOSARTICULO(@IdArticulo)",connection);
                        
FbParameter parameterTmp = 
dataadapter.SelectCommand.Parameters.Add("@IdArticulo", FbDbType.Integer);
parameterTmp.Value = 1118;

dataadapter.UpdateCommand = new 
FbCommand("CAMBIARESTADOARTICULO",connection);
dataadapter.UpdateCommand.CommandType = CommandType.StoredProcedure;
dataadapter.UpdateCommand.Parameters.Add("@IdArticulo", 
dataadapter.SelectCommand.Parameters["@IdArticulo"].Value);

parameterTmp = dataadapter.UpdateCommand.Parameters.Add("@NombreEstado", 
FbDbType.VarChar, 20);
parameterTmp.SourceColumn = "NOMBRE";
parameterTmp.SourceVersion = DataRowVersion.Original;

parameterTmp = 
dataadapter.UpdateCommand.Parameters.Add("@Valor",FbDbType.VarChar,20);         
parameterTmp.SourceVersion = DataRowVersion.Current;
parameterTmp.SourceColumn = "VALOR";

dataadapter.Fill(datatable);

datatable.PrimaryKey = new DataColumn[] {datatable.Columns["NOMBRE"]};

datatable.Rows[0]["VALOR"] = "0";

dataadapter.Update(datatable);

Well, maybe my code is bad, please correct me.

Thanks, and sorry for my English again.

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to