OracleCommandBuilder

最新推荐文章于 2024-11-20 17:59:47 发布

无名!

最新推荐文章于 2024-11-20 17:59:47 发布

阅读量3.3k

点赞数

分类专栏： Oracle Data Provider for .NET 学习笔记文章标签： dataset table manager string command

本文链接：https://blog.youkuaiyun.com/abaloneking/article/details/185248

版权

Oracle Data Provider for .NET 学习笔记专栏收录该内容

10 篇文章

订阅专栏

此博客展示了一段代码，利用OracleDataAdapter和OracleCommandBuilder更新数据集表信息。通过创建适配器、构建器，填充数据集，获取数据表和行，修改数据后使用适配器更新EMPINFO表，将'KING'的职位描述改为'MANAGER'。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

public static void BuilderUpdate(string connStr)
{
string cmdStr = "SELECT EMPNO, EMPNAME, JOBDESCRIPTION FROM EMPINFO";

//create the adapter with the selectCommand txt and the
//connection string
OracleDataAdapter adapter = new OracleDataAdapter(cmdStr, connStr);

//get the connection from the adapter
OracleConnection connection = adapter.SelectCommand.Connection;

//create the builder for the adapter to automatically generate
//the Command when needed
OracleCommandBuilder builder = new OracleCommandBuilder(adapter);

//Create and fill the DataSet using the EMPINFO
DataSet dataset = new DataSet();

adapter.Fill(dataset, "EMPINFO");

//Get the EMPINFO table from the dataset
DataTable table = dataset.Tables["EMPINFO"];

//Get the first row from the EMPINFO table
DataRow row0 = table.Rows[0];

//update the job description in the first row
row0["JOBDESCRIPTION"] = "MANAGER";

//Now update the EMPINFO using the adapter, the job description
//of ’KING’ is changed to ’MANAGER’
//The OracleCommandBuilder will create the UpdateCommand for the
//adapter to update the EMPINFO table
adapter.Update(dataset, "EMPINFO");
}