Quote Originally Posted by 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:
Code:
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