ASP.NET by Example

System.Data.SqlClient Namespace

The System.Data.SqlClient namespace is the .NET Data Provider for SQL Server. The classes in this namespace bypass OLE DB and communicate directly with SQL Server, therefore increasing performance tremendously when using SQL Server.

SqlCommand Object Members

The SqlCommand class represents a Transact-SQL query or stored procedure to execute at a SQL Server database. Tables B.43 through B.46 list the constructor, properties, methods, and events for the SqlCommand class.

Table B.43. SqlCommand Constructor

Name	Parameters	Description
SqlCommand	none	Initializes a new instance of the SqlCommand class.
SqlCommand	cmdText (String)	Initializes a new instance of the SqlCommand class with the specified command text.
SqlCommand ...