VS2005 Drag and Drop from Server Explorer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Davinci - 15 Nov 2005 19:47 GMT

Hi

I am shocked this is broken but clearly it is for me at least. I opened a
new project and then connect to my database then tried to drag a table on to
a form. All I get is the NO smoking sign (Circle with a line across) as my
mouse cursor when I move onto the form.

So I ask some one else on my team to see they can do it...
NO GO same thing (different DB and computer)

So I try it on VS2003 works fine as usual!

Is drag and drop of a table broken, or do I now need to do something
different to get this functionality?

Currently my database exists remotely and I am connected to it with SA with
no password.

Any help will be appreciated.

Davinci
NOTE : all other objects under Server\MyComputerName will drag and drop on
to my form.

Reply to this Message

[MSFT] - 16 Nov 2005 08:57 GMT

Yes, this is different from VS.NEt 2003. We cannot drag tables/columns on a
form any more. In VS.NET 2005, we need to add each control to a form and
set their datasource.

Luke

Reply to this Message

Wozza - 16 Nov 2005 12:39 GMT

Hi,

Something else that seems to be missing is the ability to drag a bunch of
SQL Server tables onto a database project to generate the create scripts for
the selected tables. This also applies to functions, procedures, etc ...

Has this been totally removed???
Is there an add-in that allows this?

rgds
Warren

> Yes, this is different from VS.NEt 2003. We cannot drag tables/columns on a
> form any more. In VS.NET 2005, we need to add each control to a form and
> set their datasource.
>
> Luke

Reply to this Message

Wozza - 16 Nov 2005 13:47 GMT

Oops, sorry ... I lie. I had created a C# database project and not an Other
Projects Types database project.
One irritating thing, however, is that it does not allow generaion of
seperate files for table, extended properties, key constraints, etc.

And, a follow-on question is ...

How can I add an add-in menu item onto an item (table, stored procedure,
etc) on the data-connection explorer window??
Any pointers would be appreciated.

> Yes, this is different from VS.NEt 2003. We cannot drag tables/columns on a
> form any more. In VS.NET 2005, we need to add each control to a form and
> set their datasource.
>
> Luke

Reply to this Message

[MSFT] - 17 Nov 2005 02:58 GMT

Hello,

Did you mean the components in Server Explorere window? I afraid to say
there is no such way to customize Server Explorere window. What do you want
to do with the add-in menu? Maybe we can find another to achieve it.

Luke

Reply to this Message

Wozza - 17 Nov 2005 09:56 GMT

Hi Luke,

I have a command line utility that I use to generate code based on the
schema in SQL Server.
I would like to convert this into an add-in, so I want to be able to right
click a table, procedure, etc (any SQL object basically) and have a menu
option "Generate ..." which will pop up a dialogue that allows me to enter
some options and generate code directly into my solution.

I would need to know which server, database and object within the database
was selected. I would also need to know some details about the project (name,
root directory).

I've not done this in VS2003 yet, but since 2005 is out now I would like to
try it there.

cheers
Warren

> Hello,
>
[quoted text clipped - 3 lines]
>
> Luke

Reply to this Message

[MSFT] - 18 Nov 2005 02:49 GMT

Based on my research, there is no a directly way to achieve this. You need
to custimzed the IDE with classes in namespace IN ENVDTE, for example:

EnvDTE._DTE dte
=(EnvDTE._DTE)System.Runtime.InteropServices.Marshal.GetActiveObject("Visual
S
tudio.DTE");
EnvDTE.Window win
=dte.Windows.Item(EnvDTE.Constants.vsWindowKindServerExplorer);
EnvDTE.UIHierarchy hier = win.Object as EnvDTE.UIHierarchy;

For more information about this:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/ht
ml/vxconreferencingdteobject.asp

Hope this help,

Luke

Reply to this Message

Pete2004 - 05 Jan 2006 20:49 GMT

Why was this changed? Another great feature that has been removed.

> Yes, this is different from VS.NEt 2003. We cannot drag tables/columns on a
> form any more. In VS.NET 2005, we need to add each control to a form and
> set their datasource.
>
> Luke

Reply to this Message

VS2005 Drag and Drop from Server Explorer

Free Magazines