what is the suitable .NET datatype for SQL Server 2000 datatype?

Hot Topic

Relation between DataTables
DataGridView + DataAdapter Edit Weirdness
Provider error while reading DBF file
.Net 2.0 release version breaks VS 2005b2?
Problem with BeginReceive
How to configure Default AppDomain via Hosting Interfaces?
where can i get information on web services, from the basics
.NET 2.0 WebBrowser HTML editor
Trouble getting value from xml file
Retrieving CLOB data from Informix

.NET Development

Problem in web service
Performance test - Web Services vs. .NET Remoting
DataSet object expression
How to connect to a Samba share using C#?
What is remoting?
.Net Oracle process error
Mht Email (Html Archive)
asp remoting
Cannot connect to MSDE in VB.net
Microsoft dBASE Driver - numeric percision ???

what is the suitable .NET datatype for SQL Server 2000 datatype?

Hi Everyone,

I have a SQL Server 2000 table named as Transfer and its field are datetime, & money datatype. Now I want to write dataset in VC++ .NET to add row to my table. Which datatype is suitable in .NET for SQL datatype which I created.

Thanks in Advance
Jose




Answer this question

what is the suitable .NET datatype for SQL Server 2000 datatype?

  • djs1

    Take a look at the System.Data.SqlTypes namespace. All data types of SQL Server can be found there, and the classes provide a mapping between the CLR and the SQL data types.
    A datetime field maps of course to System.DateTime, and money is mapped to System.Decimal.

  • what is the suitable .NET datatype for SQL Server 2000 datatype?
Answer this question