我做好了修改C#datagridview的功能，但是只能每次修改一行，然后选择修改按钮
这样才能保存，如果同时修改多行，就只能保存最后一次修改的结果，可是我想修改多行，然后按修改按钮，能够同时修改多行数据。以下是我修改按钮中的代码：
private void button2_Click_1(object sender, EventArgs e)
{
//计划名称和计划时间
String jihuamingcheng = textBox1.Text;
String jihuashijian = dateTimePicker1.Value.Date.ToLongDateString();
//保存计划
using (SqlConnection sqlcon = new SqlConnection(strcon))
{
sqlcon.Open();
string id = this.dataGridView1.CurrentRow.Cells[0].Value + "";
string riqi = this.dataGridView1.CurrentRow.Cells[1].Value + "";
string neirong = this.dataGridView1.CurrentRow.Cells[2].Value + "";
string wanchengdu = this.dataGridView1.CurrentRow.Cells[3].Value + "";
// string sql = "update " + jihuamingcheng + " set 创建时间='" + jihuashijian + "',内容='" + neirong + "',完成度='" + wanchengdu + "' where 项目号='" + id + "'";
// SqlCommand command = new SqlCommand(sql, sqlcon);
// myda = new SqlDataAdapter(command);
//myset.Tables.Clear();
// myda.Fill(myset, "" + jihuamingcheng + "");
//dataGridView1.DataSource = myset.Tables["" + jihuamingcheng + ""];
if (this.dataGridView1.DataSource != null)
{
DialogResult result = MessageBox.Show("确定将此次盘库数据保存至数据库？（存储前请务必核对准确）", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (result == DialogResult.OK)
{
for (int i = 0; i < dataGridView1.Rows.Count-1; i++)
{
string cmdInsert = String.Empty;
cmdInsert = "INSERT INTO " + jihuamingcheng + "(项目号,创建时间,内容,完成度)";
cmdInsert += "," + this.dataGridView1.Rows[i].Cells[2].Value + "";
cmdInsert += "," + this.dataGridView1.Rows[i].Cells[3].Value + "";
}
}
}
}
//刷新表
using (SqlConnection sqlcon = new SqlConnection(strcon))
{
sqlcon.Open();
string sql = "select * from "+jihuamingcheng+"";
SqlCommand command = new SqlCommand(sql, sqlcon);
myda = new SqlDataAdapter(command);
myset.Tables.Clear();
myda.Fill(myset, ""+jihuamingcheng+"");
dataGridView1.DataSource = myset.Tables[""+jihuamingcheng+""];
}
}
