SQL VS C++ Как сделать сохранение в бд checkBox

private: System::Void checkBox1_CheckedChanged(System::Object^ sender, System::EventArgs^ e) {
if (checkBox1->Checked == true)
{
checkBox2->Checked = false;
checkBox3->Checked = false;
checkBox4->Checked = false;
nanswer = 1;
}
}
как мне сохранить в бд значение nanswer в столбец check1.
код должен сохранить одно из этих значений
private: System::Void checkBox1_CheckedChanged(System::Object^ sender, System::EventArgs^ e) {
if (checkBox1->Checked == true)
{
checkBox2->Checked = false;
checkBox3->Checked = false;
checkBox4->Checked = false;
nanswer = 1;
}
}
private: System::Void checkBox2_CheckedChanged(System::Object^ sender, System::EventArgs^ e) {
if (checkBox2->Checked == true)
{
checkBox1->Checked = false;
checkBox3->Checked = false;
checkBox4->Checked = false;
nanswer = 2;
}
}
private: System::Void checkBox3_CheckedChanged(System::Object^ sender, System::EventArgs^ e) {
if (checkBox3->Checked == true)
{
checkBox1->Checked = false;
checkBox2->Checked = false;
checkBox4->Checked = false;
nanswer = 3;
}
}
private: System::Void checkBox4_CheckedChanged(System::Object^ sender, System::EventArgs^ e) {
if (checkBox4->Checked == true)
{
checkBox1->Checked = false;
checkBox2->Checked = false;
checkBox3->Checked = false;
nanswer = 4;
}
}
я вот как пытался
void UpdateTest()
{
try
{
String^ connectionString = "Data Source=WIN-DFFK8CA8HJQ\\SQLEXPRESS;Initial Catalog=DBConstructorTesting;Persist Security Info=True;Integrated Security=true;";
SqlConnection^ con = gcnew SqlConnection(connectionString);

con->Open();

// Правильный синтаксис UPDATE
String^ sqlQuery = "UPDATE Test_slot_1 SET "
"question = @param2, "
"answer1 = @param3, "
"answer2 = @param4, "
"answer3 = @param5, "
"answer4 = @param6 "
"check1 = @param7 "
"WHERE id = @id";

SqlCommand^ cmd = gcnew SqlCommand(sqlQuery, con);

// Добавляем параметры
cmd->Parameters->AddWithValue("@param2", textBox1->Text);
cmd->Parameters->AddWithValue("@param3", textBox2->Text);
cmd->Parameters->AddWithValue("@param4", textBox3->Text);
cmd->Parameters->AddWithValue("@param5", textBox4->Text);
cmd->Parameters->AddWithValue("@param6", textBox5->Text);
cmd->Parameters->AddWithValue("@param7", checkBox1->Checked);
cmd->Parameters->AddWithValue("@id", 1);
cmd->ExecuteNonQuery();
con->Close();
num += 1;
label3->Text = num.ToString();
textBox1->Text = "";
textBox2->Text = "";
textBox3->Text = "";
textBox4->Text = "";
textBox5->Text = "";
}
catch (Exception^ ex)
{
MessageBox::Show(ex->Message);
throw ex;
}
}