更新按钮不工作

本文关键字：工作 按钮 更新 | 更新日期: 2023-09-27 18:02:40

我正试图通过c#中的windows窗体按钮更新我的数据库。当我运行我要显示的代码时，它不会显示任何错误，但它不会改变数据库或数据网格中的数据。

private void update_Click(object sender, EventArgs e)
{
    SqlConnection NewCon = new SqlConnection(@"Data Source=.'SQLEXPRESS;AttachDbFilename=E:'ASPNET'cd'cdcwk2'cddatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
    SqlCommand cmd = new SqlCommand("UPDATE cdstock set cd_title='" + cdtext.Text + "', artist='" + artisttext.Text + "',genre='" + genretext.Text + "', rating=" + ratingtext.Text + ", cd_discription='" + distext.Text + "' where cd_id =" + idtext.Text + ";", NewCon);
    MessageBox.Show("UPDATE cdstock  set cd_title='" + cdtext.Text + "', artist='" + artisttext.Text + "',genre='" + genretext.Text + "', rating='" + ratingtext.Text + "', cd_discription='" + distext.Text + "' where cd_id ='" + idtext.Text + "'");
    NewCon.Open();
    cmd.ExecuteNonQuery();
    NewCon.Close();
    MessageBox.Show("Record Has Now Been UPDATED!!");
}

更新按钮不工作

嗨，我找到了解决方案，现在工作得很好，谢谢你的时间。解决方案如下。

             String NewCon = @"Data Source=.'SQLEXPRESS;AttachDbFilename=E:'ASPNET'cd'cdcwk2'cddatabase.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
         SqlConnection con = new SqlConnection(NewCon);
         SqlCommand cmd = new SqlCommand();
         cmd.CommandText = "UPDATE cdstock set cd_title='" + cdtext.Text + "', artist='" + artisttext.Text + "',genre='" + genretext.Text + "', cd_discription='" + distext.Text + "', rating=" + ratingtext.Text + " where cd_id = " + dataGridView1.CurrentRow.Cells[0].Value;
         cmd.Connection = con;
         cmd.Connection.Open();
         cmd.ExecuteNonQuery();
         cmd.Connection.Close();

cddatabaseDataSet3.GetChanges ();this.cdstockTableAdapter.Fill (this.cddatabaseDataSet3.cdstock); 

        MessageBox.Show("Record Has Now Been UPDATED!!");
相关文章：