R
roger.breton
Guest
I have a Dataset created from an SQL DataSource.
Recently, I added one extra Table to the underlying Database. When I updated the DataSource, I selected the new Table. But, for some reason, the DataAdapter created for that Table only has a SELECT Command; no UPDATE Command of any kind.
I tried to create the missing UPDATE Command text, as best as I could, but I invariably get syntax error.
I tried a number of things, like trashing and recreating the whole dataset, fresh, from the data source to no avail, that newly added table refuses to come up with an UPDATE Command.
Continue reading...
Recently, I added one extra Table to the underlying Database. When I updated the DataSource, I selected the new Table. But, for some reason, the DataAdapter created for that Table only has a SELECT Command; no UPDATE Command of any kind.
I tried to create the missing UPDATE Command text, as best as I could, but I invariably get syntax error.
I tried a number of things, like trashing and recreating the whole dataset, fresh, from the data source to no avail, that newly added table refuses to come up with an UPDATE Command.
Continue reading...