I want to multiply my quantity row by price row and make a new column called total and print the total in there..how would i go about doing that
Dim DV2 As DataView = CType(SqlDataSource1.Select(DataSourceSelectArguments.Empty), DataView)
If DV2.Count > 0 Then
Dim i As Integer = 0
Do Until i = DV2.Count
'Create & fill Datarow
Dim dr As DataRowView = DV2.Item(i)
'Create & fill Data Table Row
Dim row As DataRow = t.NewRow()
row("Inventory Code") = dr.Item(0).ToString
row("Inventory Description") = dr.Item(1).ToString
row("Price") = (CInt(dr.Item(2).ToString)).ToString("C")
Dim DV3 As DataView = CType(SqlDataSource1.Select(DataSourceSelectArguments.Empty), DataView)
If ...
Go to the complete details ...