update Textbox

[Zal]

i do hope someone out there can help me,
ive been stuck on the same problem fro two weeks and im gonig mad.

I have a aspx page.

This page connects to a sql server 200 database.

This page is my own login page which i have created. the user enters
in their surname and password. a stored procedure is then run to check
if they exist, if they exist the details are then put into a session
dataset, and passed onto the next page if the user presses a button
called check details.

i have been able to get the details on the second aspx page. eg their
personal details. these are on textboxes
for example. i enter my surname and password, it is correct and i
click the button which says checdetails.i am then redirected to the
second aspx page which then draws individual textboxes with my details
in the correct textboxes.

eg. textbox1.text is equal to the value of my firstname.

I want to be able to re-enter a value into the textbox with a new
value and then update the dataset which then will update the actual
database

i have read so many diffenret articles, i need a simple example that
has one textbox which is equal to the value of the a field from the
database table.e.g. textbox1.text = dataview.item(0).item("firstname")
i want to see the orginal value, but then i want ot be able to click
into the textbox and enter in a new value, and then wen i hit the
submit button for the process of updating begin.

i understand that i have to use the updatecmmand and the select
command

i have tried the dataadapter.updatecommand feature, and it doesnt
return any errors but it doesnt update the fieilds

HELP ME PLEASE

many thanxz in advance

Zal

 

[Scott M.]

DataAdapter.Update(), not updateCommand (that is a property).

 

[Zal]

Scott,

Thanks but i do have the final statement as
dataadapter.update()

the exact line i do is :
MyDataAdapter.update(MyDataSetUpdate.tables("MYTABLENAME"))
so where i am going wrong?????????????????????????????????