会python真的可以为所欲为0(回)
380天前
这里还有人吗1(回)
565天前这里还有人吗0(回)
565天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
790天前到处都是羊，不想上班0(回)
870天前
鸽子
0(回)
874天前#include "stdafx.h" |
using namespace System; |
using namespace System::Data; |
using namespace System::Data::OleDb; |
ref struct MyEventHandler |
{ |
static void RowUpdated(Object^ sender, OleDbRowUpdatedEventArgs^ e) |
{ |
if ( e->Status == UpdateStatus::ErrorsOccurred ) |
throw "Row update failed!"; |
} |
}; |
void main() |
{ |
OleDbConnection^ myConnection = nullptr; |
OleDbTransaction^ myTransaction = nullptr; |
|
try |
{ |
myConnection = gcnew OleDbConnection( |
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Music.mdb"); |
myConnection->Open(); |
|
OleDbDataAdapter^ dataAdapter = gcnew OleDbDataAdapter( |
"SELECT * FROM Music", myConnection); |
OleDbCommandBuilder^ commandBuilder = gcnew OleDbCommandBuilder(dataAdapter); |
dataAdapter->UpdateCommand = commandBuilder->GetUpdateCommand(); |
|
dataAdapter->RowUpdated += gcnew OleDbRowUpdatedEventHandler(MyEventHandler::RowUpdated); |
|
DataSet^ myDataSet = gcnew DataSet(); |
dataAdapter->MissingSchemaAction = MissingSchemaAction::AddWithKey; |
dataAdapter->Fill(myDataSet); |
|
myTransaction = myConnection->BeginTransaction(); |
|
DataTable^ myTable = myDataSet->Tables[0]; |
|
DataRow^ row = myTable->Rows->Find("Automatic"); |
if ( row != nullptr ) |
row["Title"] = "Automatic (Dance Mix)"; |
row = myTable->Rows->Find("EnTrance"); |
if ( row != nullptr ) |
row["GenreName"] = "Trance"; |
|
dataAdapter->Update(myDataSet); |
myTransaction->Commit(); |
} |
catch(Exception^ e) |
{ |
Console::WriteLine(e->Message); |
if ( myTransaction != nullptr ) |
{ |
myTransaction->Rollback(); |
Console::WriteLine("Transaction rolled back."); |
} |
} |
finally |
{ |
myConnection->Close(); |
} |
} |
初级程序员
by: 云代码会员 发表于：2016-09-24 11:11:39 顶(0) | 踩(0) 回复
不错
回复评论