hi,

i am using VS 2005. In my web application i populated datatable from a dataset. I removed somw unwanted columns using Datatable's Remove() method.

Now I wanted to arrange the order of the columns in my datatable. i.e. my col1 should be col1, col5 should be col2 and col2 should be col3,....so on. Please help me out for doing this.

Thanks in advance..
Kiran

hi there...

how are you populating the colums of the grid?? in the IDE this is done by you moving the columns around.. if the columns are generated automatic then you maybe has to re arrange the sql in the order you want the colums (also don't select the ones that you don't want)...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========

Hi Gonzalo,

thanks for the reply.

but the problem is I cannot make anychanges in my dataset because it is being used by someother part of the program too. whatever I do, I have to do it in the datatable or someother way after fetching the data from that dataset.

Is there a way for this?

Thanks in advance

I insist.. since the problem looks like the way you show your data, why not arrange the control that show the data better than the datatable???

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========

Thanks again...

Actually i am exporting this data to a excel sheet and for a cleint download. so i need to export the data in arranged order...

I found this:

"Sometimes the need may arise to have to re-arrange columns in a DataSet.
If you're using ADO.NET 2.0 then you can change the position of a column using the DataColumn.SetOrdinal() method.
MyDataSet.Tables["MyTable"].Columns["MyColumn"].SetOrdinal(5);"

here: http://www.levelextreme.net/ViewPage...507A6345413D3D

I found this:
----------------------------------------------------------
Sometimes the need may arise to have to re-arrange columns in a DataSet.
If you're using ADO.NET 2.0 then you can change the position of a column using the DataColumn.SetOrdinal() method.
MyDataSet.Tables["MyTable"].Columns["MyColumn"].SetOrdinal(5);
-----------------------------------------------------------
here: http://www.levelextreme.net/ViewPage...507A6345413D3D