Changing position of dynamically created column in GridView - ASP.NET

Question

I am having trouble adding new columns to GridView control from code-behind. I use DataTable as a datasource for my GridView control, and, after binding it, every column that I add to GridView appears at the left side of the control. I need to change it's position.

Please note, that I need to add columns from the code-behind, not from the .aspx file.

My GridView definition in .aspx file:

<asp:GridView ID="devicesTable" runat="server" OnRowEditing="deviceEdit">
</asp:GridView>

And the piece of code, where I try to add a column:

StoredProcedure connection = new StoredProcedure("usp_nsi_mpd_sel");

DataTable dataTable = connection.ExecReader();
ButtonField buttonField = new ButtonField();
buttonField.CommandName = "Select";
buttonField.ButtonType = ButtonType.Button;
buttonField.Text = "Edit";

devicesTable.DataSource = dataTable;
devicesTable.Columns.Add(buttonField);
devicesTable.DataBind();

And this results in buttonField appearing at the left side of the GridView. How do I change it's position?

Thanks in advance.

If the main issue is dynamically changing the order of columns you can see my answer here: http://stackoverflow.com/a/28611217/215752 — Hogan, Feb 19 '15 at 16:42

score 1 · Answer 1 · answered Feb 18 '14 at 10:42

1

Try this.Use insert for dynamically created columns

devicesTable.Columns.Insert(0, buttonField)

DataGridViewColumnCollection.Insert Method

answered Feb 18 '14 at 10:42

Nagaraj S

13,316
6
32
53

thanks for your reply, but this method says that even 0 index is out of range. i found the solution already, but it involves a bit of asp code :) – an40us Feb 18 '14 at 11:08
– an40us Feb 18 '14 at 11:31
oh, and the main thing :D – an40us Feb 18 '14 at 11:32
and after that i could get to my fields by indexes. seems like the only solution for now. unfortunately, i don't have time now to think of a better way to fulfil my idea. – an40us Feb 18 '14 at 11:33

score 1 · Answer 2 · answered Feb 18 '14 at 10:58

1

You can use a thing like that,

   private void AdjustColumnOrder()
{
    customersDataGridView.Columns["CustomerID"].Visible = false;
    customersDataGridView.Columns["ContactName"].DisplayIndex = 0;
    customersDataGridView.Columns["ContactTitle"].DisplayIndex = 1;
    customersDataGridView.Columns["City"].DisplayIndex = 2;
    customersDataGridView.Columns["Country"].DisplayIndex = 3;
    customersDataGridView.Columns["CompanyName"].DisplayIndex = 4;

}

answered Feb 18 '14 at 10:58

Julien698

676
3
10
27

i can't acces columns by name because i haven't specified them in .aspx page. i found the solution myself, thanks :) – an40us Feb 18 '14 at 11:09

score 0 · Accepted Answer · answered Feb 18 '14 at 11:29

0

So, to change the position of any column in the GridView i had to bound fields to my data source.

answered Feb 18 '14 at 11:29

an40us

65
1
10

Changing position of dynamically created column in GridView - ASP.NET

3 Answers3