UC知道c# updata(更新一条连查询语句)高手解答
来源：百度知道 编辑：UC知道 时间：2024/05/28 14:28:26
部分代码如下
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";
data
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";
data
把你们老师找过来，我打不死他！
传参啊
传参啊
以后遇到注入攻击就知道哭了
什么错啊?你其中
tmpCommandBuilder = new SqlCommandBuilder(tmpAdapter);
tmpAdapter.TableMappings.Add("Table","tblbook");
这两句没有用,注释掉吧.特别是SqlCommandBuilder 不是这个情况下用的.
tmpAdapter.Update(tmpDataSet,"tblbook");
报的是这句的问题
主要是你的SQL是多表查询的 不能支持这种动态的Update 你可以换一种写法 比如循环取GridView每列的值 再入库update
报什么错？和我说