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.sysdatabasesCon); 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.