Can someone please help me? I have been trying to get a datagrid to be populated by a filtered dataset. I have been trying DatasetName.TableName.Select("Filter=value","sort"). I then set my databindings of the datagrid to the dataset and the table in question. What I get is a datagrid populated with all records. Am I implementing this wrong? I also tried to create a dataview and use it to Bind the datagrid to but I recieve an exception "cannot create a child list for field tablename" (it refers to the table as a field). Can someone please show me how to do this or at least offer some pointers?
Thanks in advance