Get data type of a SQL Server column selected from dropdown using C#

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

hi,
I need to determine the type of a column selected from dropdown list from a SQL Server database using C#.

my question is
How to fetch the dropdownlist value and determine its datatye from SQL server

how to implement the scenario
help me with some examples or pseudo code
Please Help

Regards
Priyanka

Posted 2-Sep-13 21:15pm

Priyanka Bhagwat

Add a Solution

Comments

Mahesh Bailwal 3-Sep-13 3:22am

what you have tried so far?

Priyanka Bhagwat 3-Sep-13 3:28am

hi,,i have tried stuff from this page.but not able to apply it for my dropdown value
http://stackoverflow.com/questions/9712698/get-data-type-of-a-sql-server-column-using-c-sharp

Nissim Salomon 3-Sep-13 3:26am

Hi, MSSQL expose a variety set of views called INFOMATION_SCHEMA you can used the INFOMATION_SCHEMA.COLUMNS in order to retrieve the column data

1 solution

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)

OriginalGriff · Accepted Answer · 2013-09-02T21:27:00

Solution 1

Try:

SQL

SELECT column_name, data_type, is_nullable, character_maximum_length FROM information_schema.COLUMNS WHERE table_name='myTable'

Posted 2-Sep-13 21:27pm

OriginalGriff

Comments

Raja Sekhar S 3-Sep-13 3:31am

+5!

Priyanka Bhagwat 3-Sep-13 3:35am

hithanks
but i want the datatype of particular column
how to find that??

idenizeni 3-Sep-13 3:41am

Just add to the WHERE clause a condition for the column you want...

SELECT column_name, data_type, is_nullable, character_maximum_length FROM information_schema.COLUMNS WHERE table_name='myTable' AND column_name='myColumnName'

Raja Sekhar S 3-Sep-13 3:41am

u can use where Column_name='columnName' and Table_name='TableName'

OriginalGriff 3-Sep-13 3:41am

You can either use the above to find the column name and match it against the drop down selected value, or you could add a WHERE clause to the query to return only the column you are interested in. Depends on how your mind works, and how you prefer to code. Either way don't forget to check the the case where the column is not found!

Priyanka Bhagwat 3-Sep-13 4:08am

ya i tried this
SELECT column_name, data_type, is_nullable, character_maximum_length
FROM information_schema.COLUMNS WHERE table_name='Country_master' and column_name='CountryCode'
but it is giving me error
Could not find stored procedure 'CountryCode'.

Priyanka Bhagwat 3-Sep-13 4:13am

Hey ,
thank you
its working fine

OriginalGriff 3-Sep-13 4:17am

You're welcome!