string connectionString = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]; SqlConnection sqlConn = new SqlConnection(connectionString); sqlConn.Open(); string strSql = "Select * From Capital order by CapitalID"; SqlCommand sqlCmd = new SqlCommand(strSql, sqlConn); SqlDataReader dtrProvince = sqlCmd.ExecuteReader();