how to populate comboBox with all database name available in PC

Question

0.00/5 (No votes)

See more:

C#

WinForms

hii,
Is there any solution to get all database names available in PC in comboBox by selecting server name?

Posted 14-Mar-13 4:14am

Dev Gupta from Mumbai,India

Updated 16-Mar-13 5:28am

v2

Add a Solution

Comments

[no name] 14-Mar-13 10:21am

Yes, yes there is.

Dev Gupta from Mumbai,India 14-Mar-13 10:26am

Will you please give me the solution?

[no name] 14-Mar-13 10:34am

Select the table names from your database and then populate your combobox with the result.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

S. M. Ahasan Habib · Accepted Answer · 2013-03-14T04:30:00

Solution 1

You can connect any sqlserver database from your application and execute that query with ado.net.

SQL

SELECT name as DatabaseName FROM sys.Databases

You will got all database name from that sqlserver.

Posted 14-Mar-13 4:30am

S. M. Ahasan Habib

Comments

Dev Gupta from Mumbai,India 14-Mar-13 10:38am

thanks for your reply.I tried this and I'm getting database names that are available in MicrosoftSqlServer folder in C:. But what if databases are in D: or in other drives?In short, I want database names that are available in Other drives also..

S. M. Ahasan Habib 14-Mar-13 12:57pm

no matter where database stored where c: or d: or other drive. Application just connect to its database and execute its query. Database files(MDF,LDF) is hidden from application. So no problem will raise for that.

Dev Gupta from Mumbai,India 17-Mar-13 11:14am

hii,
I had tried your given code.In comboBox I'm getting master database name,whereas my database name is testdb which is present in E:\newfolder\mydb.

S. M. Ahasan Habib 17-Mar-13 11:28am

you execute SELECT * FROM sys.Databases query from your sql server management studio and see the results. If there you do not find your database name then let me know.

Dev Gupta from Mumbai,India 19-Mar-13 1:58am

I'm getting master,temp db names.I want a code that should run in every pc after creating a setup.

S. M. Ahasan Habib 19-Mar-13 2:12am

I guess you have multiple sql server instance installed in your pc. you can check it to go to windows services viewer and see how many sql server services found there. You can get specific instance from your code and management studio and then execute the query. The query will return database names from that particular instance. I guess you are facing the problem is create database is one instance and connect to other instance and search that database.

Dev Gupta from Mumbai,India 19-Mar-13 2:54am

hii,
I used SELECT db_name() as DatabaseName from sys.databases.it gives me names of database which are currently being used...