C# windows application

Question

hi friends ....i want get all the databases list in windows application .. is it possible ? i think it is possible but how to start to write coding for this ..

srikanthreddy · Answer

thank you very much..........

srikanthreddy · Answer

thank you very much..........

srikanthreddy · Answer

thank you very much..............

Vikrant Jadhav · Answer

Hi Sri , Use the following code u get desire result display in Datagridview using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace DisplayDBNames { public partial class frmForm : Form { SqlConnection conn = new SqlConnection("Server=PC-520\SQLEXPRESS;Database=SampleDB;Integrated Security=True"); private void btnShowDB_Click(object sender, EventArgs e) { conn.Open(); DataTable dbList = conn.GetSchema("Databases"); //get all database list conn.Close(); dataGridView1.DataSource =dbList; } } } Thanks & Regards Vikrant Jadhav If this post is helpful to you Then Please mark as a "Correct Answer".

Pravin Ghadge · Answer

Plz find the attached file.

Pravin Ghadge · Answer

adp=new SqlDataadapter("SELECT name FROM sys.sysdatabases",Con); Con.open(); Dataset ds=new DataSet(); adp.Fill(ds); In ds, u will get list of all databases. Where u want to fill this list.

C# windows application

Answers (6)