110,538
社区成员
发帖
与我相关
我的任务
分享
id,//主键
name
id,//主键
name
id,//主键
sport_id,
sporter_id,
name
private DataTable dtSportResult;
private SqlDataAdapter sdaSportResult;
private void btnSearchSportListResult_Click(object sender, EventArgs e)
{
string connStr = SportAdmin.Properties.Settings.Default.db_sport_sysConnectionString;
SqlConnection con = new SqlConnection(connStr);
string sql = @"SELECT tb_sporter_list.id AS '编号', tb_sport.name AS '项目名称', tb_sporter.name AS '运动员姓名', tb_sporter_list.result AS '比赛成绩'
FROM tb_sporter_list, tb_sport , tb_sporter
WHERE tb_sporter_list.sport_id = tb_sport.id AND
tb_sporter_list.sporter_id = tb_sporter.id AND
tb_sport.name='男子50米'";
sdaSportResult = new SqlDataAdapter(sql, con);
dtSportResult = new DataTable();
sdaSportResult.Fill(dtSportResult);
dgvSportResult.DataSource = dtSportResult;
}
//更新成绩
private void btnModifySportResult_Click(object sender, EventArgs e)
{
string connStr = SportAdmin.Properties.Settings.Default.db_sport_sysConnectionString;
SqlConnection conn = new SqlConnection(connStr);
sdaSportResult.UpdateCommand = new SqlCommand(@"update tb_sporter_list set result=@result", conn);//如果使用自定义的代码,我应该怎么把修改后的成绩传给result?
//SqlCommandBuilder sb = new SqlCommandBuilder(sdaSportResult);//使用这句,会提示对于多个基表不支持动态SQL生成
sdaSportResult.Update(dtSportResult);
//dgvSportResult.Update();
}
如果使用SqlCommandBuilder ,会提示对于多个基表不支持动态SQL生成;
如果使用自定义的更新语句,我不知道怎么获取所有修改后的单元格的值传递给SQL的update语句。