Can Anyone Please Give Me Some Ideas

[nituquest]

I have an asp page with a table filled with data from sql server table. I want to give to the user, the ability to update the records in this page itself. for example, if user click on a cell, it should allow the user to change the content and then be able to update the sql table with these new updated values. I know there is this editable content feature to use to make a cell editable, but iam kinda stuck on how to retrive the updated values and insert/update them to the sql table.

I hope someone can help me out on this. Your help will be highly appreciated

[benbramz]

Hi there!

basicly, what you wouold need is a RsObj.update command for your updated info.

however, first step would be to figure out how exactly you need to edit the data.

now im assuming some knowledge of asp? if not just say and ill jump back a step..basicly what we want to do is loop through the records and add them in a <table>, and then provide an "edit" link, so we could do somthing like;
response.write "edit.asp?recordID=" & rsobj("id")
then have a page to grab that querysting, and display the data for that into form fields. then on submitting thre form, just update the info.

another way would be to loop through the recordset, putting all infomration from all records into form boxes, using a loop again, then upon submitting the entire form, loop through and edit the information. not reccomened though, as the server load would be much higher.

what would you like to happen (in detail)?