Binding List to GridView

[sangramkp]

Hi, I am Using a List to store the data retrived from database... My code goes as this Service Layer Method: public List GetCities() { DataSet ds= cdb.GetCities(); List city = new List(); foreach (DataRow row in ds.Tables[0].Rows) { city.Add(new City(row["city_id"].ToString(), row["city_name"].ToString(), row["state_id"].ToString(), row["city_classification_id"].ToString())); } return city; } In Application Layer: I am Caliing the method as below GridView1.DataSource = cs.GetCities(); GridView1.DataBind(); It works fine but .... The Columns are not coming in the same order as in Database i.e... CityID, CityName, StateID, cityClassificationID. The column order comes in as cityClassificationID,CityId, CityName, StateID. But I want them in the same Order i.e CityID, CityName, StateID, CityClassificationID... How to accomplish this....:rose:

Sangram (A battle with self) Life is simple, we are the ones makes the living difficult

[Christian Graus]

Turn off auto columns and define them yourself in the order you want.

Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

[N a v a n e e t h]

Strange, Why don't you return the DataTable object from dataset ? Any way you are iterating through all rows, or is there any other reason that you are specific with List ?

---

My Website | Ask smart questions

[Christian Graus]

There is a school of thought that suggests the data layer should return collections of objects instead of database related classes.

Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

[N a v a n e e t h]

Christian Graus wrote:

There is a school of thought that suggests the data layer should return collections of objects instead of database related classes.

Great information. I was not knowing. What will be the impact when it returns Database classes ? upto my knowledge, DataTable is also a collection class which contain a collection of DataRows. So what is making difference ?

---

My Website | Ask smart questions

[Christian Graus]

He's returning a collection of entity objects. It's at least partially a religious discussion. I've seen all sorts of other OO principles thrown out in order to pursue this one goal. It's not clear cut, and you need to make a call based on the needs of your project. It is very sexy to call the data layer and get back a list of custom business objects, tho.

Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )