List all databases in SQL Server in ASP.Net Application using C#

Question

I want to display all SQL Server databases in a SQL Server instance and bind them to dropdownlist control in ASPNet

Mudassar · Accepted Answer

HTML  lthtml xmlns34httpwwww3org1999xhtml34gtltheadgt ltscript type34textjavascript34 src34httpajaxgoogleapiscomajaxlibsjquery1jqueryminjs34gtltscriptgt    lttitlegtlttitlegt   ltheadgtltbodygt    ltform id34form134 runat  34server34gt        Server ltaspTextBox ID  34txtInstance34 runat  34server34 gtltbr gt        UserName ltaspTextBox ID  34txtUserName34 runat  34server34 gtltbr gt        Password ltaspTextBox ID  34txtPassword34 runat  34server34 TextMode  34Password34 gtltbr gt        ltaspButton ID  34btnConnect34 OnClick  34Connect34 Text  34Connect34 runat  34server34 gtltbr gt        DatabasesltaspDropDownList ID  34ddlDatabases34 runat  34server34gtltaspDropDownListgt    ltformgtltbodygtlthtmlgtCode protected void Connect

Mudassar · Answer

For that refer herehttpwwwaspsnippetscomArticlesListInstalledSQLServerInstancesonmachineandLANusingCandVBNetaspx

List all databases in SQL Server in ASP.Net Application using C#

Company

Explore

Follow us

Contact Us