DataBind

Question

Hi... I want to Bind all database name of sql server in dropdownlist..pls help someone.. How to Bind.....

Rekha Singh · Answer

Manoj , just use the following code for binding all database name in an DropDownList string sqlText = "select CATALOG_NAME from INFORMATION_SCHEMA.SCHEMATA " ; SqlConnection connection = new SqlConnection ( "ur connection string" ); connection.Open(); DataSet ds = new DataSet (); SqlDataAdapter ad = new SqlDataAdapter (sqlText, connection); ad.Fill(ds); DropDownList1.DataSource = ds.Tables[0]; DropDownList1.DataTextField= "CATALOG_NAME" ; DropDownList1.DataBind(); ***************************************** Please mark it Accepted if u find it helpful.

Rekha Singh · Answer

m gettin al database names of a particular server if i run this .i thnk this is wat u asked for right select CATALOG_NAME from INFORMATION_SCHEMA.SCHEMATA

Santhosh N · Answer

did you miss my post from all these days as you accepted the very same query i posted you well ahead.. :)

Gaurish Kumar · Answer

Hi Manoj Use this query to get all the database list select name from master..sysdatabases

manoj kumar · Answer

Hi Rekha ji... your Article is very fantastic....but i want display all databse name...bt you artile display only particular database name..pls tell me wt shou;d I do? pls help me....

Hiren Soni · Answer

Lalit M · Answer

try this articles http://www.dotnetheaven.com/UploadFile/rahul4_saxena/dropdownlisiindatagrid05082007024918AM/dropdownlisiindatagrid.aspx if vb.net

Kumar Duvvarapu · Answer

Hi Manoj, Please read the below link: http://www.eggheadcafe.com/community/aspnet/13/10053076/how-to-get-list-of-all-da.aspx Hope this will help you. Thanks and Regards, Kumar

Santhosh N · Answer

you can try this code and bind all the database names in the particular server.. SqlConnection sqlConn = new SqlConnection("connection string"); sqlConn.Open(); SqlCommand sqlComm = new SqlCommand("SELECT name FROM master.sysdatabases", sqlConn); SqlDataReader myReader = sqlComm.ExecuteReader(); while (myReader.Read()) { ddlDataBaseList.Items.Add(myReader[0]); } sqlConn.Close();

DataBind

Answers (9)