Help with datagrid column

[sunnyjulka]

Hello everyone
I have a datagrid which shows selected rows from my Inventory table. One of the columns in the datagrid shows the price of the item. How can I add the price column for the whole datagrid and display that in a label.
Thanks in advance

 

[mjb3030]

You will use your source data for that. Is it a DataView? If you are showing selected rows from a table, you should probably be using a DataView as your source for the DataGrid. Then, you could just cycle through the rows in the DataView and add up the values in that column.

Example:

'dtInventory is the DataTable
dim PriceTotal as Double
dim dv as DataView = new DataView(dtInventory)
dv.Filter = "some filter" 'Apply your filter
myDataGrid.DataSource = dv
for i as integer = 0 to dv.Count - 1
PriceTotal += dv(i)("Price")
next
lblPrice.Text = PriceTotal.ToString

 

[sunnyjulka]

hi
thnks fro replying. I am using a dataset. Do you know what property of dataset would do the task for me.
thanks again

 

[mjb3030]

Like this:

For i as Int64 = 0 to dsInventory.Tables("MyTableName").Rows.Count - 1
    PriceTotal += dsInventory.Tables("MyTableName").Rows(i)("price")
Next

 

[sunnyjulka]

Hey thanks a lot. It works now.