更新数据在mysql与组合框单选按钮和按钮c#
本文关键字:单选按钮 按钮 组合 数据 mysql 更新 | 更新日期: 2023-09-27 17:50:23
所以这里的东西我有一个选项来选择数据在组合框中,当我选择它,我可以选择从1到5的单选按钮多少我会评价它,当我选择单选按钮,按下按钮,它应该更新mysql的数据,但idk什么是错误的这里..
代码:
private void button2_Click(object sender, EventArgs e)
{
if(radioButton1.Checked)
{
string constring = "datasource=localhost;port=3306;username=root;password=";
string Query = "UPDATE filmi.film SET '" + this.comboBox1.SelectedItem + "' = 1";
MySqlConnection conDataBase = new MySqlConnection(constring);
MySqlCommand cmdDataBase = new MySqlCommand(Query, conDataBase);
cmdDataBase.Parameters.AddWithValue("@film", this.comboBox1.SelectedItem);
MySqlDataReader myReader;
try
{
conDataBase.Open();
myReader = cmdDataBase.ExecuteReader();
MessageBox.Show("Ocena oddana!");
while (myReader.Read())
{
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
1。替换为
string Query = "UPDATE filmi.film SET '" + this.comboBox1.SelectedItem + "' = 1";
与这个:string Query = "UPDATE filmi.film SET film = @film";
2。替换为
myReader = cmdDataBase.ExecuteReader();
MessageBox.Show("Ocena oddana!");
while (myReader.Read())
{
}
与这个:cmdDataBase.ExecuteNonQuery();
编辑:如果您想在每次更新
时更新或增加列值1试试这个:
string Query = "UPDATE [TableName] SET [COLUMNNAME] = [COLUMNNAME]+1";