Hi,
We have a parameter-based stored procedure that returns a resultset we have mapped to a TypedView.
Therefore we can fill the TypedView as in the documentation...
CustomersOnCountryTypedView customersTv = new CustomersOnCountryTypedView()
// Fill the TypedView with a class method that internally calls the stored procedure
customersTv.Fill(null, "USA");
... but we'd like to view it in a web grid. How can we bind that TypedView to a LLBLGenProDataSource (or LLBLGenProDataSource2)?
The code from the fill method is something like
public bool Fill(ITransaction transactionToUse, System.String countryID)
{
bool toReturn;
using(IRetrievalQuery query = RetrievalProcedures.GetQueryForCustomersOnCountryTypedView(countryID))
{
toReturn = new TypedListDAO().GetMultiAsDataTable(GetFields(), this, query, transactionToUse);
}
return toReturn;
}
We tried some explicit cast with ITypedView, but it didn't work.
It should be really simple, but we don't get it right.
TIA