I am making a page which allows the user to edit a specific row based on the querystring value. What is the best way to load data into the textboxes and to reflect the changes back to the database.
Request -> example.com/editpage.aspx?id=123
The page should display data from row with id=123 into a couple of textboxes. Then the user can edit those textboxes and press save. The new values of the textboxes should be saved back to the database in row with id=123.
I have already achieved this functionality but with lots of code and manually connecting to the database with , SqlConnection, DataSet and DataAdapter classes. I want to know if there is a better way of doing the same.