VISUAL C# SQL AYNI KOD VARMI KONTROL

      private void button3_Click(object sender, EventArgs e)
        {
            SqlConnection sqlConnection = new SqlConnection("Server = " + logoserver + "; Database = " + logodb + "; User Id = " + logouser + "; Password = " + logopass);


            using (SqlCommand sqlCommand = new SqlCommand("SELECT COUNT(*) from ZV_LOGO_HASTA where KODU = 112", sqlConnection))
            {
                sqlConnection.Open();
                int userCount = (int)sqlCommand.ExecuteScalar();
                if (userCount > 0)
                {
                    MessageBox.Show("BU KOD VAR");
                }
                else MessageBox.Show("BU KOD YOK");
            }
            sqlConnection.Close();
        }

Visual studio 2015le oracle db bağlantısı

Oracle Developer Tools for Visual Studio 2015 indir http://www.oracle.com/technetwork/developer-tools/visual-studio/overview/index.html

kur  ve kodlar
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;

using System.Windows.Forms;
using System.IO;
using Oracle.ManagedDataAccess;
using Oracle.ManagedDataAccess.Client;

namespace OracleTest
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        string oradb;
        private void Form1_Load(object sender, EventArgs e)
        {
       //bağlantı
            StreamReader sr = new StreamReader("dbConnect.txt");
            oradb = sr.ReadLine();
            sr.Close();


        }

        private void button1_Click(object sender, EventArgs e)
        {

            OracleConnection conn = new OracleConnection(oradb);
            conn.Open();
            StreamReader sr = new StreamReader("sql1.txt");
            string sql1 = sr.ReadLine();
            sr.Close();

            OracleCommand cmd = new OracleCommand();
            cmd.Connection = conn;
            cmd.CommandText = sql1;
            cmd.CommandType = CommandType.Text;
            OracleDataAdapter da = new OracleDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds, "ss");
            gridControl1.DataSource = ds.Tables["ss"];
            //OracleDataReader dr = cmd.ExecuteReader();
            //dataGridView1.DataSource = dr;

            //while (dr.Read())
            //{
            //    listBox1.Items.Add(dr.GetString(2));
            //}
            //conn.Dispose();

        }
    }
}

dbconnect.txt

Data Source=ORCL;User Id=hr;Password=hr;

windows iso usbye atma

Burdan https://www.microsoft.com/en-us/download/details.aspx?id=56485

Windows USB/DVD Download Tool 

indir ve isoyu göstererk usbye başlat ornegin ultra isodan atarsan atmaz 10 gb tek dosya mesela windows 10da var atmaz kopyalamaz bile usbye tek dosya 10 gbı burdan yaparsan okdir .ama