Displaying Records Using Three Tier Approach ..

Hello All,

I am testing three tier approach to display some records on asp.net page. For that i have created typed data set in visual studio and then i've created a .cs file in App_Code folder. Then am displaying the records on the .aspx page. SQL server is the database for the backend. Follwing is the code in app_code folder i.e.

using System;

using System.Data;

using System.Configuration;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

using System.Collections.Generic;

using System.IO;

public class Country

public Country() { }

private int _countryID;

private string _countryName;

public int CountryID{get{return _countryID;}set{_countryID = value;}}

public string CountryName{get{return _countryName;}set{_countryName = value;}}

public List<Country> AllCountries()

Country objCountry = new Country();

SqlConnection objConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["empConnectionString"].ConnectionString);

SqlCommand objCommand = new SqlCommand("select * from Country", objConnection);

objCommand.CommandType = CommandType.Text;

List<Country> list = new List<Country>();

SqlDataReader objReader = objCommand.ExecuteReader();

while (objReader.Read())

objCountry.CountryID = (int)objReader["CountryID"];

objCountry.CountryName = (string)objReader["CountryName"];

} return list;