Question

c# updata(更新一条连查询语句)高手解答

部分代码如下
private void button1_Click(object sender, EventArgs e)
{

string MySqlStr = "Select tblbook.BookName as 书名,tblbook.BookID as 编号,tblbook.BookPrice as 价格,tblbook.BookAuthor as 作者,tblbook.BookCount as 数量 from tblbook join tblIndustry on tblbook.bookIndustryID=tblIndustry.IndustryID join tblbookType on tblbookType.BookTypeID=tblbook.bookTypeID where tblbookType.BookTypeName= '" + comboBox2.Text +"'"+" and tblIndustry.IndustryName= '"+comboBox1.Text+ "'";
tmpAdapter = new SqlDataAdapter(MySqlStr, MyConn);
tmpCommandBuilder = new SqlCommandBuilder(tmpAdapter);
tmpAdapter.TableMappings.Add("Table","tblbook");
tmpAdapter.Fill(tmpDataSet , "tblbook");
MyBindingSource1.DataSource = tmpDataSet;
MyBindingSource1.DataMember = "tblbook";
dataGridView1.DataSource = MyBindingSource1;
textBox6.Text = "符合条件的记录：" + MyBindingSource1.Count.ToString();
//MyBindingSource.DataSource = tmpDataSet;
//MyBindingSource.DataMember = "tblbook1";
//dataGridView1.DataSource = MyBindingSource;
//textBox6.Text = "符合条件的记录：" + MyBindingSource.Count.ToString();

}

private void bun_save_Click(object sender, EventArgs e)
{

MyBindingSource1.EndEdit();
tmpAdapter.Update(tmpDataSet,"tblbook");
}
对于多个基表不支持动态 SQL 生成。错误提示行数(最后一行tmpAdapter.Update(tmpDataSet,"tblbook"); )

Answer 1

把你们老师找过来，我打不死他！
传参啊
传参啊
以后遇到注入攻击就知道哭了

Answer 2

什么错啊?你其中
tmpCommandBuilder = new SqlCommandBuilder(tmpAdapter);
tmpAdapter.TableMappings.Add("Table","tblbook");

这两句没有用,注释掉吧.特别是SqlCommandBuilder 不是这个情况下用的.

Answer 3

tmpAdapter.Update(tmpDataSet,"tblbook");
报的是这句的问题
主要是你的SQL是多表查询的 不能支持这种动态的Update 你可以换一种写法 比如循环取GridView每列的值 再入库update

Answer 4

报什么错？和我说