First Program in ADO.NET

#aspnetcore #adodotnet #csharp

You will learn how to create ADO.NET commands for the console, windows forms, and database connections in this lesson. This programmer serves only as a demonstration of how ADO.NET functions. You will learn everything there is to know about ADO.Net in the ensuing chapters.

First Create Database
Open Visual Studio.

Go to Server Explorer. If Server Explorer is not opened go to View Server Explorer.
Right click on Data Connections and select Create New SQL Server Database.
Fill details like this.
Server Name: .\SQLEXPRESS
Select Windows Authentication
Database Name: Test1
Click OK.

Create Table User in Database

Create table Users
(
    [Id] [int] IDENTITY(1,1) NOT NULL primary key,
    [Name] [varchar](100) NULL,
    [Address] [varchar](100) NULL,
    [PhoneNo] [varchar](100) NULL
);

Add Data in Table
Add some data in table using SQL data table Interface

Get the Database Connection String
Your tables and database are now ready. Your connection string is in the database's properties.

Right Click on Database Properties
The database you currently have has a table and a connection string. The next step is to establish a database connection and use ADO.Net Commands to fetch the records.

Create the C# Console Application
Create the C# Console application for writing the ADO.NET Code

Write the Code in Console Application

using System.Data.SqlClient;

string ConString = @"Server=localhost\SQLEXPRESS;Database=Test1;Trusted_Connection=True;";
SqlConnection con = new SqlConnection(ConString);
string SqlQuery = "Select * from Users";
con.Open();
try
{
    SqlCommand sqlCommand = new SqlCommand(SqlQuery,con);
    SqlDataReader reader = sqlCommand.ExecuteReader();
    while (reader.Read())
    {
        Console.WriteLine(reader[0].ToString() + "\n" + 
            reader[1].ToString() + "\n" + reader[2].ToString()+"\n"
            +reader[3].ToString());
    }
}
catch (Exception)
{
    throw;
}
finally { 
    con.Close();
    Console.ReadKey();
}

Output Of the Code
Now you can see the Records From the Database Using Ado.NET