Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

Updating Data Sources with Commands 

Using a .NET Framework data provider, you can execute stored procedures or data definition language statements (for example, CREATE TABLE and ALTER COLUMN) to perform schema manipulation on a database or catalog. These commands do not return rows as a query would, so the Command object provides an ExecuteNonQuery to process them.

In addition to using ExecuteNonQuery to modify schema, you can also use this method to process SQL statements that modify data but that do not return rows, such as INSERT, UPDATE, and DELETE.

Although rows are not returned by the ExecuteNonQuery method, input and output parameters and return values can be passed and returned via the Parameters collection of the Command object.

In This Section

Modifying Data in a Data Source

Describes how to execute commands or stored procedures that modify data in a database.

Performing Catalog Operations

Describes how to execute commands that modify database schema.

Writing BLOB Values to a Data Source

Describes how to write a binary large object (BLOB) to a database as either binary or character data.

See Also

Community Additions

ADD
Show:
© 2015 Microsoft