Can't update a sessioned dataview

[RandyBlackburn]

I created a dataview on one aspx.vb page, and I'm successfully using it on another page by bringing it in a sessioned variable. However, if I change the value of one of the fields in the dataview on the second page, it does not change the database. Can this be done without setting up a new sqladapter and dataset in the second page?

The statement I am using to change the data is:

dvemplogin.Item(0)("password") = encryptedPassword

Thanks in advance,
Randy

 

[jbenson001]

If you don't want to use a dataadapter then you will have to loop through the datatable's rows, get the values and create Update statment. Then execute for each row of the datatable.

 

[RandyBlackburn]

Thanks Jim...
I ended up passing the sqladapter as a session, and issuing the update to it... worked great

Randy

 

[jbenson001]

cool.. glad you got it working..