I am using one third party control called Spreadsheet for that i am doing some operation on the current page and going to the next page when the application coming back to the previous page some operations are change data is not saving ..
I am showing the code below ....
Public Sub SetPartMagnifierForBOM()
costEstimateRowDS = WebServiceLayer.GetCostEstimateService().GetCheckForAlternativePrices(costEstimateRowDS, _costEstimateId)
costEstimateFpSheet.DataSource = costEstimateRowDS.CostEstimateRow
With costEstimateFpSheet
'As mentioned here
http://www.clubfarpoint.com/Forums/forums/thread/57378.aspx, our assumption that the DataRow fetched from the ModelRow pointed to the row in the dataset
'was wrong. The DataRow corresponds to the row in the sheets dataview, not the bound datatable.
Dim dv As DataView = costEstimateFpSheet.GetDataView(True)
For i As Integer = 0 To .RowCount - 1
Dim viewRow As CostEstimateRowDataset.CostEstimateRowRow = DirectCast(dv(SpreadHelper.GetDataRowFromSheetRow(costEstimateFpSheet, i)).Row, CostEstimateRowDataset.CostEstimateRowRow)
If viewRow.HasPrices Then
.Cells(i, SpreadCols.View).CellType = SpreadHelper.GetCellType(CellTypes.View)
Else
.Cells(i, SpreadCols.View).CellType = SpreadHelper.GetCellType(CellTypes.ViewRed)
End If
Next
End With
End Sub
In the above code we need to change anything ......
suresh.pydi
Member
137 Points
189 Posts
Data is not updating correctly...
May 31, 2012 08:26 AM|LINK
Hello all,
I am using one third party control called Spreadsheet for that i am doing some operation on the current page and going to the next page when the application coming back to the previous page some operations are change data is not saving ..
I am showing the code below ....
Public Sub SetPartMagnifierForBOM()
costEstimateRowDS = WebServiceLayer.GetCostEstimateService().GetCheckForAlternativePrices(costEstimateRowDS, _costEstimateId)
costEstimateFpSheet.DataSource = costEstimateRowDS.CostEstimateRow
With costEstimateFpSheet
'As mentioned here http://www.clubfarpoint.com/Forums/forums/thread/57378.aspx, our assumption that the DataRow fetched from the ModelRow pointed to the row in the dataset
'was wrong. The DataRow corresponds to the row in the sheets dataview, not the bound datatable.
Dim dv As DataView = costEstimateFpSheet.GetDataView(True)
For i As Integer = 0 To .RowCount - 1
Dim viewRow As CostEstimateRowDataset.CostEstimateRowRow = DirectCast(dv(SpreadHelper.GetDataRowFromSheetRow(costEstimateFpSheet, i)).Row, CostEstimateRowDataset.CostEstimateRowRow)
If viewRow.HasPrices Then
.Cells(i, SpreadCols.View).CellType = SpreadHelper.GetCellType(CellTypes.View)
Else
.Cells(i, SpreadCols.View).CellType = SpreadHelper.GetCellType(CellTypes.ViewRed)
End If
Next
End With
End Sub
In the above code we need to change anything ......
Regards,
Naresh.Pydi
</div></div>