Insert Data Using SqlCommandBuilder
来源:互联网 发布:多肉植物 淘宝 编辑:程序博客网 时间:2024/05/17 03:37
using System;
using System.Data;
using System.Data.SqlClient;
namespace Client.Chapter_13___ADO.NET
{
public class InsertingDataUsingCommandBuilder
{
static void Main(string[] args)
{
SqlConnection MyConnection = new SqlConnection(@"Data Source=(local); Initial Catalog = CaseManager; Integrated Security=true");
SqlDataAdapter MyDataAdapter = new SqlDataAdapter("SELECT ID, Contact, Email FROM Test", MyConnection);
SqlCommandBuilder MyCmd = new SqlCommandBuilder(MyDataAdapter);
DataSet MyDataSet = new DataSet();
MyDataAdapter.Fill(MyDataSet);
DataRow MyRow = MyDataSet.Tables[0].NewRow();
MyRow["ID"] = 200;
MyRow["Contact"] = "Greg";
MyRow["Email"] = "MacBeth";
MyDataSet.Tables[0].Rows.Add(MyRow);
MyDataAdapter.Update(MyDataSet);
}
}
}
using System.Data;
using System.Data.SqlClient;
namespace Client.Chapter_13___ADO.NET
{
public class InsertingDataUsingCommandBuilder
{
static void Main(string[] args)
{
SqlConnection MyConnection = new SqlConnection(@"Data Source=(local); Initial Catalog = CaseManager; Integrated Security=true");
SqlDataAdapter MyDataAdapter = new SqlDataAdapter("SELECT ID, Contact, Email FROM Test", MyConnection);
SqlCommandBuilder MyCmd = new SqlCommandBuilder(MyDataAdapter);
DataSet MyDataSet = new DataSet();
MyDataAdapter.Fill(MyDataSet);
DataRow MyRow = MyDataSet.Tables[0].NewRow();
MyRow["ID"] = 200;
MyRow["Contact"] = "Greg";
MyRow["Email"] = "MacBeth";
MyDataSet.Tables[0].Rows.Add(MyRow);
MyDataAdapter.Update(MyDataSet);
}
}
}
- Insert Data Using SqlCommandBuilder
- Deleting Data Using SqlCommandBuilder
- SqlCommandBuilder
- SqlCommandBuilder
- SqlCommandBuilder
- SqlCommandBuilder
- How to use insert or retrieve data by using Core Data in iOS
- Insert data into a table using table variables and cross join
- insert into data.mdb
- insert into data.mdb
- Data Structure: Insert Sort
- INSERT using WITH CHECK OPTION
- Insert Image using Spring JdbcTemplate
- Deleting Data Using SQLStatements
- Update Data Using Transactions
- Using Data Table Mappings
- Using Data Copy
- Using Data and Variables
- 如何让搜索引擎收录我的站[转]
- NET Pet Shop 的设计模式与体系结构【引自微软】
- No Subject
- Deleting Data Using SQLStatements
- 中国古典养生术中的心理放松的方法
- Insert Data Using SqlCommandBuilder
- My SQL的出错代码表
- Creating Connection To ODBC
- 《程序员》杂志06年2月文章:Flash Lite挑战J2ME
- DBGridEH应用实例(摘抄)
- illustrates how to perform a SELECT statement using ADO.NET
- Finding Rows In DataSet
- Connect to Access database
- 二分法——查找、排序以及库函数bsearch的用法