Set the DataSource property to the DataSet.

DataSet dsClientReview = this.ClientReviewController.GetClientReveiwList(e.SearchString);
this.grdMainDataGrid.DataSource = dsClientReview;
this.grdMainDataGrid.DataBind();

Tim

>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