CLR项目中登录表单关闭后无法弹出认证成功对话框的问题

核心问题定位 #

你的代码存在两个关键问题导致异常：

1. MyForm类未声明User成员变量：btnOK_Click中直接赋值的user是未声明的变量（或局部变量），导致Program.cpp中zp.user无法获取到认证成功后的实例。
2. 数据库资源未正确释放：SqlDataReader和SqlConnection未手动关闭，可能引发资源泄漏或运行时异常。

修复步骤 #

1. 为MyForm类添加User成员变量 #

在MyForm.h的类声明中添加公开的User^成员，确保Program.cpp能访问到认证后的用户对象：

// MyForm.h
public ref class MyForm : public System::Windows::Forms::Form
{
public:
    User^ user; // 添加此成员变量，用于传递认证状态
private:
    // 原有控件声明
    System::Windows::Forms::TextBox^ tbEmail;
    System::Windows::Forms::TextBox^ tbPassword;
    System::Windows::Forms::Button^ btnOK;
    // ...其他成员

private: System::Void btnOK_Click(System::Object^ sender, System::EventArgs^ e);
};

2. 完善数据库资源释放逻辑 #

在btnOK_Click的try-catch块中添加finally，确保数据库连接和阅读器被正确关闭，避免资源泄漏：

private: System::Void btnOK_Click(System::Object^ sender, System::EventArgs^ e) {
    String^ email = this->tbEmail->Text;
    String^ password = this->tbPassword->Text;

    if (email->Length == 0 || password->Length == 0)
    {
        MessageBox::Show("Please enter Email and Password","Email and Password Error",MessageBoxButtons::OK);
        return;
    }

    SqlConnection^ sqlConn = nullptr;
    SqlDataReader^ reader = nullptr;
    try
    {
        String^ connstring = "Data Source = ASUS\\SQLEXPRESS;Initial Catalog = DBMS_TA;Integrated Security = True;Encrypt = False";
        sqlConn = gcnew SqlConnection(connstring);
        sqlConn->Open();
        

        String^ query = "SELECT * FROM kinshukuser WHERE email = @email AND password = @password";
        SqlCommand^ command = gcnew SqlCommand(query, sqlConn);
        command->Parameters->AddWithValue("@email", email);
        command->Parameters->AddWithValue("@password", password);

        reader = command->ExecuteReader();
        if (reader->Read())
        {
            user = gcnew User;
            user->value = 1;
            this->Close();
        }
        else
        {
            MessageBox::Show("Email or password is incorrect.","Email or Password Error",MessageBoxButtons::OK);
        }
    }
    catch(Exception^ ex)
    {
        MessageBox::Show("Failed to connect to Database"+ex->Message, "Database Connection Error", MessageBoxButtons::OK);
    }
    finally
    {
        // 确保资源被释放
        if(reader != nullptr) reader->Close();
        if(sqlConn != nullptr && sqlConn->State == System::Data::ConnectionState::Open)
            sqlConn->Close();
    }
}

3. 验证Program.cpp逻辑 #

你的Program.cpp逻辑本身没问题，修改后，登录成功关闭表单后，zp.user会正确获取到实例，弹出成功提示。

额外建议 #

• 不要明文存储密码：生产环境中应存储密码的哈希值（如SHA256），而非明文，避免数据泄露风险。
• 使用参数化查询：你已经做到了，继续保持，这能有效防止SQL注入。

内容的提问来源于stack exchange，提问作者kinshuk