//Data Access using DataReader
        try
        {
            //Make a connection to database
            SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["DashboardConnectionString"]);
            string cmdtext = "select EmployeeNo,Name,Email from tab1";
            conn.Open();
            SqlCommand cmd = new SqlCommand(cmdtext, conn);
            //Excute query
            SqlDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                //do something here
            }
            
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);

        }