inserting data from a asp.net page to sqlserver database

Question

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.

Kamran Khan · Accepted Answer · 2010-09-29 07:27:20Z

1

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.

edited Sep 29, 2010 at 7:27

answered Sep 29, 2010 at 7:07

Kamran Khan

9,9842 gold badges33 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

inserting data from a asp.net page to sqlserver database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related