what am i doing wrong(bindingsource loop)

[Crash893]

Hi all

Im trying to loop through spesific coloums of a bindingsource but i am having some trouble

the code i have so far is

private void CountLines(BindingSource bs)
        {
            int x = 0;
            foreach (DataRowView IncidentRow in bs)
            {
                MessageBox.Show(IncidentRow.ToString());
                
                x++;
            }//foreach (DataRowView invoiceRow in invoicebindingsource)
            MessageBox.Show(x.ToString());
           
        }

But all i get out is



so my question is how would i say messagebox.show each summary or each ref num?


thanks

Crash

[nmadd]

Hi there,
You need to specify which column in the row you want to view buy its index or name:

MessageBox.Show(IncidentRow.Row["ref_num"].ToString());

[Crash893]

bingo



thanks

if i were to want to save it back how would that go?

[jmcilhinney]

Save what back, and back to what?

[Crash893]

Sorry i was not very spesific

after i can access the data by row and col if i wanted to make a change to that cell how would i?



I mocked up some sudo code that might give you an idea of what im trying to figure out.

private void CountLines(BindingSource bs)
        {
            int x = 0;
            foreach (DataRowView IncidentRow in bs)
            {
                If(IncidentRow.Row["ref_num"].ToString(); == stringimadeup)
                {
                    replace incidentrow.row["ref_num"].tostring with "N/A"
                }
                
                x++;
            }//foreach (DataRowView invoiceRow in invoicebindingsource)
            MessageBox.Show(x.ToString());
           
        }

[jmcilhinney]

DataRowViews are almost the same as a DataRow. They are a view to the data in that row and can be used in almost exactly the same way:

foreach (DataRowView view in myBindingSource)
{
    if ((string)view["ref_num"] = "some string")
    {
        view["ref_num"] = "N/A";
    }
}

Note that if the column already contains string objects then you should cast as type string rather than call the ToString method. Why convert a string to a string? If you're unsure of the type then you should cal ToString to ensure it works in all cases.

[Crash893]

DataRowViews are almost the same as a DataRow. They are a view to the data in that row and can be used in almost exactly the same way:

foreach (DataRowView view in myBindingSource)
{
    if ((string)view["ref_num"] = "some string")
    {
        view["ref_num"] = "N/A";
    }
}

Note that if the column already contains string objects then you should cast as type string rather than call the ToString method. Why convert a string to a string? If you're unsure of the type then you should cal ToString to ensure it works in all cases.

thanks so much ill give it a shot when i get into work tommrow

i would give you a +rate but i cant give you anymore