SQLite3 и DataGridView

#pragma once
#include "sqlite3.h"
#include <Windows.h>
namespace course {
 
    using namespace System;
    using namespace System::ComponentModel;
    using namespace System::Collections;
    using namespace System::Windows::Forms;
    using namespace System::Data;
    using namespace System::Drawing;
    using namespace System::Text;
    using namespace System::Runtime::InteropServices;
 
    public ref class MyForm2 : public System::Windows::Forms::Form
    {
    public:
        MyForm2(void)
        {
            InitializeComponent();
        }
 
    protected:
        ~MyForm2()
        {
            if (components)
            {
                delete components;
            }
        }
 
    private: System::Windows::Forms::Button^ button2;
    private: System::Windows::Forms::DataGridView^ dataGridView1;
 
    protected:
    private: System::Windows::Forms::Button^ button1;
    protected:
 
    private:
        const char* ConvertToCString(String^ str) {
            array<Byte>^ bytes = Encoding::UTF8->GetBytes(str);
            pin_ptr<Byte> pinnedBytes = &bytes[0];
            const char* c_str = reinterpret_cast<const char*>(pinnedBytes);
            return c_str;
        };
        System::ComponentModel::Container^ components;
 
#pragma region Windows Form Designer generated code
        void InitializeComponent(void)
        {
            this->button1 = (gcnew System::Windows::Forms::Button());
            this->button2 = (gcnew System::Windows::Forms::Button());
            this->dataGridView1 = (gcnew System::Windows::Forms::DataGridView());
            (cli::safe_cast<System::ComponentModel::ISupportInitialize^>(this->dataGridView1))->BeginInit();
            this->SuspendLayout();
            // 
            // button1
            // 
            this->button1->BackColor = System::Drawing::Color::DeepSkyBlue;
            this->button1->FlatAppearance->BorderSize = 0;
            this->button1->FlatStyle = System::Windows::Forms::FlatStyle::Flat;
            this->button1->Font = (gcnew System::Drawing::Font(L"Calibri", 10));
            this->button1->Location = System::Drawing::Point(12, 289);
            this->button1->Margin = System::Windows::Forms::Padding(2);
            this->button1->Name = L"button1";
            this->button1->Size = System::Drawing::Size(181, 37);
            this->button1->TabIndex = 2;
            this->button1->Text = L"Отмена";
            this->button1->UseVisualStyleBackColor = false;
            this->button1->Click += gcnew System::EventHandler(this, &MyForm2::button1_Click);
            // 
            // button2
            // 
            this->button2->BackColor = System::Drawing::Color::DeepSkyBlue;
            this->button2->FlatAppearance->BorderSize = 0;
            this->button2->FlatStyle = System::Windows::Forms::FlatStyle::Flat;
            this->button2->Font = (gcnew System::Drawing::Font(L"Calibri", 10));
            this->button2->Location = System::Drawing::Point(451, 288);
            this->button2->Margin = System::Windows::Forms::Padding(2);
            this->button2->Name = L"button2";
            this->button2->Size = System::Drawing::Size(181, 37);
            this->button2->TabIndex = 4;
            this->button2->Text = L"Удалить заявку";
            this->button2->UseVisualStyleBackColor = false;
            // 
            // 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(619, 261);
            this->dataGridView1->TabIndex = 5;
            // 
            // MyForm2
            // 
            this->AutoScaleDimensions = System::Drawing::SizeF(6, 13);
            this->AutoScaleMode = System::Windows::Forms::AutoScaleMode::Font;
            this->BackColor = System::Drawing::Color::FromArgb(static_cast<System::Int32>(static_cast<System::Byte>(192)), static_cast<System::Int32>(static_cast<System::Byte>(255)),
                static_cast<System::Int32>(static_cast<System::Byte>(255)));
            this->ClientSize = System::Drawing::Size(643, 336);
            this->Controls->Add(this->dataGridView1);
            this->Controls->Add(this->button2);
            this->Controls->Add(this->button1);
            this->FormBorderStyle = System::Windows::Forms::FormBorderStyle::FixedToolWindow;
            this->Margin = System::Windows::Forms::Padding(2);
            this->Name = L"MyForm2";
            this->Text = L"Удаление пользователя";
            this->Load += gcnew System::EventHandler(this, &MyForm2::MyForm2_Load);
            (cli::safe_cast<System::ComponentModel::ISupportInitialize^>(this->dataGridView1))->EndInit();
            this->ResumeLayout(false);
 
        }
#pragma endregion
private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) {
    this->Close();
}
private: System::Void MyForm2_Load(System::Object^ sender, System::EventArgs^ e) {
    sqlite3* db;
    int rc = sqlite3_open_v2("database.db", &db, SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, nullptr);
    if (rc != SQLITE_OK) {
        MessageBox::Show("Ошибка открытия базы данных: " + gcnew System::String(sqlite3_errmsg(db)));
        sqlite3_close(db);
        return;
    }
    dataGridView1->Columns->Add("surname", "Фамилия");
    dataGridView1->Columns->Add("name", "Имя");
    dataGridView1->Columns->Add("otname", "Отчество");
    dataGridView1->Columns->Add("destination", "Пункт назначения");
    dataGridView1->Columns->Add("date", "Дата вылета");
    dataGridView1->Columns->Add("number", "Номер рейса");
 
    const char* sqlSelect = "SELECT surname, name, otname, destination, date, number FROM zayavki;";
    sqlite3_stmt* stmt;
    rc = sqlite3_prepare_v2(db, sqlSelect, -1, &stmt, nullptr);
    if (rc != SQLITE_OK) {
        MessageBox::Show("Ошибка выполнения запроса: " + gcnew System::String(sqlite3_errmsg(db)));
        sqlite3_finalize(stmt);
        sqlite3_close(db);
        return;
    }
    while (sqlite3_step(stmt) == SQLITE_ROW) {
        String^ surname = gcnew String((const char*)sqlite3_column_text(stmt, 0));
        String^ name = gcnew String((const char*)sqlite3_column_text(stmt, 1));
        String^ otname = gcnew String((const char*)sqlite3_column_text(stmt, 2));
        String^ destination = gcnew String((const char*)sqlite3_column_text(stmt, 3));
        String^ date = gcnew String((const char*)sqlite3_column_text(stmt, 4));
        String^ number = gcnew String((const char*)sqlite3_column_text(stmt, 5));
        array<String^>^ row = { surname, name, otname, destination, date, number };
        dataGridView1->Rows->Add(row);
    }
    sqlite3_finalize(stmt);
    sqlite3_close(db);
}
};
}