Accessing data using Inline Code

Question

I would like to create code within my aspx document to query data from a database.  I also want to update data in a database based on user input from a form.  I would like examples of code that does this inline as opposed to using the code-behind model.  I'd like to use SQL and a datareader to put data into a HTML table.  I would also like to put user inputted form values to place in a SQL update query.  I recognize that is not the ideal method to doing this and may be a bit outdated.  Can anyone provide an example?

Thanks