inserting data from a asp.net page to sqlserver database

Question

hi, there are two tables in database.

one is 'books' with 4 columns

pkid,title,price,writer(int)

and other is 'persons' with columns

pkid, name,value(int).

one asp.net page is there with text boxes named

title,price,writer and a submit button. 

i want that on filling that writer txtbox with some name which is available in 'persons' table and clicking that submit button it will store integer 'value' in 'books' writer column.

Answer 1

well, query for the writer corresponding to the name data, and retrieve it's value. it's quite simple

Answer 2

Its simple.

• On your asp.net page, you can replace the writer textbox with a DropDownList
• Populate the DropDownList with all of the persons available in your Persons table, when your page loads.
• On submit button click event,
  • Make a connection to database
  • Update the record, with some update table set like query.
• Reload the page with thanks!

But before all of this, I would suggest you go through basic crud operations using asp.net and how they are achieved. Here are some asp.net quick start tutorials.