[Mono-list] anyone got bDataAdapter.Fill Method work?

[Igor Georgiev]

----- Original Message ----- 
From: "S Umadevi" <sUmadevi@novell.com>
To: <gory@alphasoft-bg.com>; <mono@b-lan.com>
Cc: <mono-list@lists.ximian.com>
Sent: Tuesday, July 13, 2004 7:59 AM
Subject: Re: [Mono-list] anyone got bDataAdapter.Fill Method work?

> Hi Denis/Igor
> Also can you send me the the database table schema ( for the table you are
querying), along with the values in the  first row.
I'm using Sybase SQL Anywhere 8, but i think database isn't important in
this case
( i found a similar problems in list with PostgreSQL provider and also
take a look on source of OdbcDataAdapter it doesn't do something special
public sealed class OdbcDataAdapter : DbDataAdapter, IDbDataAdapter
it only overrides a few methods : RowUpdatedEventArgs, RowUpdatingEventArgs,
Dispose, OnRowUpdated, OnRowUpdating
 )
so i think the problem is general somewhere
in dbDataAdapter.Fill
        {
         System.Data.Common.DataAdapter
            System.Data.Common.DbDataAdapter
               System.Data.Odbc.OdbcDataAdapter
        }
--- dbschema

CREATE TABLE "tariff"
(
"trf_sid" integer NOT NULL,
"trf_level" smallint NULL,
"trf_pred_level" integer NULL,
"trf_code" varchar(10) NOT NULL,
"trf_name" varchar(250) NOT NULL,
"trf_column1" numeric(4,1) NULL,
"trf_column2" numeric(4,1) NULL,
"trf_currency" integer NULL,
"trf_measure" integer NULL,
"trf_exp_date" date NULL,
"trf_sd_column1" smallint NULL,
"trf_sd_column2" smallint NULL,
"trf_beg_date" date NOT NULL,
PRIMARY KEY ("trf_sid")
)
--- load data
LOAD TABLE "Alpha_DBA"."tariff"
FROM 'C:\\work\\datadbs\\unload\\208.dat'
FORMAT 'ASCII'
QUOTES ON ESCAPES ON STRIP OFF
CHECK CONSTRAINTS OFF
DELIMITED BY ','
--- some data from unload\208.dat
1,0,,'01',****,0,,2,,,,,1997/01/01 00:00
2,0,,'02','****',,,,,,,,1997/01/01 00:00
3,0,,'03','****',,,,,,,,1997/01/01 00:00

--- Select command
 odbcSelectCommand1.CommandText =
   "SELECT trf_sid, trf_level, trf_pred_level, trf_code, trim(trf_name) AS
trf_name
    FROM tariff
    WHERE (trf_sid = 1)"



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.718 / Virus Database: 474 - Release Date: 09.07.2004