How to connect ADO.NET code to SQL Server Database and retrieve data?

In this article we will discuss, to connect ADO.NET code to SQL Server Database and retrieve data. We are using SQLConnection,SQLCommand and SQLDataReader classes are present in System.Data.SqlClient namespace. System.Data.SqlClient is also called as .Net data provider.

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ShoppingZone"].ConnectionString);
                SqlCommand cmd = new SqlCommand("Select * from Employee", con);
                con.Open();
                SqlDataReader rdr = cmd.ExecuteReader();
                GridView1.DataSource = rdr;
                GridView1.DataBind();
                con.Close();
            }
        }

Output: