C#:直接在DataGirdView上修改表的信息并保存

可以直接修改
点击保存

 private void saveline_Click(object sender, EventArgs e)
 {
     db.update("select * from Buslines", dsline);
}

dsline 是全局变量DataSet

DBHelper db = null;
DataSet dsline = null;

因为在Load中也要用到所以全局

private void findLine()
{
     dsline = db.execute("select * from Buslines");
     dgvline.DataSource = dsline.Tables[0];
     dgvline.MultiSelect = false;
     dgvline.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
     dgvline.Columns[0].HeaderText = "线路编号";
     dgvline.Columns[1].HeaderText = "始发站";
     dgvline.Columns[2].HeaderText = "终点站";
     dgvline.Columns[3].HeaderText = "距离";
 }

数据库帮助类 db

public void update(string sql,DataSet ds)
{
     SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
     SqlCommandBuilder scb = new SqlCommandBuilder(sda);
     sda.Update(ds);
     ds.AcceptChanges();
 }