Code Example for calling a dataview and updating

So, I am trying to put together some code and looking for an example of something similar.

I am in the Sales Order form and have a sales order number as a variable. I would like to call up a dataview with all the orderrel associated with the order number. Then I will cycle through them and update a particular field.

Any examples or idea on how to write this? I will be working in VB but can read C# too.

This is very easy to do in progress or sql but I really would like to do it in the .Net layer for certain reasons.

Thanks,

Tom Christie

Manufacturing Engineer

AGM Container Controls
3526 E Ft. Lowell Road
Tucson, AZ 85716
PH: 520-881-2130
FX: 520-881-4983
www.AGMcontainer.com