I am making a page to do the database modification, however, i used some autopostback properties in the page, once the autopostback is executed, the data on the textbox are set to initial values, I have an idea, I want to do the SQL query in the Page_Init(), but How could I set the initial values in the textbox control. I've wrote the code to creat the dataset, but I just don't know how to display it in the textbox, I know that I can't use the datagrid, cause I have to use the textbox to finish the database modification.

Any ideas will be appreciated.

Thanks in advance.

Why can't you use a DataGrid? The DataGrid is an ideal candidate for on-line editting.
You can set a row to editable, and then supply a template for the editable row. This will allow you to present textbox, dropdown etc so the user can supply new data.

Check out the following articles about the DataGrid:

http://msdn.microsoft.com/library/de...verControl.asp

http://msdn.microsoft.com/library/de...asp?frame=true

http://msdn.microsoft.com/library/de...asp?frame=true

Alternatively, you can use a Repeater control, add textboxes to the template, and then bind the DataSet to the Repeater.

If this is not what you're after, please be more specific about what you're trying to accomplish.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.