Is there any way to findout the datatype of any column in a datatable?

Question

0.00/5 (No votes)

See more:

Suppose, I have a dataset which has one datatable. I want to know the datatype of every columnname like Is it numeric or varchar (string)?

Is there any way to identify the datatype of a column ?

Posted 27-Mar-14 0:02am

sachi Dash

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 · Answer 1 · 2014-03-27T00:05:00

Solution 1

DataSet->Tables->DataTable->Columns->DataColum->DataType

http://msdn.microsoft.com/en-us/library/system.data.datacolumn.datatype.aspx[^]

Posted 27-Mar-14 0:05am

Kornfeld Eliyahu Peter

BELGIUMsky · Answer 2 · 2014-03-27T00:10:00

Solution 2

Edit: as comments say it doesn't work. just wanted to help.

You can use something like this

C#

foreach (DataRow row in dataSet2.Tables[0].Rows)
{
    foreach (DataColumn col in dataSet2.Tables[0].Columns)
    {
        if(row[col].GetType() == typeof(int)){
            row[col] = 0;
        }
        if (row[col].GetType() == typeof(string))
        {
            row[col] = "no data";
        }
    }
}

Posted 27-Mar-14 0:10am

BELGIUMsky

Updated 30-Mar-14 18:43pm

v2

Comments

Kornfeld Eliyahu Peter 28-Mar-14 5:54am

GetType() returns the type of the .NET class and not the SQL data type...for that there is property named DataType!

BELGIUMsky 28-Mar-14 6:01am

col.DataType you mean?

BELGIUMsky 28-Mar-14 10:53am

the people that downvote if you can do it better why don't you give him an answer.
No wonder people just delete there answers on this site

Kornfeld Eliyahu Peter 30-Mar-14 4:28am

I mean DataColumn::DataType, and I didn't downvoted you (even your answer is wrong), and I did give my solution just before you...