Orhan SALUR

Orhan SALUR

  • NA
  • 49
  • 23k

how can i connect to database?

May 4 2015 6:58 PM
 static void sqlVeriSorgulama()
     {
         //string komut;
         try
         {
             SqlConnection baglanti = new SqlConnection();
             baglanti.ConnectionString = "Data Source = COMPUTER1; database =NORTHWND; integrated security = true";
             baglanti.Open();
             SqlCommand komutSatiri = new SqlCommand("select top 1  * from Products  order by UnitsInStock desc", baglanti);

             komutSatiri.ExecuteNonQuery();
             Console.WriteLine(komutSatiri.ToString());
             komutSatiri.ToString();
             Console.WriteLine("basarili");
             baglanti.Close();
            
         }
         catch (Exception )
         {

             Console.WriteLine("hata olustu");
         }
     
     }

Answers (4)