Show data in window application through sqlserver connectivity using App.config file in ASP.Net with C#

*These namespaces are must be required for SqlServer Connectivity in your web form:-

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

App.config File

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

<configuration>

  <configSections>

  </configSections>

  <appSettings>

    <add key="ConnectionString" value="Data Source=PRADEEP-HP;Initial Catalog=Decofloore2;User ID=User_006;Password=user006"/>

  </appSettings>

</configuration>

Form1.cs

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

namespace DemoWindowApplication

{

    public partial class Form3 : Form

    {      

        public Form3()

        {

            InitializeComponent();

        }

        private void btnShow_Click(object sender, EventArgs e)

        {

            string StrCon = ConfigurationManager.AppSettings["ConnectionString"];

            SqlConnection SqlCon = new SqlConnection(StrCon);

            string SqlQuery = "Select * from ShowOnePage";

            SqlCommand SqlComm = new SqlCommand(SqlQuery, SqlCon);

            SqlCon.Open();

            SqlDataReader dr;

            dr = SqlComm.ExecuteReader();

            BindingSource bs = new BindingSource();

            bs.DataSource = dr;

            dataGridView1.DataSource = bs;

        }

    }

}

https://www.youtube.com/channel/UCKLRUr6U5OFeu7FLOpQ-FSw/videos