M
Matt Petteys
I am using the Data adapter wizard to build data adapters and build the
mappings to datasets. I am trying to build a data adapter which is
using a stored procedure for the select command. The stored procedure
uses a temporary table internally. When the wizard gets to the last
step where it regenerates the datadapter codebehind logic, it generates
an error like the following:
Invalid object name '#temptable'.
Obviously the wizard is seeing the temporary table being populated in
the stored procedure and trying to provide mappings for the temporary
table. Anyone know how I can get the wizard to work and still use a
temporary table within the stored procedure?
mappings to datasets. I am trying to build a data adapter which is
using a stored procedure for the select command. The stored procedure
uses a temporary table internally. When the wizard gets to the last
step where it regenerates the datadapter codebehind logic, it generates
an error like the following:
Invalid object name '#temptable'.
Obviously the wizard is seeing the temporary table being populated in
the stored procedure and trying to provide mappings for the temporary
table. Anyone know how I can get the wizard to work and still use a
temporary table within the stored procedure?