Stored procedures and sql Adapters

[mklapp]

Hello,

You know I thought I had this down but all of a
sudden, well, it seems I do not.

I needed yet another SqlDataAdapter for my
Webservice. So, I created a stored Procedure in the SQL
Server DB, Drag an adapter to the designer surface of my
Web Service, but the list of stored procedures in the
combo box (for selecting the different commands) does not
contain the most recent Stored Procedure. This is the
sixth adapter for this service (many more to go). Have I
reached a limit of some sort or is it just late in the
day and some component in the chain decides not to work.

Why oh Why can I not see all the stored procedures in the
Configure Data Adapter wizrd's combo box? And Why oh Why
can't I just type the name into the combo box.

MKlapp

 

[mklapp]

OK, I worked around this issue by exiting VS.Net and
starting it up again. It sees the SPs.

Mklapp

 

[Brett Keown [MSFT]]

Great news Mklapp!

I'm glad you were able to resolve your issue so quickly. If you have
follow-up questions related to this topic, please let us know.

Brett Keown
Microsoft Support
(e-mail address removed)

This posting is provided "AS IS" with no warranties, and confers no rights.