How to retrieve the datatype SIZE from the datatable

Question

0.00/5 (No votes)

See more:

how to retrieve the column datatype size form the data table.

thanks in advance :)

What I have tried:

Dim tblProducts as DataTable
.
.
.

For i As Integer = 0 To tblProducts.Rows.Count
                     Dim d = tblProducts.Columns(i).DataType ' here How to retrieve the datatype size ?? :(
        Next

Posted 7-Jan-18 21:32pm

ketan Ram Patil

Updated 9-Jan-18 6:45am

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kornfeld Eliyahu Peter · Accepted Answer · 2018-01-07T22:09:00

Solution 1

Do you mean the data type for column 'size'?

VB

tblProducts.Columns["size"].DataType

Also! Columns is a collection of the columns (surprisingly) and has nothing to do with the number of rows!!!
If you want to iterate over the columns use a loop like this:

VB

For Each column In tblProducts.Columns
  ' Your code here
Next

Posted 7-Jan-18 22:09pm

Kornfeld Eliyahu Peter

Comments

ketan Ram Patil 8-Jan-18 4:18am

thanks for your valuable replay. :)

But i want to know the size of each column Data type.

eg.if column Product contain string data type then how to retrive the actual size of string data type.

i want to create a new table from the datatable.

so to create a new table i am able to retrieve the column name and data type but not able retrieve actual datatype size :( ????????

Kornfeld Eliyahu Peter 8-Jan-18 4:39am

Do you mean if in the SQL you declared CHAR(30) than you want to get 'String' and '30'?
You can not! DataTable is a generic type to work with any kind of data source and works on the minimal level...
But - to contradict that general nature - for text (string variant) types there is a MaxLength value, however... not all provides will set that value, so you may not build on it. You also have to get the schema info when filling the data...
Adapter.Fill(...);
Adapter.FillSchema(...);

Richard Deeming · Accepted Answer · 2018-01-09T06:45:00

Solution 2

To retrieve the size of a string column, use the MaxLength[^] property:

VB.NET

Dim s As Integer = tblProducts.Columns(i).MaxLength

Posted 9-Jan-18 6:45am

Richard Deeming