Deleting Data Using SqlCommandBuilder
来源:互联网 发布:下载类网站源码 编辑:程序博客网 时间:2024/05/17 00:02
Deleting Data Using SqlCommandBuilder
/*
* C# Programmers Pocket Consultant
* Author: Gregory S. MacBeth
* Email: gmacbeth@comporium.net
* Create Date: June 27, 2003
* Last Modified Date:
* Version: 1
*/
using System;
using System.Data;
using System.Data.SqlClient;
namespace Client.Chapter_13___ADO.NET
{
public class DeletingDataUsingCommandBuilder
{
static void Main(string[] args)
{
SqlConnection MyConnection = new SqlConnection(@"Data Source=(local); Initial Catalog = CaseManager; Integrated Security=true");
SqlDataAdapter MyDataAdapter = new SqlDataAdapter("SELECT * FROM Test", MyConnection);
SqlCommandBuilder MyCmd = new SqlCommandBuilder(MyDataAdapter);
DataSet MyDataSet = new DataSet();
MyDataAdapter.Fill(MyDataSet);
DataColumn[] MyKey = new DataColumn[1];
MyKey[0] = MyDataSet.Tables[0].Columns[0];
MyDataSet.Tables[0].PrimaryKey = MyKey;
DataRow FindMyRow = MyDataSet.Tables[0].Rows.Find(1);
FindMyRow.Delete();
MyDataAdapter.Update(MyDataSet);
}
}
}
- Deleting Data Using SqlCommandBuilder
- Insert Data Using SqlCommandBuilder
- Deleting Data Using SQLStatements
- SqlCommandBuilder
- SqlCommandBuilder
- SqlCommandBuilder
- SqlCommandBuilder
- handlersocket使用 第五章 Updating/Deleting data
- Error "Lock NOT set for: Deleting transaction data selectively"
- Update Data Using Transactions
- Using Data Table Mappings
- Using Data Copy
- Using Data and Variables
- Using data-* attribute
- Data rates using BLE
- data lab using zeppelin
- sort data using Python3
- using OPENDATASOURCE Select Access Data Base data
- 关于原始输入--XP新技术(原创,转载请注明出处)
- use a relationship between two DataTable
- 使用正则表达式将Html转换为纯文本
- illustrates the use of a DataView object to filter and sort rows
- datagrid的数据分层
- Deleting Data Using SqlCommandBuilder
- 如何让搜索引擎收录我的站[转]
- NET Pet Shop 的设计模式与体系结构【引自微软】
- No Subject
- Deleting Data Using SQLStatements
- 中国古典养生术中的心理放松的方法
- Insert Data Using SqlCommandBuilder
- My SQL的出错代码表
- Creating Connection To ODBC