【求助】dataGridView连接mysql数据库不能更新

Question

代码如下，点击button后，dataGridView不能更新，求助

public partial class Form1 : Form
{
  MySqlDataAdapter daCountry;
  DataSet dsCountry;
  private void Form1_Load(object sender, EventArgs e)
  {
      string myConnectionString;
      myConnectionString = "server=127.0.0.1;uid=root;pwd=123456;database=db1;";
      MySqlConnection conn = new MySqlConnection(myConnectionString);

      try
      {
        string sql = "SELECT process, fileDir FROM file WHERE clientName='SIYUAN'";
        daCountry = new MySqlDataAdapter(sql, conn);
        MySqlCommandBuilder cb = new MySqlCommandBuilder(daCountry);

        dsCountry = new DataSet();
        daCountry.Fill(dsCountry, "file");

        dataGridView1.DataSource = dsCountry;
        dataGridView1.DataMember = "file";
      }

      catch (Exception ex)
      {
        label1.Text = ex.ToString();
      }
  }

 private void button1_Click(object sender, EventArgs e)
    {
      daCountry.Update(dsCountry, "file");
    }
}

Answer 1

少了ISPOSTBACK吧

像你这样只能显示第一次显示的东西   加上它吧

if(!ispostback)

{

东西放这里

}

Answer 2

大概查了一下，ISPOSTBACK是asp.net的嘛？这个程序是winform程序，怎么用呢？

Answer 3

重新绑定datagridview

---

http://feiyun0112.cnblogs.com/

Answer 4

如果提交 提示没有有效的更新命令 可能是你数据库表没有主键