Miscellany

 int iUpdateTable = 0;
            string ddd = e.ToString();
            ug = this.ugWorkOrder;
            switch( e.Cell.Band.Index )    //
                {
                case 17:  // Mileage
                    switch( e.Cell.Column.ToString() )
                        {
                        case "MileageStart":
                            iUpdateTable = e.Cell.Band.Index;
                            e.Cell.Row.Cells[ "MileageTotal" ].Value = clsCon.Int_from_Str( e.Cell.Row.Cells[ ug.ActiveCell.Column.Key ].Value.ToString() ) - clsCon.Int_from_Str( e.Cell.Row.Cells[ "MileageEnd" ].Value.ToString() );
                            break;
                        case "MileageEnd":
                            iUpdateTable = e.Cell.Band.Index;
                            //   ug.ActiveRow.Cells[ "MileageTotal" ].Value = clsCon.Int_from_Str( ug.ActiveRow.Cells[ "MileageStart" ].Value.ToString() ) - clsCon.Int_from_Str( ug.ActiveRow.Cells[ ug.ActiveCell.Column.Key ].Value.ToString() );
                            break;
                        }
                    break;
                }
            switch( iUpdateTable )    //Upade table 
                {
                case 17:
                    switch( ug.ActiveCell.Column.ToString() )   // Mileage
                        {
                        case "MileageStart":
                            //    e.Cell.Row.Cells[ "MileageTotal" ].Value = clsCon.Int_from_Str( e.Cell.Row.Cells[ ug.ActiveCell.Column.Key ].Value.ToString() ) - clsCon.Int_from_Str( e.Cell.Row.Cells[ "MileageEnd" ].Value.ToString() );
                            break;
                        case "MileageEnd":
                            break;
                        }
                    break;
                }