Solved

.MaxLength.ToString();

Posted on 2011-03-14
14
348 Views
Last Modified: 2013-12-17
when I write

 row["Data_Length"] = col.MaxLength.ToString();

it return I get a value of -1.

what does -1 indicate?
0
Comment
Question by:Mr_Shaw
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 3
  • +2
14 Comments
 
LVL 7

Assisted Solution

by:mkobrin
mkobrin earned 84 total points
ID: 35129478
it indicates that your statemant is false. What are you trying to do?
0
 

Author Comment

by:Mr_Shaw
ID: 35129528
What is false about:

 row["Data_Length"] = col.MaxLength.ToString();

0
 
LVL 10

Assisted Solution

by:Nash2334
Nash2334 earned 313 total points
ID: 35129534
-1 indicates that no MaxLength is specified.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Mr_Shaw
ID: 35129543
How can I get the length of the data type in a column?
0
 
LVL 10

Expert Comment

by:Nash2334
ID: 35129584
The length of the column or the length of the data in the current row?
0
 
LVL 10

Assisted Solution

by:Nash2334
Nash2334 earned 313 total points
ID: 35129594
MaxLength only applies to text columns.  Other columns are limited by their data types.
0
 
LVL 12

Assisted Solution

by:Mohamed Abowarda
Mohamed Abowarda earned 83 total points
ID: 35129630
Check the variable "col", make sure it's associated with a column.
0
 

Author Comment

by:Mr_Shaw
ID: 35129646
How do I find out the lenght of the data type in the columns?
0
 
LVL 9

Assisted Solution

by:gery128
gery128 earned 20 total points
ID: 35129648
Col is a TextBox ? have you set the MaxLength property ?
0
 
LVL 12

Expert Comment

by:Mohamed Abowarda
ID: 35129687
You can determine a datatype at runtime using the following code:
For Each col As DataColumn In MyDatatable.Columns
    If col.DataType Is GetType(String) Then
        MsgBox(col.ColumnName & " is a string")
    End If
    If col.DataType Is GetType(Integer) Then
        MsgBox(col.ColumnName & " is an integer")
    End If
    ' etc...
Next

Open in new window

0
 

Author Comment

by:Mr_Shaw
ID: 35129762
Medo3337... how about getting the length?

eg. the string length
0
 
LVL 12

Expert Comment

by:Mohamed Abowarda
ID: 35129839
Here is SQL to get the field length:
SELECT 
sysobjects.name AS "TABLE_NAME", 
syscolumns.name AS "COLUMN_NAME", 
systypes.name AS "DATA_TYPE", 
syscolumns.LENGTH AS "LENGTH" 
FROM
         	sysobjects
INNER JOIN
 		syscolumns ON sysobjects.id = syscolumns.id 
INNER JOIN
		systypes ON syscolumns.xtype = systypes.xtype 
WHERE
(sysobjects.xtype = 'U') andsysobjects.name = 'MyTableName' 
ORDER BY sysobjects.name, syscolumns.colid

Open in new window

0
 
LVL 10

Accepted Solution

by:
Nash2334 earned 313 total points
ID: 35129853
If you want the length of a string in a DataColumn that is of type string for a specific DataRow, you need to access the row and column specifically:

myDataRow[0][0].ToString().Length

Will give you the length of the data in cell 0 of row 0.  If it's nullable you should do a null check first.
0
 

Author Closing Comment

by:Mr_Shaw
ID: 35129967
thanks
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from http://seleniumhq.org Go to that link and select download selenium in the right hand column That will then direct you to their download page. From that p…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question