Unable to cast object of type 'System.Data.DataView' to type 'System.D

[stonehead]

Hi all,

I'm trying to do sorting for my gridview. This is the error I got
Unable to cast object of type 'System.Data.DataView' to type 'System.Data.DataTable'

for this line
gvDetail.DataSource = SortDataTable(Session("myTable"), False)

Please help.



Protected Sub gridView_Sorting(ByVal sender As Object, ByVal e As GridViewSortEventArgs)

GridViewSortExpression = e.SortExpression

Dim pageIndex As Integer = gvDetail.PageIndex


gvDetail.DataSource = SortDataTable(Session("myTable"), False)


gvDetail.DataBind()

gvDetail.PageIndex = pageIndex

End Sub

 

[jbenson001]

Since i can't see all of your code, I would try casting the session object to a datatable first.

SortDataTable(DirectCast(Session("myTable"),DataTable), False)

 

[stonehead]

Thank you for your prompt response. I found out why I got the error. It's because I put
Session("myTable") = New Data.DataView()
before Page.IsPostBack

 

[jbenson001]

Glad you found it, but you should always cast your objects when you are pulling from the session object.