Updating database in asp


Open your instance of Visual Studio 2012, and create a new ASP. Name the project “MYSQLCRUDApplication ", as shown in the following figure: In the code behind file (cs) write the code as in the following. Now, enter the student data insert and Grid view Show Data. Now, select the Student then show the data Text Box and update the data shown in the Message box “Student Data update successfully”.

Now, delete the Student data shown in the Message box “Student Data Delete Successfully”. If you have any other questions then please provide your comments below.

Future installments will explore more advanced updating scenarios, such as customizing the Grid View's editing interface and programmatically setting the updated values. The UPDATE Table Name SET Column Name1 = @Parameter Value1 Column Name2 = @Parameter Value2 ...

Column Name N = @Parameter Value N WHERE Primary Key Column Name1 = @Primary Key Value To Update1 AND Primary Key Column Name2 = @Primary Key Value To Update2 AND ...

Updating data through manually-created Web Forms is a bit more difficult and less practical because the Web controls that make up the updating interface must also be populated with the values of the record being edited.