[Update] HSM เพิ่มDelete staff และ ตัวเก็บdata ห้องที่ติ้กถูก

[NokiaTh131]

Edited code

private: System::Void MyForm_Load(System::Object^ sender, System::EventArgs^ e) { listView4->Items->Clear(); listView2->Items->Clear(); listView5->Items->Clear(); checkedListBox1->Items->Clear(); comboBox1->Items->Clear(); comboBox2->Items->Clear(); comboBox3->Items->Clear(); // Your connection string String^ connString = "Data Source=localhost;Initial Catalog=ROOOM;Integrated Security=True";

// SQL query to retrieve the data
String^ query = "SELECT Id FROM [Table]";
String^ query2 = "SELECT Staff FROM [Staff_Table]";
String^ query3 = "SELECT Item,Room,Time,Date,WhoFound,Phone_number FROM [Lost_Found]";
String^ query4 = "SELECT Staff,Working FROM [Work_Table]";
String^ query5 = "SELECT Roomischeck FROM [clean_check]";
String^ query6 = "SELECT Staff_2,Request FROM [Request_Table]";
srand(time(0));

// Create a new SqlConnection object
SqlConnection^ conn = gcnew SqlConnection(connString);

try {
    // Open the database connection
    conn->Open();

    // Create a new SqlCommand object
    SqlCommand^ cmd = gcnew SqlCommand(query, conn);
    SqlCommand^ cmd2 = gcnew SqlCommand(query2, conn);
    SqlCommand^ cmd3 = gcnew SqlCommand(query3, conn);
    SqlCommand^ cmd4 = gcnew SqlCommand(query4, conn);
    SqlCommand^ cmd5 = gcnew SqlCommand(query5, conn);
    SqlCommand^ cmd6 = gcnew SqlCommand(query6, conn);

    SqlDataReader^ reader = cmd->ExecuteReader();
    while (reader->Read()) {
        // Add the Id value to the checklistbox
        checkedListBox1->Items->Add(reader["Id"]->ToString());
        comboBox1->Items->Add(reader["Id"]->ToString());
    }
    reader->Close();

    SqlDataReader^ reader2 = cmd2->ExecuteReader();
    while (reader2->Read()) {
        comboBox2->Items->Add(reader2["Staff"]->ToString());
        comboBox3->Items->Add(reader2["Staff"]->ToString());
    }
    reader2->Close();

    SqlDataReader^ reader3 = cmd3->ExecuteReader();

    while (reader3->Read()) {
        // Create ListViewItem with the first column
        ListViewItem^ item = gcnew ListViewItem(reader3->GetString(0));

        // Add subitems for the remaining columns
        item->SubItems->Add(reader3->GetString(1));
        item->SubItems->Add(reader3->GetString(2));
        item->SubItems->Add(reader3->GetString(3));
        item->SubItems->Add(reader3->GetString(4));
        item->SubItems->Add(reader3->GetString(5));

        // Add the ListViewItem to listView2
        listView2->Items->Add(item);
    }
    label15->Text = "Lost Item : " + System::Convert::ToString(listView2->Items->Count);
    reader3->Close();

    SqlDataReader^ reader4 = cmd4->ExecuteReader();

    while (reader4->Read()) {
        ListViewItem^ item = gcnew ListViewItem(reader4->GetString(0));
        item->SubItems->Add(reader4->GetString(1));
        listView4->Items->Add(item);
    }
    label16->Text = System::Convert::ToString(listView4->Items->Count);
    reader4->Close();

    SqlDataReader^ reader5 = cmd5->ExecuteReader();
    int index = 0;
    while (reader5->Read())
    {
        int isChecked = Convert::ToInt32(reader5["Roomischeck"]);
        checkedListBox1->SetItemChecked(index, isChecked);
        index++;
    }
    reader5->Close();

    SqlDataReader^ reader6 = cmd6->ExecuteReader();

    while (reader6->Read()) {
        ListViewItem^ item = gcnew ListViewItem(reader6->GetString(0));
        item->SubItems->Add(reader6->GetString(1));
        listView5->Items->Add(item);
    }
    label17->Text = System::Convert::ToString(listView5->Items->Count);
    reader6->Close();
}
catch (Exception^ ex) {
    MessageBox::Show(ex->Message);
}
finally {
    conn->Close();
}

}

private: System::Void button6_Click(System::Object^ sender, System::EventArgs^ e) { delstaff^ form3 = gcnew delstaff(); form3->Show(); } private: System::Void button7_Click(System::Object^ sender, System::EventArgs^ e) { MyForm_Load(sender, e); }