dataGridView1.BeginEdit(true);
if (checkBox1.Checked)
{
for (int i = 0; i < dataGridView1.Rows.Count-1; i++)
{
dataGridView1.Rows[i].Cells[4] .Value= "100";
}
}
else
{
for (int i = 0; i < dataGridView1.Rows.Count-1; i++)
{
dataGridView1.Rows[i].Cells[4] .Value= "999";
}
}
dataGridView1.EndEdit();
DataTable dt1 = (DataTable)dataGridView1.DataSource;System.Data.SqlClient.SqlConnection cn = new
System.Data.SqlClient.SqlConnection
("server=.;uid=sa;pwd=sa;database=pubs;");System.Data.SqlClient.SqlDataAdapter da = new
System.Data.SqlClient.SqlDataAdapter("select * from titles", cn);
System.Data.SqlClient.SqlCommandBuilder cmb = new
System.Data.SqlClient.SqlCommandBuilder(da);
da.Update(dt1);这样子做的话.更新到数据库.始终无法对选中行进行更改. (dataGridView1.SelectedRows这几行.)请教各位.要怎么才可以对dataGridView1中所有的行进行修改.需要什么操作.
if (checkBox1.Checked)
{
for (int i = 0; i < dataGridView1.Rows.Count-1; i++)
{
dataGridView1.Rows[i].Cells[4] .Value= "100";
}
}
else
{
for (int i = 0; i < dataGridView1.Rows.Count-1; i++)
{
dataGridView1.Rows[i].Cells[4] .Value= "999";
}
}
dataGridView1.EndEdit();
DataTable dt1 = (DataTable)dataGridView1.DataSource;System.Data.SqlClient.SqlConnection cn = new
System.Data.SqlClient.SqlConnection
("server=.;uid=sa;pwd=sa;database=pubs;");System.Data.SqlClient.SqlDataAdapter da = new
System.Data.SqlClient.SqlDataAdapter("select * from titles", cn);
System.Data.SqlClient.SqlCommandBuilder cmb = new
System.Data.SqlClient.SqlCommandBuilder(da);
da.Update(dt1);这样子做的话.更新到数据库.始终无法对选中行进行更改. (dataGridView1.SelectedRows这几行.)请教各位.要怎么才可以对dataGridView1中所有的行进行修改.需要什么操作.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货