关于"SqlCommandBuilder 实现批量更新"有紧急问题提问?

[piao20040506]

源代码如下,曾经成功过,几天没运行开始报错如下:
"Update 无法找到 TableMapping['t_product'] 或 DataTable“t_product”。"
真是奇怪了,怎么就找不到我的表了呢!差了ds没问题啊,不知还会那里有错,有经验的老兄指教以下!!

#region DataGridView数据批量保存

public DataSet DataSetUpdateByDataSet(DataSet ds,string str_sql,string strTblName)
{
MessageBox.Show(ds.ToString());
SqlConnection conn = this.getcon();
SqlDataAdapter myAdapter = new SqlDataAdapter();
SqlCommand myCommand = new SqlCommand((str_sql + strTblName), conn);
myAdapter.SelectCommand = myCommand;
SqlCommandBuilder myCommandBuilder = new SqlCommandBuilder(myAdapter);
try
{
lock (this) //处理并发情况(分布式情况)
{
myAdapter.Update(ds, strTblName);
}
}
catch (Exception err)
{

throw err;
}
finally
{
conn.Close();
}
return ds; //数据集的行状态在更新后会都变为: UnChange,在这次更新后客户端要用返回的ds
}
#endregion

[amandag]

有可能使sql语句最后和表名拼接的时候少了空格

SqlCommand myCommand = new SqlCommand((str_sql + strTblName), conn);
==
SqlCommand myCommand = new SqlCommand((str_sql + " " + strTblName), conn);

[piao20040506]

我有空格的!!
[Quote=引用 1 楼 amandag 的回复:]
有可能使sql语句最后和表名拼接的时候少了空格

SqlCommand myCommand = new SqlCommand((str_sql + strTblName), conn);
==
SqlCommand myCommand = new SqlCommand((str_sql + " " + strTblName), conn);
[/Quote]