Step 10: perform operations on SQL Server in Asp.net

The most common steps to operate databases using SQL commands are as follows:Program.

1. Create a sqlconnection object (sqlconnection con = new sqlconnection ();)
2. connectionstring attribute assignment (connection string, Con. connectionstring = "";)
3. Con. open ()

4. Create a sqlcommand object (sqlcommand COM = new sqlcommand ();)
5. assign values to the commandtext attribute (SQL statement)
6. assign values to the commandtype attribute (commandtype. Text)
7. assign a value to the connection attribute (the sqlconnection object is assigned)
8. execute commands (executenonquery, executereader)

9. perform operations on the database return results

10. Close () of sqlconnection ()