asp.net field length

[marcusmco]

Hello,

I have a dataset that was loaded from the database and I am interested in finding the varchar length of a certain field. Is that possible using the dataset? I have tried to use the GetType function but I cannot find the length of the varchar field...

Regards,
Marcus

 

[cjelec]

Try the following:

  'Length on a String type field:
  DataSet.Tables("TName").Rows(1).Item("Text").Length

Item returns an Object that can be anything, so you have GetType to check what type it is. But because you know that its a String, you can access is properties and functions without even seeing them (as in the example above). You could set it to a String, if that helps:

  Dim Str As String
  Str = DataSet.Tables("TName").Rows(1).Item("Text").Length

 

[marcusmco]

Sorry I was not being clear about what I wanted.

I was looking for the maximum length of the field. It is a varchar field and I would like to be able to find what is within the brackets when defining the field. E.g. if it in the database says varchar(50) I would like to be able to get 50 back.

 

[cjelec]

I did write that first, then deleted it and put the value length.

Datarow.Tables("TName").Columns("Text").MaxLength()

Hope this one helps

 

[cjelec]

Sorry again, I should read posts better.

How are you connecting to the database? And which database are you using (sql server)?

 

[cjelec]

I'm on a post marathon

If the answer to the above post was yes to sql, then does this help you:

http://blog.sqlauthority.com/2007/06/20/sql-server-find-length-of-text-field/