How are you?

I was wondering, is it possible to dymanically assign the value of a datagrid column's header text?

For example, I have a dropdown list, ddlone and the user selects an option from the list. How do I get ddlone.selecteditem.text to appear as a headertext in a bound column of a datagrid.

Here is the code for my datagrid:

<asp:datagrid id="dgEmps" runat="server" Width="617px" Height="190px" AutoGenerateColumns="False" BackColor="#eeeeee" HorizontalAlign="Center" Font-Bold="True" Font-Name="Verdana" Font-Size="10pt" HeaderStyle-VerticalAlign="Middle" footerstyle-verticalalign="Middle" HeaderStyle-HorizontalAlign="Center" footerstyle-horizontalalign="Center" HeaderStyle-BackColor="#7b87b2" HeaderStyle-height="100px" FooterStyle-height="200px" AlternatingItemStyle-BackColor="white" style="Z-INDEX: 107; LEFT: 176px; POSITION: absolute; TOP: 328px">
    <Columns>
    <asp:BoundColumn DataField="CPT_COMPETENCY_NM" HeaderText="Competency Name" />
    <asp:BoundColumn DataField="EMPLOYEE ONE" HeaderText="XX" ItemStyle-HorizontalAlign="Center" />
    <asp:BoundColumn datafield="EMPLOYEE TWO" HeaderText="XY" ItemStyle-HorizontalAlign="Center" />
    </Columns>
</asp:datagrid>


I have been playing around with column controls and datagrid controls in vb.net today and I dont see anything that is going to let me this.

thanks in advance,

Morris

I believe you can dynamically assign a header this way:

dgEmps.Columns(1).HeaderText = ddlOne.selectedItem.Text

Hi,

That works! Nice and easy, thanks!

Morris

Hi, me again wth another problem,

I am trying to change the names of the columns in a datagrid where I am using autogenerated columns.

While the code posted earlier works with bound columns, is it possible to do the same thing with autogenerated columns? I am getting this error:

Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

Anu ideas?

Thanks,

Morris

Are you trying to change the header before you bind to the data grid? This may cause this. Also, note that every time you rebind to the data grid, you will probably have to reassign the column header.

Morris,

You are probably trying to this before the grid columns are created. In order to modify the automatically created columns, you'll need to work in the ItemCreated handler for the grid. You can test the current e.Item.ItemType for the DataGrid Header item and then manipulate the column headers at that point.

Peter
-------------------------
Work smarter, not harder

use [u]<HeaderStyle></u> in [u]<asp:DataGrid></u> in HTML of ASPX file!

HTH.

Always:),
Hovik Melkomian.

Hey folks,

Firstly, thanks for all the help, it is really appreciated.

Here is the code-behind for my datagrid:
    Function search() 'searches for info about the users and comp types
        Dim sql_compare_str As String
        sql_compare_str = build_sql()

        Dim Review_cmd As System.Data.OleDb.OleDbCommand

        'opening the database connection
        dbconn.Open()
        dgEmps.Visible = True

        Review_cmd = New System.Data.OleDb.OleDbCommand(sql_compare_str, dbconn)
        Dim Review_ds As System.Data.OleDb.OleDbDataReader
        Review_ds = Review_cmd.ExecuteReader()

        dgEmps.DataSource = Review_ds
        dgEmps.DataBind()
        dbconn.Close()

        dgEmps.Columns(1).HeaderText = ddemp1.SelectedItem.Text
        dgEmps.Columns(2).HeaderText = ddemp2.SelectedItem.Text

    End Function

As far as I can make out, I am not trying to add column headings until the data is bound to the datagrid. Should I be doing this in another function?

Morris

I don't see anything inherently wrong with the way you are doing this. As long as it works this way.

Hi,

that is the code which is causing the problem... any ideas?

Morris