Sql Server a Bağlanmak

 

Merhaba arkadaşlar bu makalemizde Sql Server a bağlanacağız. Bağlantı durumunu mesaj olarak göstereceğiz.

 

 

 

 

 

 

 

Şekil 1

 

 

Şekil 2

Form1.cs

 

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 sqlserver_database_connection

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

 

      

        private void button1_Click(object sender, EventArgs e)

        {

 

            string connetionStr = null;

            SqlConnection con;

 

            connetionStr = "Data Source=SIRIUS\\SQLEXPRESS;Initial Catalog=master;integrated security=true";

 

            con = new SqlConnection(connetionStr);

 

            try

 

            {

 

                con.Open();

 

                MessageBox.Show("Connection Open! " + (char)13 + "Sql Server a Baglanildi!");

 

                con.Close();

 

            }

 

            catch (Exception ex)

 

            {

 

                MessageBox.Show("Cannot open connection! " + (char)13 + "Sql Server a Baglanilamadi!");

 

            }

 

        }

 

    }

}

 

Click for details

Bir makalenin daha sonuna geldik. Bir sonraki makalede görüşmek üzere. Bahadır ŞAHİN

Share This:

Facebook Twitter Pinterest Linkedin Whatsapp Whatsapp

About Bahadır Şahin

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.