Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zacemmel
Starting Member
1 Post |
 Posted - 2004-08-19 : 14:33:33
|
| I'm currently writing a C# application that is using an OleDb connection to connect to a database. I can query the database, and fill a datagrid with the recordset. The problem is with the Update method of the OleDbDataAdapter -- I get the following error:Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information.Any insight would be greatly appreciated.Thanks,Zac |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-08-19 : 19:45:42
|
| To be able to run updates/inserts/deletes on a DataSet, you need to declare all the DataTables that make it up. Try using the wizards in the IDE because these will generate all this for you. |
 |
|
|
hgriffith
Starting Member
1 Post |
Posted - 2004-09-03 : 17:17:20
|
| Is this the only answer?Isn't there a way to dynamically setup the Datagrid, DataSet, etc?What are those methods called Fill(...) and FillSchema(...) forif they don't allow dynamic building of Datagrids?I have had the same problem and get the same error message:Dynamic SQL generation is not supported against a SelectCommand that does not return any base table informationand am frustrated because the article that I've read would lead one to believe that FillSchema would handle evrything needed to generatedynamic update and delete statements.Could you please explain?Thank you for your time!!! |
|
|
|
|
|
|
Error updating datagrid