----- Original Message ----- From: "S Umadevi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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 _______________________________________________ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list