How do I get the width of a column using Type Datasets?

[=?Utf-8?B?TWlrZSBPS0M=?=]

How do I get the width of a column using Type Datasets? I don't want to know
the length of the data in the column, I want to know the width of the column.
In my code, if the column width is 50 characters, but a string with 55
characters tries to insert then I get runtime error. So, I want the width of
the column so I can cut out that number of (50) characters from the string.

[Cor Ligthert [MVP]]

Hi Mike,

Very easy (as you know it)

http://msdn2.microsoft.com/en-us/lib...th(VS.71).aspx

:-)

Cor

[Armin Zingler]

"Cor Ligthert [MVP]" <no************@planet.nlschrieb

Hi Mike,

Very easy (as you know it)

http://msdn2.microsoft.com/en-us/lib...th(VS.71).aspx

:-)

I thought so, too, but I've tried it and it returns -1 although it should be
50 (SQL Server, field type is nvarchar(50)). Do you know why? (Before, I
filled the dataset)
Armin

[Cor Ligthert[MVP]]

Armin,

AFAIK is only when you create the strongly dataset using the database tables
and you have set in the SQL servercolumn a limit.

Cor

[Cor Ligthert[MVP]]

Mike,

Armin let me think about your qeustion. If you databind such a column to by
instance a textbox you cannot even put in more than than length.

Cor

[Armin Zingler]

"Cor Ligthert[MVP]" <no************@planet.nlschrieb

Armin,

AFAIK is only when you create the strongly dataset using the
database tables and you have set in the SQL servercolumn a limit.

Hmm, I don't completely understand. The server column does have a limit.
Armin