Datagrid sort template column

[aaronjonmartin]

Hi guys hope you can shed some light on this. I have a datagrid which contains a template column which displays a firstname and surname from 2 records in a database. Here is the code for the template column:

<asp:TemplateColumn HeaderText="Name">
 <ItemTemplate>
   <%# DataBinder.Eval(Container.DataItem, "FirstName") %> 
   <%# DataBinder.Eval(Container.DataItem, "Surname") %>
 </ItemTemplate>
</asp:TemplateColumn>

I have other columns which are bound columns and are sortable. My question is, can i make this template column sortable? and how do i do it?

Any help with this would be greatly appreciated.

Aaron



"It's so much easier to suggest solutions when you don't know too much about the problem."
Malcolm Forbes (1919 - 1990)

 

[ca8msm]

There is a great article on DataGrid's on 4guysfromrolla.com and I think this part discusses sorting and how to implement it:

http://aspnet.4guysfromrolla.com/articles/052202-1.aspx

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[aaronjonmartin]

I should also add that im using VB and i dont have access to Visual Studio. anyone any ideas?

"It's so much easier to suggest solutions when you don't know too much about the problem."
Malcolm Forbes (1919 - 1990)

 

[aaronjonmartin]

Thanks for the link ca8msm unfortunately it doesnt help. That example is using bound columns and i have implemented sorting on the bound columns of my datagrid without any problem. My problem lies with sorting the template column which is displaying data from two databased columns.

"It's so much easier to suggest solutions when you don't know too much about the problem."
Malcolm Forbes (1919 - 1990)

 

[ca8msm]

Apologies - I think I glossed over the fact that you had mentioned TemplateColumns.

You may be able to do it by using a DataView and using that to sort your data before giving it to your DataGrid. Have a look at the "Sorting Columns in DataGrid" section at:

http://samples.gotdotnet.com/quicks...ms/ctrlref/webctrl/datagrid/doc_datagrid.aspx

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[aaronjonmartin]

thanks again for the link ca8msm thats the closest example ive seen so far but its still only one field from the database whereas mine is a combination of two. Does anyone know if what im asking is possible?

"It's so much easier to suggest solutions when you don't know too much about the problem."
Malcolm Forbes (1919 - 1990)

 

[ca8msm]

Wouldn't the easiest solution be to combine the first name and surname in SQL so that it is returned as one field and therefore can be sorted like in the example above?

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[aaronjonmartin]

you know what i hadnt thought of that, although im not the best with sql im using a stored procedure, anywhere i can see an example of how i could combine them in the stored procedure?

"It's so much easier to suggest solutions when you don't know too much about the problem."
Malcolm Forbes (1919 - 1990)

 

[jbenson001]

Try....
select col1, col2, colname = surname + ', ' + firstname, col....
where...