[RESOLVED] Getting Database names

[sureshvijayan]

I have a listbox control and need to extract all the databases in the local MSSQl server to listbox control (using sqlconnection)

Code please...

[ksureshreddy27]

using SQLDMO; (By adding reference to SQLDMO.dll)

SQLDMO.SQLServerClass objSQLServer = new SQLDMO.SQLServerClass();
objSQLServer.Connect("server", "username", "password");
foreach ( SQLDMO.Database db in objSQLServer.Databases)
{
ListBox2.Items.Add(db.Name);
}

[sureshvijayan]

using SQLDMO; (By adding reference to SQLDMO.dll)

SQLDMO.SQLServerClass objSQLServer = new SQLDMO.SQLServerClass();
objSQLServer.Connect("server", "username", "password");
foreach ( SQLDMO.Database db in objSQLServer.Databases)
{
ListBox2.Items.Add(db.Name);
}

thanks yar!!!