如何获取单选按钮valuse并存储在mysql数据库中
本文关键字:存储 mysql 数据库 valuse 单选按钮 何获取 获取 | 更新日期: 2023-09-27 18:26:16
我想在mysql数据库中以男性和女性的形式存储单选按钮值,因此我使用了使用c#的windows存储应用程序
这是我的C#代码
private void addButton_Click(object sender, RoutedEventArgs e)
{
try
{
string Query = @"INSERT INTO `bcasdb`.`tbl_student`
(`reg_id`,
`std_fname`,
`std_lname`,
`tbl_batch_batch_id`,
`gender`)
VALUES (@regId, @fName, @lName, @bID, @gender)";
//This is command class which will handle the query and connection object.
MySqlConnection conn = new MySqlConnection(BCASApp.DataModel.DB_CON.connection);
MySqlCommand cmd = new MySqlCommand(Query, conn);
conn.Open();
cmd.Parameters.AddWithValue("@regId", this.regIDInput.Text);
cmd.Parameters.AddWithValue("@fName", this.fnameInput.Text);
cmd.Parameters.AddWithValue("@lName", this.lnameInput.Text);
cmd.Parameters.AddWithValue("@bID", this.batchIDInput.Text);
//cmd.Parameters.AddWithValue("@gender", );
cmd.ExecuteNonQuery();
conn.Close();
successmsgBox();
}
catch (Exception)
{
errormsgBox();
}
}
private void genderInput_Checked(object sender, RoutedEventArgs e)
{
}
这是我的xaml编码
<StackPanel Orientation="Horizontal" Margin="20,20,0,10">
<RadioButton Name="maleInput" Content="Male" Checked="genderInput_Checked" Width="75"></RadioButton>
<RadioButton Name="femaleInput" Content="Female" Checked="genderInput_Checked" Width="162"></RadioButton>
</StackPanel>
string gender = maleInput.IsChecked ? "M" : "F";
cmd.Parameters.AddWithValue("@gender", gender);
假设需要进行选择。如果没有选择是有效的:
string gender = null;
if (maleInput.IsChecked || femaleInput.IsChecked) {
gender = maleInput.Checked ? "M" : "F";
}
cmd.Parameters.AddWithValue("@gender", gender);