How to get datatype of a column in SQL Server using c#? [Resolved]

Posted by Shameer.Ali87 under C# on 3/26/2013 | Points: 10 | Views : 12901 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

hi all,

How to get a datatype of a column, present in table of a sql server..?
any Query/links will be help full...

thanks

shameer ali shaik

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Jayakumars on: 3/26/2013 [Member] [MVP] Bronze | Points: 50

0	hi try this procedure working good Exec sp_FindDatatype 'Employee' CREATE Proc sp_FindDatatype @TblName varchar(50) as SELECT COLUMN_NAME,DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=@TblName Donot Forgot mark as answer if it is useful to u. Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Shameer.Ali87, if this helps please login to Mark As Answer. \| Alert Moderator

hi

try this procedure working good

Exec sp_FindDatatype 'Employee'

CREATE Proc sp_FindDatatype
@TblName varchar(50)
as
SELECT COLUMN_NAME,DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=@TblName

Donot Forgot mark as answer if it is useful to u.

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Shameer.Ali87, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Santhi on: 3/26/2013 [Member] Starter | Points: 25

0	Hi Refer this link: This may help you: http://stackoverflow.com/questions/7470258/how-to-get-the-sqltype-of-a-column-in-a-datatable Thanks & Regards, Santhi .V Shameer.Ali87, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Shameer.Ali87 on: 3/26/2013 [Member] Starter | Points: 25

0	thanks Jayakumar, your answer worked for me.. I made a slight change as below, SELECT data_type FROM information_schema.columns WHERE table_name = 'T1' AND column_name = 'C1' keep going.. thanks shameer ali shaik Shameer.Ali87, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jayakumars on: 3/26/2013 [Member] [MVP] Bronze | Points: 25

0	hi Welcome Shameer share with your knowledge here. Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Shameer.Ali87, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts