field properties aren't there

[rodchar]

hey all,
I'm doing the following:
SqlCommand mycmd = new SqlCommand(sqlText, conn);
SqlDataAdapter da = new SqlDataAdapter(mycmd);
DataTable tbl = new DataTable();
da.Fill(tbl);

Well, when I check tbl.Columns[x].MaxLength all columns show -1. I checked
and there are columns and I can do tbl.Columns[x].ColumnName. Can someone
please explain?

thanks,
rodchar

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Explain what?

From MSDN:
The maximum length of the column in characters. If the column has no maximum
length, the value is -1 (default).


What were you expecting?

 

[rodchar]

Actually, in the database, the field does have a length specified.

Hi,

Explain what?

From MSDN:
The maximum length of the column in characters. If the column has no maximum
length, the value is -1 (default).


What were you expecting?

--
Ignacio Machin
http://www.laceupsolutions.com
Mobile & warehouse Solutions.

hey all,
I'm doing the following:
SqlCommand mycmd = new SqlCommand(sqlText, conn);
SqlDataAdapter da = new SqlDataAdapter(mycmd);
DataTable tbl = new DataTable();
da.Fill(tbl);

Well, when I check tbl.Columns[x].MaxLength all columns show -1. I checked
and there are columns and I can do tbl.Columns[x].ColumnName. Can someone
please explain?

thanks,
rodchar

 

[Lasse Vågsæther Karlsen]

Actually, in the database, the field does have a length specified.

Perhaps the database provider code doesn't read those values?
Did you check if the columns/rows contains any data?

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Actually, in the database, the field does have a length specified.

It might have, but the returned type is string which has no type. I checked
it on a CHAR(10) column and it did return String and MaxLength was -1

 

[rodchar]

thanks everyone for the help.
rod.