Filter Gridview that are bound to an XML file

[Ronni Marker]

Hi everyone. I am currently playing around with XML files and gridview, and wondered if there were any easy way to filter data, so only rows with specific content are shown. I have the following.

        DataTable dt = new DataTable("Subscribers");
        dt.Columns.Add("ID");
        dt.Columns.Add("Email");
        dt.Columns.Add("signup");
        dt.Columns.Add("recent");
        dt.Columns.Add("Amount");
        dt.Columns.Add("Status");
        dt.ReadXml(Application.StartupPath + @"\\subscribers.xml");
        dataGridView1.DataSource = dt;
        dataGridView1.Refresh();

and would like to filter it so rows who fx. only have the value 0 in the columns "Status" would be shown. Initially hoped that I could use dt.Select("Status == 0") but that didnt work. so any supercoders out there? yes, yes i did try to google my issue, but didnt find any solution to my small challenge here... other alternative that I will go back to my good old SQL Server, skip XML files and just use what I am used to - but that would be too easy...

[Lost User]

Try it with dt.Select("Status = 0")

[Ronni Marker]

no, that didnt work either. (too bad though)

[Lost User]

See this example (it works):

DataTable dataTable = new DataTable("MyTable");
dataTable.Columns.Add("Column1");

DataRow dataRow = dataTable.NewRow();
dataRow["Column1"] = "0";
dataTable.Rows.Add(dataRow);

DataRow[] foundRows = dataTable.Select("Column1 = 0");
Trace.Write(foundRows); // <- Count = 1

Have you checked your dataTable ? Are there rows with content 0 in Status ?

[Ronni Marker]

Yes, well came to the conclusion that the error for me is that I thought it would be enough to add a line into the code and that would be that. But can see that I need to do more than that. Basically tried to add

dt.Select("Status =1");

after reading the XML file and also tried to filter it like this

dataGridView1.DataSource = dtSelect("Status =1");

<- this actually gave an interesting output. But seems that I wouldnt be able to get away with only a line of code thist time here. So what would be the best way to do this? (just imagine that I have an XML file with more than 2000 Rows)

[Henry Minute]

No guarantees that this will work but you could try adding a BindingSouce component to your form and then the bindings become

datagrid.DataSource = bindingSource1;
bindingsource1.DataSource = dt;

BindingSource has a Filter property that you can use. In fact, if you search MSDN for BindingSource.Filter, the example uses XML which should make getting your stuff to work a bit easier. :)

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

[Ronni Marker]

Fantastic, worked first time - ehm after I remembered that there is a difference between 1 and '1'. But thanks for the headsup on BindingSource. Cheers,