Open Source RDBMS - Seamless, Scalable, Stable and Free

English | Login |Register

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 CUBRIDCommand 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 CUBRIDParameters collection of the CUBRIDCommand object.

 

In This Section

Modifying Data in a Data Source

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

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.

Writing CLOB Values to a Data Source

Describes how to write a character large object (CLOB) to a database as character data.

 

comments powered by Disqus
문서 정보
viewed 802 times
번역 en
작성자
posted 작년
kevinyang
공헌자
마지막 수정시간 작년
변경 내역 보기
Share this article