How can I sort datagrid?

[taly]

Hi all
how can I make the interface for the user so he can sort datagrid?
thanks

 

[Guest]

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

This site has everything you could want to know about the DataGrid

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Usually what you do is sort the datagrid's datasource , if it's a
dataview/dataset you can use a Dataview for it.

I think I remember an article from Dino Esposito in MSDN magazine where he
sorted a HTML table ( which is the result of a datagrid in the client) try
searching in the MSDN archives.


Cheers,

 

[Taly]

thanx.printed it , now reading

 

[Scott M.]

Please don't cross-post. Here is your answer:


Private Sub dg_PageIndexChanged(ByVal source As Object, ByVal e As
System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles
dg.PageIndexChanged
dg.CurrentPageIndex = e.NewPageIndex

'Sort the new page according to the last sort criteria
Dim dv As New DataView(dsCusts.Tables(0))
dv.Sort = ViewState.Item("lastSort")
dg.DataSource = dv

dg.DataBind()
End Sub

Private Sub dg_SortCommand(ByVal source As Object, ByVal e As
System.Web.UI.WebControls.DataGridSortCommandEventArgs) Handles
dg.SortCommand
Dim dv As New DataView(dsCusts.Tables(0))
dv.Sort = e.SortExpression
dg.DataSource = dv
dg.DataBind()

'Store the desired sort criteria so that it can be applied when
paging occurs
ViewState.Add("lastSort", e.SortExpression)
End Sub