How can i get all database using smo

Accepted answer

using Microsoft.SqlServer.Management.Common;

using Microsoft.SqlServer.Management.Smo;

cbo.Items.Clear();

ServerConnection conn = new ServerConnection();

conn.ServerInstance = server;

conn.LoginSecure = false;

conn.Login = login;

conn.Password = password;

Server srv = new Server(conn);

// to get all the database

foreach (Database db in srv.Databases)

{

cbo.Items.Add(db.Name);

}

//to get all the tables
Database db = srv.Databases["TestDB"];

foreach (var table in db.Tables)

{

cbo.Items.Add(table.ToString());

}

SMO is Always my favorite. Stay tuned on my upcoming article.

hope it helps

yes ofcourse

hey are you talking about Sql server management Object in C# ?