Help with Error - ( UPDATE DataTable ) does not make sense to me.

[andrewcw]

I have just 1 table that I am updating, the SQL I use to generate the
DataTable is complex using multiple tables, however when I view the
fieldnames of the DataTable from the DataSet - everything matches: What dont
I understand here:
( The error I get is : Dynamic SQL generation is not supported against
multiple base tables ). But My DataSet is 1 Table, and my target is 1 table,
Why the error ??
Thanks :
try
{
staticSQLConn.O pen();
System.Data.Sql Client.SqlDataA dapter daAdapter = new
SqlDataAdapter( sSQL, staticSQLConn);
daAdapter.Accep tChangesDuringF ill = false;
daAdapter.Fill( ds, srcTable); // all entries will be
flagged new

if (ds.HasChanges( ))
{
rowsToInsert = ds.Tables[srcTable].Rows.Count;
SqlCommandBuild er Cb = new SqlCommandBuild er(daAdapter);
Cb.GetInsertCom mand();
DataTable dt = ds.Tables[srcTable];
retVal = daAdapter.Updat e(dt); // ERROR

}


--
Andrew

[andrewcw]

Actually I have an answer, close the existing adapter that made the complex
query and then reopen a new adapter with Select * from source table as
follows:

if (ds.HasChanges( ))
{
rowsToInsert = ds.Tables[srcTable].Rows.Count;
DataTable dt = ds.Tables[srcTable];
daAdapter.Dispo se();
System.Data.Sql Client.SqlDataA dapter daAdapter2 = new
SqlDataAdapter( "Select * from " + srcTable, staticSQLConn);
SqlCommandBuild er Cb = new SqlCommandBuild er(daAdapter2);
Cb.GetInsertCom mand();
retVal = daAdapter2.Upda te(dt);

}

--
Andrew
"andrewcw" wrote:

I have just 1 table that I am updating, the SQL I use to generate the
DataTable is complex using multiple tables, however when I view the
fieldnames of the DataTable from the DataSet - everything matches: What dont
I understand here:
( The error I get is : Dynamic SQL generation is not supported against
multiple base tables ). But My DataSet is 1 Table, and my target is 1 table,
Why the error ??
Thanks :
try
{
staticSQLConn.O pen();
System.Data.Sql Client.SqlDataA dapter daAdapter = new
SqlDataAdapter( sSQL, staticSQLConn);
daAdapter.Accep tChangesDuringF ill = false;
daAdapter.Fill( ds, srcTable); // all entries will be
flagged new

if (ds.HasChanges( ))
{
rowsToInsert = ds.Tables[srcTable].Rows.Count;
SqlCommandBuild er Cb = new SqlCommandBuild er(daAdapter);
Cb.GetInsertCom mand();
DataTable dt = ds.Tables[srcTable];
retVal = daAdapter.Updat e(dt); // ERROR

}


--
Andrew