Friday, 29 April 2016

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
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Part 20 consuming rest api in ionic

in this video, I will show you that how you can consume the rest API. in the previous video we have implemented the asp.net web API projec...

  • ASP.NET
    ASP.NET Supports all Browsers  The Best advantage of ASP.NET is  all Browsers supports . One of the greatest challenges web developers ...
  • Connection with SQL Server Part 5
    SQLDataAdapter DataAdapter serves as a bridge between a DataSet and SQL Server for retrieving and saving data. We can use SqlDataAdapte...
  • Part 15 how to use loadig in ionic
    in this video, I will show you that how you can create loading component in your ionic application. The Loading component is an overlay t...