help with DDLS!

[jiasheng]

It really depends on your implementation for your datagrid...

if those are queried from DB then you can do this..

 

i assume its like a shopping cart with each cart having a manifest number.

then the implementation will be

 

after you fill ur dataset with the items data,

you can do this.

 

dim row ds.tables[0].rows.newrow() as Datarow

 

row["columnnamefordescription"] = "total"

 

change ur command syntax to

cmd.commandstring = "select sum(price *qty) from carttable where manifestId = @id"

cmd.parameters.clear()

cmd.parameters.add("@id",manifestID)

 

cn.open()

dim dr = cmd.executedatareader as DataReader

dr.read

row["columnnameforamount"] = dr[0]

cn.close()

 

ds.tables.rows.add(row)

 

then do ur databinding...

add in error handling as well..

[ethan_seahz]

Private Sub DataGrid1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DataGrid1.SelectedIndexChanged

Dim indexes As String

Dim images As String

 

 

 

'indexes = DataGrid1.SelectedItem.Cells(2).Text

'images = DataGrid1.SelectedItem.Cells(3).Text

 

 

' Global variable

Dim sum As Integer = 0

 

' Loop through gridview

For Each item As DataGridItem In DataGrid1.Items

 

' first column value in the gridview

sum += CInt(row.Cells(0).Text) ------------> i duno what to declare row as.??

Next row

 

Label13.Text = indexes

Label14.Text = images

 

End Sub

[jiasheng]

You mean your data grid is generated on the fly??

[ethan_seahz]

on the fly?

[ethan_seahz]

i dragged and dropped it from vb.net 03

[ethan_seahz]

Dim row As DataSet

 

sum += CInt(row.Cells(0).Text)

 

c:\inetpub\wwwroot\presentationLayer\generateDO.aspx.vb(113): 'Cells' is not a member of 'System.Data.DataSet'.

[jiasheng]

i suggest u store ur dataset in your cache or session..

then u access your data using the index in the dataset

 

ds.tables[0].rows[DataGrid1.selectedIndex]

[jiasheng]

i meant that the data is not retreived from the DB. meaing u add in new rows by urself..

[ethan_seahz]

jiasheng. thanks.