Updating database in asp net
It's free and takes approximately one minute to sign up.
You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions.
In this example, this time I used my own database called Sample DB which has Customers Table and basically contains the following field columns: As you have noticed in STEP 2, we have added six Text Box and a Button in the web form in order for us to type the information there and Insert them to the database.
Now let’s create a method for executing the Update or Insert.
Therfore you you run an: "UPDATE tble Nem SET field Name = some Value WHERE ID IN (request.form("check Box Name"));" mmmmm. You want to execute an update if a checkbox is clicked?
If the user clicks on the button in the "customer ID" column he or she will be taken to a new file called "demo_update.asp".