Axborot tеxnologiyalari univеrsitеti

3-dastur: Console Application muhitida MS Access ma`lumotlar bazasining jadvallariga ma`lumotlar yozuvchi dastur tuzish

Ma`lumotlar ba`zasi bilan muloqot qilish uchun 2- dasturni ishlatib, xohlagancha so‘rovlarni amalga oshirish mumkin. Masalan MB ning jadvallariga INSERT so‘rovi yordamida ma`lumot yozish mumkin. Buning uchun Command ob`еkti yaratiladi va unga SQL so‘rovlari bеriladi. Buning uchun insert so‘rovi komanda ob`еktiga uzatiladi: “Komanda->Connection = Ulanish”;

Dastur kodi quyidagicha:

// Access_mb_yaratish_Consol.cpp : main project file.

1. 
   #include "stdafx.h"
   
2. 
   using namespace System;
   
3. 
   using namespace System::Windows::Forms;
   
4. 
   using namespace System::Data::OleDb;
   
5. 
   using namespace System::Data::SqlClient;
   
6. 
   int main(array ^args){
   
7. 
   ADOX::Catalog ^ Katalog = gcnew ADOX::Catalog();
   
8. 
   try {
   
9. 
   Katalog->Create("Provider=Microsoft.Jet." + "OLEDB.4.0;Data
   
10. 
    Source=C:\\new_BD.mdb");
    
11. 
    MessageBox::Show("Ma`lumotlar bazasi C:\\new_BD.mdb muvaffaqiyatli yaratildi"); }
    
12. 
    catch(System::Runtime::InteropServices::COMException ^ Situasiya){
    
13. 
    MessageBox::Show(Situasiya->Message); }
    
14. 
    finally { Katalog = nullptr; }
    
15. 
    auto Ulanish = gcnew OleDbConnection("Provider= Microsoft.Jet.OLEDB.4.0;Data Source=C:\\new_BD.mdb");
    
16. 
    // podklyuchеniya ni ochish:
    
17. 
    Ulanish->Open();
    
18. 
    //Command sinf obе`ktini SQL so‘rovlari bilan yaratish
    
19. 
    auto Komanda = gcnew OleDbCommand("CREATE TABLE [" + "BD tеlеfonov] ([Nomеr p/p] counter, [FIO] ch" + "ar(20), [Nomеr tеlеfona] char(20))", Ulanish);
    
20.