如何在sql server的组合列表中显示所有数据库? [英] how can show all database in combo list of sql server?

问题描述

如何在sql server的组合列表中显示所有数据库?

如何使用我的用户名和密码(这是一家商店)与sql server的数据库连接，所以有两个数据库，因此我首先要检查用户名和密码，然后才能连接数据库工作

how can show all database in combo list of sql server?

how can connect with database of sql server manual as i use a user name and pass word of user that is a shop and there is two database so first i am checking user-name and password and then connection database for working

推荐答案

您的问题确实非常不清楚，因此不确定是否有帮助.但是，将babelfish放入其中，我想您的意思是我如何获取所有sql服务器实例的列表并像sql server登录对话框一样登录到其中?

好吧，别再看了.它全部在这里: GNR8-简单的C#类生成器 [ ^ ].忽略主题:这里有一个对话框和代码可以执行我认为您需要的操作.如果没有，请随时忽略.

Your question is really bvery unclear so not sure if this will help. However, putting my babelfish in I think you mean how do I get a list of all sql server instances and log on to one just like the sql server logon dialog?

Well, look no more; it''s all in here: GNR8 - Simple C# Class Generator[^]. Ignore the subject: there is a dialog and code in there to do what I think you need. If not, then feel free to ignore.

^ ]
在本地网络上查找SQL Server实例 [ ^ ]
列出网络上的SQL Server [

Finding SQL Servers on the Network[^]
Locate SQL Server instances on the local network[^]
List SQL Servers on a Network[^]

你好，

您可以使用主表列出SQL Server中的所有数据库.

Hi,

You can use master table for listout all databases in your SQL server.

select name from master.sys.databases

这就是你想要的吗?

希望对您有帮助，

谢谢
-Amit.

is this what you want ?

hope it will help you,

thanks
-Amit.

这篇关于如何在sql server的组合列表中显示所有数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！