Editor Question

[Wayne A. via .NET 247]

Hi All,

I wonder that why MS SQL query analyzer doesn't have similarfeature like the one in VS.NET studio, for example: when you keyin a table name, bring up all columns of this table to be choosefrom. Can I do it with C#? what should be used to bring up thoselist, context menu? Any input will be highly appreciated.

http://www.quest.com/toad/sql_editor.html

Thanks

--------------------------------
From: Wayne A.

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>FZrDZoDuVUWag3IgMrKB7w==</Id>

[KG]

It would be nice to have this functionality in an sql editor.
I would suggest you might need to get the db schema (table names, column
names) for the selected db and then, depending on what they type, show a
combo with matching entries.

Google or msdn for getting the db schema.

Good luck.
Keep us informed.

HTH
JB
***********************

"Wayne A. via .NET 247" <an*******@dotnet247.com> wrote in message
news:OL**************@TK2MSFTNGP10.phx.gbl...
Hi All,

I wonder that why MS SQL query analyzer doesn't have similar feature like
the one in VS.NET studio, for example: when you key in a table name, bring
up all columns of this table to be choose from. Can I do it with C#? what
should be used to bring up those list, context menu? Any input will be
highly appreciated.

http://www.quest.com/toad/sql_editor.html

Thanks

--------------------------------
From: Wayne A.

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>FZrDZoDuVUWag3IgMrKB7w==</Id>