ASP.NET ADO(ActiveX Data Objects for .NET) Objects Data Types:

In ADO.NET, data types play a crucial role in mapping between .NET types and database types. Here are some common .NET data types and their corresponding SQL Server data types when working with ADO.NET:

.NET Data Types and Corresponding SQL Server Data Types:

System.Int32 (int) - Integer
System.String (string) - VARCHAR, NVARCHAR, CHAR, NCHAR
System.DateTime (DateTime) - DATETIME, SMALLDATETIME
System.Decimal (decimal) - DECIMAL, NUMERIC
System.Double (double) - FLOAT, REAL
System.Single (float) - FLOAT, REAL
System.Boolean (bool) - BIT
System.Byte[] (byte[]) - VARBINARY, IMAGE
System.Guid (Guid) - UNIQUEIDENTIFIER
System.Object (object) - SQL_VARIANT

Example:

Let's see how you can use .NET data types with SqlCommand parameters:

using System.Data;
using System.Data.SqlClient;

// Example usage of .NET data types with SqlCommand parameters
SqlCommand command = new SqlCommand();
command.CommandText = "INSERT INTO Employees (Name, Age, JoiningDate, Salary) VALUES (@Name, @Age, @JoiningDate, @Salary)";
command.Parameters.Add("@Name", SqlDbType.NVarChar, 50).Value = "John Doe";
command.Parameters.Add("@Age", SqlDbType.Int).Value = 30;
command.Parameters.Add("@JoiningDate", SqlDbType.DateTime).Value = DateTime.Now;
command.Parameters.Add("@Salary", SqlDbType.Decimal).Value = 50000.00m;

.NET Data Types and Corresponding SQL Server Data Types:

System.Int32 (int) - Integer
System.String (string) - VARCHAR, NVARCHAR, CHAR, NCHAR
System.DateTime (DateTime) - DATETIME, SMALLDATETIME
System.Decimal (decimal) - DECIMAL, NUMERIC
System.Double (double) - FLOAT, REAL
System.Single (float) - FLOAT, REAL
System.Boolean (bool) - BIT
System.Byte[] (byte[]) - VARBINARY, IMAGE
System.Guid (Guid) - UNIQUEIDENTIFIER
System.Object (object) - SQL_VARIANT

Example:

Let's see how you can use .NET data types with SqlCommand parameters:

csharp

using System.Data;
        using System.Data.SqlClient;
        
        // Example usage of .NET data types with SqlCommand parameters
        SqlCommand command = new SqlCommand();
        command.CommandText = "INSERT INTO Employees (Name, Age, JoiningDate, Salary) VALUES (@Name, @Age, @JoiningDate, @Salary)";
        command.Parameters.Add("@Name", SqlDbType.NVarChar, 50).Value = "John Doe";
        command.Parameters.Add("@Age", SqlDbType.Int).Value = 30;
        command.Parameters.Add("@JoiningDate", SqlDbType.DateTime).Value = DateTime.Now;
        command.Parameters.Add("@Salary", SqlDbType.Decimal).Value = 50000.00m;

In this example:

We use various .NET data types like string, int, DateTime, and decimal.
Corresponding SQL Server data types are specified when adding parameters to the SqlCommand object.

Using appropriate .NET data types ensures proper type conversion and compatibility between your .NET application and the SQL Server database when working with ADO.NET.

Q3 Schools : India

Web Page Tutorial

ASP.NET Rozor

ASP Classes

ASP Reference

ADO Tutorial

ADO Objects

ASP.NET ADO(ActiveX Data Objects for .NET) Objects Data Types:

.NET Data Types and Corresponding SQL Server Data Types:

Example:

.NET Data Types and Corresponding SQL Server Data Types:

Example:

Q3 Schools : India

Online Complier

Website Development

Campus Learning