Populate datagrid with subset of datatable

[firstdivision]

Hi All,

I'm trying to select subsets of data and bind them to programatically generated datagrids. The code I came up with seems like it should work, and it almost does....but not quite

When I do this:

TheDataGrid.DataSource = MyDataSet.Tables("MyTable").Select("MyItem='" & AnItem & "'")
TheDataGrid.DataBind()

I get this in my datagrid:

|----------------------|
| RowError | HasErrors |
|----------------------|
|          | False     |
|          | False     |       
|----------------------|

The number of items in the datagrid will change depending on what I "select", so that part works, but how do I get the data and not an error count of sorts?

Thanks,
FD

 

[firstdivision]

Ok, kinda figured this one out even though I'm not thrilled with the solution:

Basically I had to create a new DataSet and then call DataSet.Merge(MyDataSet.Tables("MyTable").Select("MyItem='" & AnItem & "'"))


(Actually I put the results into a DataRow array first, but I had already done this earlier so it was available, but I think the above would work as well).

Maybe this will help someone out in the future...

-FD

 

[jbenson001]

I tested your original code, and I received no errors. There must be something else that is causing your problem.

 

[firstdivision]

Hmm, that's weird. Thanks for the test jbenson. If I have time I'll have to re-visit the issue to see what was going on.

-FD

 

[jbenson001]

Ok let me know how it goes..
Jim