updating dataset from aspx not updating?

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

Hello,

I'm trying to update a dataset from an aspx where the
source data lives in a table in an Access mdb. Here is
what I have:

sub pageLoad(...)
dataset1.Clear()
dataAdapter1.Fill(dataset1, "tbl1")
end sub

sub btn(...)
Dim dr As Datarow
dr = dataset1.Tables("tbl1").Rows(6)
dr(0) = txt0.text
dr(1) = txt1.text
dr(2) = txt2.text
dataset1.Tables("tbl1").Rows(6).Item(0) = dr(0)
dataset1.Tables("tbl1").Rows(6).Item(1) = dr(1)
dataset1.Tables("tbl1").Rows(6).Item(2) = dr(2)
dataAdapter.Update(dataset1, "tbl1")

I think I need some kind of EndEdit statement, don't I?
but I don't know what it is. Any help appreciated.

Thanks,
Rich
 
I stand corrected. My dataset is updating. I hardcoded
the values. What is not happening is that I am not
retrieving the values from the textboxes on the aspx. Any
suggestions appreciated why I might not be retrieving
edited values from the textboxes on the aspx.

Thanks

P.S. I got rid of dataset1.Tables("tbl1").Rows
(6).Item=...
 
Are you building the textboxes dynamically

----- Rich wrote: ----

I stand corrected. My dataset is updating. I hardcoded
the values. What is not happening is that I am not
retrieving the values from the textboxes on the aspx. Any
suggestions appreciated why I might not be retrieving
edited values from the textboxes on the aspx

Thank

P.S. I got rid of dataset1.Tables("tbl1").Row
(6).Item=..
 
Back
Top