C++/CLI บน Access 2003 Advance

private: System::Void ToolStripMenuItemAdd_Click(System::Object^ sender, System::EventArgs^ e) {
FormAdd ^f = gcnew FormAdd();
f->Show();
f->MdiParent = this;// ถ้าไม่ใส่ตัวนี้มันเด้งออกนอกกรอบ
}
private: System::Void ToolStripMenuItemRep_Click(System::Object^ sender, System::EventArgs^ e) {
FormReport ^f = gcnew FormReport();
f->Show();
f->MdiParent = this;// ถ้าไม่ใส่ตัวนี้มันเด้งออกนอกกรอบ
}

 

ส่วนมากโปรแกรม C++/CLI บน Windows 8 เฟี้ยน ๆ บางเรื่อง เช่น คำสั่ง safe_cast

 

การ Double Click ListView เพื่อแก้ไขข้อมูล (C++/CLI)
===============================

 

FormEdit.h
=====================
#pragma endregion
private: System::Void FormEdit_Load(System::Object^ sender, System::EventArgs^ e){
cnn = gcnew OleDbConnection(conStr);

String ^sql = "SELECT CodePK,CodeID,PickerUp,Coffee,BookID, " +
"Book,Caraboa,OilName,OilPrice,Eat,Telephone,Merit,Other " +
"FROM tblPay " +
"WHERE " +
"([CodePK] Like '%" + strID + "%') ";

if (cnn->State == ConnectionState::Open){
cnn->Open();
}

cmd = gcnew OleDbCommand(sql, cnn);
da = gcnew OleDbDataAdapter(cmd);
ds = gcnew DataSet();
da->Fill(ds, "pay");

DataTable ^table = ds->Tables["pay"];

DataRow ^row = table->Rows[0];
if (table->Rows->Count > 0){
txtCodePK->Text = row["CodePK"]->ToString();
txtCodeID->Text = row["CodeID"]->ToString();
dateTimePicker1->Value = DateTime:arse(row["PickerUp"]->ToString());
txtCoffee->Text = String::Format("{0:#,##0.00}", Convert::ToDecimal(row["Coffee"]));
txtBookID->Text = String::Format("{0:#,##0.00}", Convert::ToDecimal(row["BookID"]));//BookID
txtBook->Text = String::Format("{0:#,##0.00}", Convert::ToDecimal(row["Book"]));//Book
txtCaraboa->Text = String::Format("{0:#,##0.00}", Convert::ToDecimal(row["Caraboa"]));//Caraboa
comboBox1->Text = row["OilName"]->ToString();//OilName
txtOilPrice->Text = String::Format("{0:#,##0.00}", Convert::ToDecimal(row["OilPrice"]));//OilPrice
txtEat->Text = String::Format("{0:#,##0.00}", Convert::ToDecimal(row["Eat"]));//Eat
txtTelephone->Text = String::Format("{0:#,##0.00}", Convert::ToDecimal(row["Telephone"]));//Telephone
txtMerit->Text = String::Format("{0:#,##0.00}", Convert::ToDecimal(row["Merit"]));//Merit
txtOther->Text = String::Format("{0:#,##0.00}", Convert::ToDecimal(row["Other"]));//Other
}
cnn->Close();
}
private: System::Void btnEdit_Click(System::Object^ sender, System::EventArgs^ e) {
cnn = gcnew OleDbConnection(conStr);
cnn->Open();
cmd = gcnew OleDbCommand("update tblPay set " +
"CodePK=@CodePK,CodeID=@CodeID, PickerUp = @PickerUp,Coffee=@Coffee ," +
"BookID=@BookID,Book=@Book ,Caraboa=@Caraboa ,OilName=@OilName ,OilPrice=@OilPrice , " +
"Eat=@Eat ,Telephone=@Telephone ,Merit=@Merit,Other=@Other " +
"where CodePK=" + txtCodePK->Text +
" ", cnn);

String ^dt = dateTimePicker1->Value.ToString("dd/MM/yyyy");

cmd->Parameters->AddWithValue("CodePK", txtCodePK->Text);
cmd->Parameters->AddWithValue("CodeID", txtCodeID->Text);
cmd->Parameters->AddWithValue("PickerUp", dt);
cmd->Parameters->AddWithValue("Coffee", txtCoffee->Text);
cmd->Parameters->AddWithValue("BookID", txtBookID->Text);
cmd->Parameters->AddWithValue("Book", txtBook->Text);
cmd->Parameters->AddWithValue("Caraboa", txtCaraboa->Text);
cmd->Parameters->AddWithValue("OilName", comboBox1->Text);
cmd->Parameters->AddWithValue("OilPrice", txtOilPrice->Text);
cmd->Parameters->AddWithValue("Eat", txtEat->Text);
cmd->Parameters->AddWithValue("Telephone", txtTelephone->Text);
cmd->Parameters->AddWithValue("Merit", txtMerit->Text);
cmd->Parameters->AddWithValue("Other", txtOther->Text);

int n = cmd->ExecuteNonQuery();
cnn->Close();
if (n > 0){
MessageBox::Show("แก้ไขข้อมูลเรียบร้อยแล้ว","รายงานสถานะ");
txtCodePK->Text = "";
txtCodeID->Text = "";
dateTimePicker1->Text = "";
txtCoffee->Text = "0.00";
txtBookID->Text = "0.00";
txtBook->Text = "0.00";
txtCaraboa->Text = "0.00";
comboBox1->Text = "";
txtOilPrice->Text = "0.00";
txtEat->Text = "0.00";
txtTelephone->Text = "0.00";
txtMerit->Text = "0.00";
txtOther->Text = "0.00";
}
else{
MessageBox::Show("เกิดข้อผิดพลาดในการแก้ไขข้อมูล","รายงานสถานะ");
}
}
private: System::Void btnClose_Click(System::Object^ sender, System::EventArgs^ e) {
this->Close();
}
private: System::Void FormEdit_FormClosing(System::Object^ sender, System::Windows::Forms::FormClosingEventArgs^ e) {
if (cnn->State == ConnectionState::Open){
cnn->Close();
}
}