Fill datatable through DataAdapter using C# and Stored Procedure

The below code will do so

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;

namespace TestNS
{
    class Program
    {
        static void Main(string[] args)
        {
            

            try
            {

                string ConnectionPath = System.Configuration.ConfigurationManager.ConnectionStrings["DBString"].ToString();
                SqlDataAdapter da = new SqlDataAdapter();
                DataTable dt = new DataTable();
            

                using (var sqlCon = new SqlConnection(ConnectionPath))
                { 
                    using (SqlCommand cmd = new SqlCommand("SP_Name", sqlCon))
                    {
                        sqlCon.Open();
                        da.SelectCommand = cmd;
                        da.Fill(dt);
                    }
                }            
            }
            catch (Exception ex)
            {
            	throw ex;
            }
        }
    }    
}

First we are creating a connection string which we are passing to a SQL Command Object along with the SP_Name. Then open connection , fetch the record and fill the data table via data adapter