Getting the column length in my DataSet (untyped)

  • Thread starter Thread starter Erwin Pant via DotNetMonster.com
  • Start date Start date
E

Erwin Pant via DotNetMonster.com

Hi,

I'm uploading .dbf and MS Access tables into my DataSet (untyped) and I
wanted to know what would be the best way to get the column lengths once
the data has been placed in my DataSet. I am not using typed DataSets
because theses tables come from clients and the layouts are always
different. I've tried using the WriteSchemaMethod which creates my .XSD
file, but the column lengths are not there. The only other solutions that
I can think of is for .dbf files, I can extract the column length from the
header and for my Access tables, I can create an Access object and read the
system tables. But I want to know if there is an easier alternative when
working with untyped DataSets ?

Thanx !!!

E
 
Erwin,

What do you mean with the column.lengths.

A dataset holds tables, which have datarows, which have items. The
description of the items is done using the columns, while the relations
between the tables is done in relations.

All items are objects however can in fact hold only strings when they are
not described in the columns. The columns can be described using the
standard system types.

However I never saw a column length.

Or is it the count which tells the number of columns in a table?

So please clarify more.

Cor
 
Back
Top