General information
Category:
The Mere Mortals .NET Framework
Hi Tim,
OK... Thanks. Sounds like the way to go. But when I do, the compiler complains that it cannot implicitly convert my dataset to a binding list.
I've created the dataset...
public DataSet GetClientReviewList(string clientName)
{
return this.GetDataSet("ClientReviewList", this.CreateParameter("@Name", clientName));
}
And this is what chokes...
this.grdMainDataGrid.ItemsSource = this.ClientReviewController.GetClientReviewList(e.SearchString);
How do I cast a dataset to a binding list?
Guy
>Hi Guy,
>
>Since this is for lookup purpose and not using for updates I would just create your stored procedure to return what you want and then in your business object you can return a DataSet rather than an entity list and calling that stored procedure. This way you join whatever you want from your tables.
>Tim
>
>>Hi,
>>
>>Using MM.NET 4.0, classic entities (not Entity Framework).
>>
>>Here is the problem I'm trying to solve... I want a lookup list for some objects in a child table, but I want a field from the parent table to display in the list. The best example I can think of is a customer with invoices. (That's not what I'm really working with but this simple example will do.)
>>
>>Imagine a customer table (custPK, custName, blah, blah, blah)
>>And an invoice table (invPK, custFK, item, Qty, Amt)
>>
>>I want an entity list of invoices (for look up purposes only) that contains:
>> ( invPK, custName, Item, Qty, Amt )
>>
>>Note the custName field comes from another table other than the primary entity.
>>
>>I have been using mmBindingList for creating lookups and lists of single-table entities and this has worked well.
>>
>>But how do I grab a field from another table? I tried to use the BLG to create a new entity for this purpose but unless I'm missing something, it can only create custom entities from a single table.
>>
>>Any ideas?
>>
>>Thanks,
>>Guy
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only