Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GridView from Dataset *WITH* Sorting and Paging
Message
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
01189659
Message ID:
01189713
Views:
7
>Hello World,
>
> I have requirements for a control that accepts a dataset and displays all the data with paging and sorting capabilities. With that said I thought the GridView would be perfect. Problem: DataSet is not sortable. In my web app I do not have access to the SQL Server getting the dataset. I tried to convert the ds to a dataview but I was getting inconsistant results. I have no problem with the gridview in normal useage with a sqldatasource, but again all I have to start with is the dataset.
>
> My humble thanks in advance,

If you can get to the data view...
are you using the

.Sort property to set the sort expression???
Private Sub grdPopup_SortCommand(ByVal sender As System.Object, ByVal e As DataGridSortCommandEventArgs) Handles grdPopup.SortCommand
    Dim dv As New DataView

    dv.Table = dsYourDataSet.Tables("YourTable")
    Me.grdPopup.DataSource = dv
    dv.Sort = e.SortExpression.ToString
    Me.grdPopup.DataBind()
End Sub
I just use a standard datagrid, but its SOURCE is that of a view...
Previous
Reply
Map
View

Click here to load this message in the networking platform