How to Change order of columns in gridview

change gridview templatecolumn order dynamically.
1.Iterate through all coloumns of the GridView object and Store them in a collection.

List<DataControlField> coloumns = new List<DataControlField>();
foreach (DataControlField coloumn in gv.Columns)
{
    coloumns.Add(coloumn);
}

2.Rearrange the coloumn-objects as you want in the collection.
//Rearrange coloumns' collection..

3.Clear all coloumns of the GridView object and add coloumns from the collection to GridView object.

gv.Columns.Clear();
 foreach (DataControlField coloumn in coloumns)
 {
     gv.Columns.Add(coloumn);
 }

HI Try like this..

Consider your Gridview has two bound field columns as below
set the AutoGenerateColumns as false

<asp:GridView ID="GridView1" AutoGenerateColumns="false" runat="server">
       <Columns>
           <asp:BoundField HeaderText="____Static_Col_AA" DataField="AutoColum_AA" ItemStyle-Width="50px" />
           <asp:BoundField HeaderText="____Static_Col_BB" DataField="AutoColum_BB" ItemStyle-Width="50px" />
       </Columns>
   </asp:GridView>

assume this sample datasource:

DataTable dt = new DataTable();
               dt.Columns.Add("AutoColum_AA", typeof(int));
               dt.Columns.Add("AutoColum_BB", typeof(int));
               dt.Columns.Add("AutoColum_CC", typeof(int));
               dt.Columns.Add("AutoColum_DD", typeof(int));

               for (int i = 0; i < 6; i++)
                   dt.Rows.Add(i, i, i, i);

Store all the static columns of the gridview to a list as

List<DataControlField> lstStaticColumns = new List<DataControlField>();
               foreach (DataControlField col in GridView1.Columns)
                   lstStaticColumns.Add(col);

Clear the GridView Columns:

GridView1.Columns.Clear();

Create the Dynamic Columns in the codebehind as
( this will be auto generated columns which will be appearing first in the gird view )

foreach (DataColumn col in dt.Columns)
                {
                    BoundField bfield = new BoundField();
                    bfield.DataField = col.ColumnName;
                    bfield.HeaderText = col.ColumnName;
                    GridView1.Columns.Add(bfield);
                }

Add the Static Columns to the GridView ( bound (static) columns will be appearing at the end )

foreach (DataControlField col in lstStaticColumns)
                   GridView1.Columns.Add(col);

Bind the GridView as below... :)

GridView1.DataSource = dt;
               GridView1.DataBind();

Note: Tested Working Fine..

If you are adding columns in a DataTable in Code Behind , You can use SetOrdinal(Index) method of DataTable to set the order of columns.

DataTable tolfree = ds.Tables[0];

tolfree.Columns.Add(new DataColumn { ColumnName = "CTCHandled", DataType = typeof(int), DefaultValue = 0 });
tolfree.Columns.Add(new DataColumn { ColumnName = "TotalHandled", DataType = typeof(int), DefaultValue = 0 });

tolfree.Columns["Agent_Id"].SetOrdinal(0);      //Auto Generated Column
tolfree.Columns["Agent_Name"].SetOrdinal(1);    //Auto Generated Column
tolfree.Columns["CTCHandled"].SetOrdinal(2);              //Manually Generated column
tolfree.Columns["TotalHandled"].SetOrdinal(3);            //Manually Generated column

Thanks for your replies. I tried all the above solutions, but they are not worked.
I resolved this by using Jquery as bellow,

$(document).ready(function() {
    var ColCount = $("#gvEvalRankReport tr:nth-child(2) td").length
    jQuery.each($("#gvEvalRankReport tr"), function() {
    $(this).children(":eq(" + (ColCount - 1) + ")").after($(this).children(":eq(1)"));
    $(this).children(":eq(" + (ColCount - 1) + ")").after($(this).children(":eq(0)"));
    $(this).children(":eq(" + (ColCount - 3) + ")").hide();
    });
});

You could change the input SQL Statement:

    cmdStr = "SELECT * FROM table1;"
To
    cmdStr = "SELECT * FROM table1 ORDER BY col1 ASC;"
Or
    cmdStr = "SELECT * FROM table1 ORDER BY col1 DESC;"