ADO.NET SqlDataAdapter Class | DataTable & DataSet In ADO.NET | ADO.NET | Part-1

 using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Data.SqlClient;

using System.Configuration;

using System.Data;

namespace SqlDataAdapterDemo

{

    internal class Program

    {

        static void Main(string[] args)

        {

            string cs = ConfigurationManager.ConnectionStrings["dbcs"].ConnectionString;

            SqlConnection con = new SqlConnection(cs);

            SqlDataAdapter sda = new SqlDataAdapter("select * from employee_tbl",con);

            DataSet ds = new DataSet();

            sda.Fill(ds);

            foreach (DataRow row in ds.Tables[0].Rows)

            {

                Console.WriteLine("{0} {1} {2} {3} {4} {5}", row[0],row[1],row[2],row[3],row[4],row[5]);

            }

            Console.ReadLine();

        }

    }

}

Above File is SqlDataAdapterDemo\Program.cs

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

    <startup> 

        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.7.2" />

    </startup>

<connectionStrings>

<add name="dbcs" connectionString="Data Source=.\SQLEXPRESS;initial Catalog=ado_db;Integrated Security=true;" providerName="System.Data.SqlClient"/>

</connectionStrings>

</configuration>

Above File is SqlDataAdapterDemo\App.config