reconfiguring a data adapter using an existing SP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I changed the SP. I re-configured the data-adapter to use the existing sp and I get an error telling me there already is a SqlCommand54
Now imagine my surprise. I have been scrupulous in naming everthing I could. I would not accept a meaningless name like SQLCommand54
I will just write a new statement. Again. and configure the adapter as new. I just have to wonder why (and where) sqlCommand54 is defined and why it refuses to cooperate with the developer
 
Hi mklapp,

Thank you for posting in the community!

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that when you are reconfiguring the
SqlDataAdapter using wizard, an error which says that the SqlCommand54
already exists. If there is any misunderstanding, please feel free to let
me know.

I have tried to follow the steps to re-configure the SqlDataAdapter.
However, I cannot reproduce this error. I think it might be an error that
happens occasionally. SQLCommand54 might be an object that is created for
the SqlDataAdapter's select, insert, update or delete command. The name of
the command is generated by the wizrd automatically. To check if there is
already an SqlCommand object named SQLCommand54, you can try to search with
keyword "SQLCommand54" in the code.

If the problem still persists, please try to remove the SqlDataAdapter and
create a new one. This might have the problem fixed.

If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Hate to talk over this conversation but I have had similar problems. They
only went away when you restarted the IDE. I believe there are things which
are cached and situations where that caching causes problems.

Lloyd Sheen
 
Back
Top