1-) C# -  MSSQL(basit) veri cekme

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 ileriveritab

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        SqlConnection conn = null;//VERİ TABANINA BAĞLANTI İÇİN

        private void dllcek()//Gridviewi doldurur

        {

            try

            {

                conn = new SqlConnection(@"Data Source=RAMBO;Initial Catalog=ileriprog;User ID=sa;Password=123;");

                //Data Source    = server name

                //initial catalog= veri tabanı ismi

                //User ID        = bağlantı için id

                // Password      = bağlantı için şifre

                conn.Open();

                SqlCommand sqlkomut = null;

                sqlkomut = new SqlCommand("select isim from al", conn);

                SqlDataReader dr = null;

                dr = sqlkomut.ExecuteReader();

                while (dr.Read())

                {

                    textBox1.Text = textBox1.Text + "\n" + dr["isim"];

                }

            }

            catch (Exception E)

            {

                Console.Write("hata burada " + E.Message);

            }

            finally

            {

                conn.Close();

            }

        }

        private void button1_Click(object sender, EventArgs e)

        {

            dllcek();

        }

    }

}