Displaying Records Using Three Tier Approach ..

Question

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;

objConnection.Open();

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

SqlDataReader objReader = objCommand.ExecuteReader();

while (objReader.Read())

{

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

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

list.Add(objCountry);

} return list;

}

}

Now i am displaying thre records on an object data source at .aspx page. The problem is that it only displays the last row in the database repeatedly on the gridview control.

Could any buddy sort out the problem

Regards,

Ghaffar