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

[Guest]

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/library/system.data.datacolumn.maxlength(VS.71).aspx



Cor

 

[Armin Zingler]

Hi Mike,

Very easy (as you know it)

http://msdn2.microsoft.com/en-us/library/system.data.datacolumn.maxlength(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]

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