Drag and drop not working in VS 2005 using Stored Procedures onto the Design view for aspx pages

Hi,

I would like to know if there's a way in VS 2005 to drag and drop stored procedures from the Server Explorer to the .aspx page design view like VS 2003? I thought it was nice in VS 2003 to drag the SP onto the page and it would create and initialize the SP. In VS 2005, it won't let me drag the SP, I have to use the SqlDataSource and it doesn't generate a code in the code behind page? Can anyone give me any guidance on this?

Thanks,
Jaime

[456 byte] By [jcavazos] at [2007-12-24]
# 1
Hi,

I wish someone from Microsoft would answer this question. I'm not sure why they disabled this feature. It's taking me an extra 5 minutes to initalize a large stored procedure opposed to 10 seconds doing it the old way. If you add all the extra time building a large application could waste alot of time. There was nothing wrong, logic or security wise to take this feature out. They've made programming less and more efficient, depending how you program, implementing some of the new features that have come out in VS 2005. Not a big fan of the "Wizards".

Jaime

jcavazos at 2007-8-31 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 2
I believe you are posting in the wrong forum. You may have a better chance at getting an answer if you were to post in the correct forum.
jhidey at 2007-8-31 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 3
Hello - I moved your thread to the VSTS - Database Professionals forum hoping someone here may have more context to answer your question. Thanks -
PaulORearMSFT at 2007-8-31 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 4

The following may give you some answers:

Visual Studio 2005 does not support this drag-and-drop method in Server Explorer
http://support.microsoft.com/kb/316649/

Why can't I drag from Server Explorer to my form?
<http://blogs.msdn.com/vbteam/archive/2004/08/27/221584.aspx>

Why are the Data Components no longer on the Toolbox?
<http://blogs.msdn.com/vbteam/archive/2004/08/05/209140.aspx>

Performing Data Access
http://www.asp.net/QuickStart/aspnet/doc/data/default.aspx

The designer is revamped in VS2005 but still can use the SQLConnection within code.
The SQLDataSource control allows you to do much more without writing code.
"Windows Forms Data Controls and Databinding" or "ASP" forum would be a better place for this question.

- Manoj

Team Systems Database: http://msdn.microsoft.com/vstudio/teamsystem/dbpro/

ManojM at 2007-8-31 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...

Visual Studio Team System

Site Classified