• visual c++ 2009 (vc9) + access 2007(accdb)..
|
![]() |
|
using namespace System::Data::OleDb;
/// <summary> /// Summary for Form1 /// /// WARNING: If you change the name of this class, you will need to change the /// 'Resource File Name' property for the managed resource compiler tool /// associated with all .resx files this class depends on. Otherwise, /// the designers will not be able to interact properly with localized /// resources associated with this form. /// </summary> public ref class Form1 : public System::Windows::Forms::Form { public: Form1(void) { InitializeComponent(); // //TODO: Add the constructor code here // }
protected: /// <summary> /// Clean up any resources being used. /// </summary> ~Form1() { if (components) { delete components; } } private: System::Windows::Forms::DataGridView^ dataGridView1; protected:
private: /// <summary> /// Required designer variable. /// </summary> System::ComponentModel::Container ^components;
#pragma region Windows Form Designer generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> void InitializeComponent(void) { this->dataGridView1 = (gcnew System::Windows::Forms::DataGridView()); (cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dataGridView1))->BeginInit(); (cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dataSet1))->BeginInit(); this->SuspendLayout(); // // dataGridView1 // this->dataGridView1->ColumnHeadersHeightSizeMode = System::Windows::Forms::DataGridViewColumnHeadersHeightSizeMode::AutoSize; this->dataGridView1->Location = System::Drawing::Point(12, 12); this->dataGridView1->Name = L"dataGridView1"; this->dataGridView1->Size = System::Drawing::Size(268, 198); this->dataGridView1->TabIndex = 0;
// // Form1 // this->AutoScaleDimensions = System::Drawing::SizeF(6, 13); this->AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font; this->ClientSize = System::Drawing::Size(362, 322); this->Controls->Add(this->dataGridView1); this->Name = L"Form1"; this->Text = L"Form1"; this->Load += gcnew System::EventHandler(this, &Form1::Form1_Load); (cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dataGridView1))->EndInit(); (cli::safe_cast<System::ComponentModel::ISupportInitialize^ >(this->dataSet1))->EndInit(); this->ResumeLayout(false);
} #pragma endregion private: System::Void Form1_Load(System::Object^ sender, System::EventArgs^ e) { System::Data::DataSet^ ds = gcnew System::Data::DataSet();
OleDbConnection^ conn = gcnew OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\\Database1.accdb;Persist Security Info=True");
OleDbCommand^ com = gcnew OleDbCommand(); com->Connection = conn; com->CommandText = "select * from table1";
OleDbDataAdapter^ adapt = gcnew OleDbDataAdapter();
adapt->SelectCommand = com;
adapt->Fill(ds, "dt1");
dataGridView1->DataSource = ds->Tables["dt1"];
} };
|



Subject