Hi All,

You are encountering the Cast exception because you will need to implement the IHierarchyData interface when using the ContainerGridDataBinding event. Attached you will find a sample that demonstrates how you can use our WebHierarchicalDataSource (which implements this interface internally) to perform custom sort with this event.

Hope this helps.

Hi

We are facing the same issue after implementing WebdgrdStatements_ContainerGridDataBinding

"Unable to cast object of type 'System.Data.DataRowView' to type 'System.Web.UI.IHierarchyData'

Kindly Suggest as its urgent.

Kind Regards

Vihang

David,

Could you please provide a working code example of ContainerGridDataBinding? I am unable to make it work.  At first I wasn't even sure how to cause this event to fire, but then realized that binding WHDG to a dummy dataset that contains a single table with a single row will cause event to fire (please correct me if there's a better way).

Now I am handling it like this:

Protected Sub xMyGrid_ContainerGridDataBinding(sender As Object, e As GridControls.DataBindingEventArgs) 

   e.Cancel = True

   e.DataSource = DisplayCurrentGridPage()
   e.SelectArguments.TotalRowCount = GetTotalPageNumber()

End Sub

where GetDataForCurrentPage() returns an ADO.NET DataSet. But now I am getting error

   "Unable to cast object of type 'System.Data.DataRowView' to type 'System.Web.UI.IHierarchyData'"

Any idea why and how to avoid this? Also am I right in assuming - when I assign "e.SelectArguments.TotalRowCount" - it will affect pager behavior (e.g. total page count) ? And do I still have to handle PageIndexChanged event or "CustomDataBinding" will be automatically called on every page click?

Thanks!