Connection with SQL Server Part 6

SQLCommand

• SqlCommand deals with databases. It executes SQL commands on a database. It sends an SQL command to a database that is specified by an SqlConnection object. We then call instance methods to physically apply the command to the database.

• It is Responsible to execute SQL Query 

It is Required to Open Connection with the SqlCommand Class

using Open() Method and after, We Use the ExecuteNonQuery() method for Execute Query and after all we must close the connection using close() method