Update data Using DataGrid and Data adapter

[nimrod_rotner]

Hi,
I am using the Dataset, DataAdapter,CommandBuilder and DataGrid in order to show and update data from a table called: "DiseaseTab".
The data is shown in the datagrid but the updated data (which the user did from the datagrid) would not update my SQL server table. I do not understand why.
I am keep getting the following Error:
"Dynamic SQL generation is not supported against multiple base tables."

My code is: (cn is my connection to SQL Server)
------------------------------------------------------------
Form_Load(...) Event
------------------------
Dim DA As SqlClient.SqlDataAdapter
DA = New SqlClient.SqlDataAdapter("select ...",cn)
DA.TableMappings.Add("Table", "DiseaseTab")
ds1 = New DataSet
DA.Fill(ds1)
DataGrid1.DataSource = ds1.Tables("DiseaseTab")

UpdateButton_Click Event...
------------------------------------
Dim DA As SqlClient.SqlDataAdapter
Dim ComandBuilder As SqlClient.SqlCommandBuilder
DA = New SqlClient.SqlDataAdapter("select diagnosis ,description ,recinsertdate,cntbefore ,delta ,deltainpercents ,FileFrom ,CanBeInserted from view_BeforeUploadAddNewWithSRCDesc where RecInsertDate in (Select RecInsertDate from tblAddnewToDiseaseTab where DiseaseUpdated<>'True') ", rpt.cn)
DA.TableMappings.Add("Table", "DiseaseTab")
ComandBuilder = New SqlClient.SqlCommandBuilder(DA)
DA.Update(ds1, "DiseaseTab")
'THE LAST SENTENCE BRINGS UP THE ERROR MSGBOX...

[vbcodec]

Hi
actually I would more recommend you to make dsnless connection to your sql server and connect ado to your odbc dsn and let the communicate , there's alot feature in ado and probably you can avoid that error to happen

Hope it helps.
S. mohammad Najafi