C# ile SQL Server Database'e ulaşmak.

 
  using System; 
  using System.Collections.Generic; 
  using System.ComponentModel; 
  using System.Data; 
  using System.Data.SqlClient; 
  using System.Drawing; 
  using System.Linq; 
  using System.Text; 
  using System.Threading.Tasks; 
  using System.Windows.Forms; 
   
  namespace WindowsFormsApplication1 
  { 
      public partial class Form1 : Form 
      { 
          SqlConnection hasan; 
          public Form1() 
          { 
              InitializeComponent(); 
          } 
   
          private void button1_Click(object sender, EventArgs e) 
          { 
              hasan = new SqlConnection("server="+txtservername.Text+";database=Master;user="+txtusername.Text+";pwd="+txtpassword.Text); 
              hasan.Open(); 
              MessageBox.Show("Bağlantı Açıldı"); 
          } 
   
          private void lblcikis_Click(object sender, EventArgs e) 
          { 
              hasan.Close(); 
              MessageBox.Show("Bağlantı Kapandı"); 
          } 
   
          private void btndatabases_Click(object sender, EventArgs e) 
          { 
              DataTable databases = hasan.GetSchema("Databases"); 
              listBox1.DataSource = databases; 
              listBox1.DisplayMember = "database_name"; 
              listBox1.ValueMember = "dbid"; 
              foreach (DataRow database in databases.Rows) 
              { 
                  String databaseName = database.Field<String>("database_name"); 
                  short dbID = database.Field<short>("dbid"); 
                  DateTime creationDate = database.Field<DateTime>("create_date"); 
              } 
          } 
   
          private void listBox1_SelectedIndexChanged(object sender, EventArgs e) 
          { 
   
          } 
   
   
   
      } 
   
  }