How can I convert the SQL data types to csharp system types..

C

Champika Nirosh

Hi,

I want to convert ms sql data types to c# system types..

as an example

bit >>> System.Boolean
money >>> System.decimal

etc

Thanks,
Nirosh.
 
G

Guest

Hi,

Take a look at System.Data.SqlTypes under MSDN library. There is a list of
SQL server types and their corresponding SqlTypes. Then the list of SqlTypes
have member definitions which will show you how to extract the .NET typed
value from the Sql type.

HTH,
Chris.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert or Save file into SQL Server Database Table with C# Examplesand VB.Net Examples 2
Getting SQL data types using C# 5
TableAdapter Fill() returns SQL syntax error for data type bit 1
Convert string-type to a real type. 7
Get System Default Types 2
Which data type should I use for a money value? 5
[Q]Custom data types in C# 5
Can not seem to get Csharp to talk to the sql compact 3.5 database 5

Top