i want to create a dropdownlist and when i click the dropdownlist, then it should show the all databases which is present in SQLserver. (now i m using SQLSERVER 2005 and Microsoft VISUAL STUDIO 2005) can anyone help me plz? thanks in advance. CLEAR MY DOUBT IF U GENIUS
karan_21584
0
Light Poster
Recommended Answers
Jump to PostJust run a select query in the master database where the object is a database. anything in SQL Server has to be registered in the master database. When you create a table, stored proc, user etc. it is stored in the master database. Of course you need the correct permission …
Jump to PostOk i will try again.
In SQL Server there is a system database called Master. This is the heart of SQL Server. Whenever you add an object to SQL Server such as a database, a user, a stored proc, a table, a column etc. it is put into the master …
Jump to PostOr you can just "EXEC sp_databases" look it up in Books on line (the manual that comes with SQL Server) find it from Start -> All programs -> Microsoft SQl Server -> Books online.
All 9 Replies
f1 fan
16
Posting Whiz in Training
karan_21584
0
Light Poster
amithasija
0
Light Poster
karan_21584
0
Light Poster
karan_21584
0
Light Poster
f1 fan
16
Posting Whiz in Training
hollystyles
113
Veteran Poster
s_muenchaisit
0
Newbie Poster
s_muenchaisit
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.