sorting datagrid columns with variable names

[davey.phillips]

I have a datagrid within a datagrid which is filled with data from an
SQL Server db. Each inner datagrid is populated by an sql statement
which contains a variable column name. Output looks something like
this:

Dept no_valid no_invalid
a 4 1
b 7 2
c 3 5

Team no_valid no_invalid
a1 2 1
a2 1 0
b1 3 0
The 2nd and 3rd column titles are always the same, the first column
title is taken from the variable column name in the SQL statement
(stored procedure). This is then passed to a string, and I do

<code>
e.Item.Cells(0).Text = str_header_name
</code>

in the subroutine that handles each line of the inner datagrid.

When I run the page, the second and third columns appear as hyperlinks
and allow me to sort. The first doesn't, cos it's name's a variable.

Is there any way for me to get this to appear as a hyperlink, and have
standard sort functionality?

Any help would be greatly appreciated, but please go easy on me, cos
I'm a total noob to asp.

Cheers.

[DaveyP]

On 28 Feb, 11:46, [e-mail] wrote:

I have a datagrid within a datagrid which is filled with data from an
SQL Server db. Each inner datagrid is populated by an sql statement
which contains a variable column name. Output looks something like
this:

Dept no_valid no_invalid
a 4 1
b 7 2
c 3 5

Team no_valid no_invalid
a1 2 1
a2 1 0
b1 3 0

The 2nd and 3rd column titles are always the same, the first column
title is taken from the variable column name in the SQL statement
(stored procedure). This is then passed to a string, and I do

<code>
e.Item.Cells(0).Text = str_header_name
</code>

in the subroutine that handles each line of the inner datagrid.

When I run the page, the second and third columns appear as hyperlinks
and allow me to sort. The first doesn't, cos it's name's a variable.

Is there any way for me to get this to appear as a hyperlink, and have
standard sort functionality?

Any help would be greatly appreciated, but please go easy on me, cos
I'm a total noob to asp.

Cheers.

<<bump>>

[DaveyP]

Sorted.

I did a regex to replace the datagrid.HeaderText.

Problem solved.