Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

.MaxLength.ToString();

Posted on 2011-03-14
14
Medium Priority
?
350 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 336 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 1252 total points
ID: 35129534
-1 indicates that no MaxLength is specified.
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

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 1252 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 332 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 80 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 1252 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

715 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