16 Mayıs 2012 Çarşamba

C# Try - Catch Kullanımı

Try - Cath kullanımına buradan Bakabilirsiniz

C# Random (Farklı Sayılar)

Formun Tamamı İçin Tıklayınız.


# CLASS İÇİ #

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.Collections;

namespace WindowsFormsApplication9
{
    class Class1
    {
        public int s = 0;
        public int c = 0;
      public ArrayList say = new ArrayList();
      public int i = 0;
        public int puan=0;
        public void rastgele(Form1 enes)
        {
           
            try
            {
                bool durum = true;
                int m = 0;
                while (durum)
                {
                    Random ras = new Random();
                    int a = ras.Next(1, 10);
                    int c = say.IndexOf(a);
                    if (c == -1)
                    {
                        say.Add(a);
                        m = say.Count;
                    }
                    if (m == 6)
                    {
                        durum = false;
                    }
                }
            }
            catch
            {
                MessageBox.Show("Kodlarda hata var");
            }
            enes.button1.Text = say[0].ToString();
            enes.button2.Text = say[1].ToString();
            enes.button3.Text = say[2].ToString();
            enes.button4.Text = say[3].ToString();
            enes.button5.Text = say[4].ToString();
            enes.button6.Text = say[5].ToString();
        }

        public void ikiz(Form1 bekir)
        {
            try
            {
                if (s == 2)
                {
                    MessageBox.Show("Başka seçilemez...");
                    s = 0;
                }
                else
                {
                    s += 1;
                }

            }
            catch
            {
                MessageBox.Show("Kodlarda hata var");
            }
        }
        public void topla(Form1 berk)
        {
            c = c + Convert.ToInt32(say[i].ToString());      
        }
        public void sonuc(Form1 mehtap)
        {
            if (c.ToString() == mehtap.textBox1.Text)
            {
                puan += 10;

                mehtap.label3.Text = puan.ToString();
            }
            else
            {
                puan -= 5;

                mehtap.label3.Text = puan.ToString();
            }

        }
    }
}



# BUTON İÇİ #

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;

namespace WindowsFormsApplication9
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        Class1 selim = new Class1();
        private void Form1_Load(object sender, EventArgs e)
        {

            selim.rastgele(this);

        }

        private void tabPage2_Click(object sender, EventArgs e)
        {
            selim.rastgele(this);
        }

        private void button1_Click(object sender, EventArgs e)
        {
            selim.ikiz(this);

            if (selim.s != 0)
            {
                button1.Enabled = false;
                selim.i = 0;
                selim.topla(this);


            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            selim.ikiz(this);

            if (selim.s != 0)
            {
                button2.Enabled = false;
                selim.i = 1;
                selim.topla(this);
            }
        }

        private void button4_Click(object sender, EventArgs e)
        {
            selim.ikiz(this);

            if (selim.s != 0)
            {
                button4.Enabled = false;
                selim.i = 3;
                selim.topla(this);
            }
        }

        private void button5_Click(object sender, EventArgs e)
        {
            selim.ikiz(this);

            if (selim.s != 0)
            {
                button5.Enabled = false;
                selim.i = 4;
                selim.topla(this);
            }
        }

        private void button6_Click(object sender, EventArgs e)
        {
            selim.ikiz(this);

            if (selim.s != 0)
            {
                button6.Enabled = false;
                selim.i = 5;
                selim.topla(this);
            }
        }

        private void button3_Click(object sender, EventArgs e)
        {
            selim.ikiz(this);

            if (selim.s != 0)
            {
                button3.Enabled = false;
                selim.i = 2;
                selim.topla(this);
            }
        }

        private void textBox1_KeyUp(object sender, KeyEventArgs e)
        {

            selim.sonuc(this);

        }
    }
}


12 Mayıs 2012 Cumartesi

Veritabani 3. Yazili Modulleri

Yazılı 3. ve 7. modülden ağırlıklı olarak çıkacak ( T-SQL Kodları )
4. Modülde sadece Trigger ve Prosedürler önemli..
Sql Kodlar önemli  ...
6. Modul ise sadece göz gezdirin ...
2. Yazılıdan tek fark biraz daha genel olarak sorulacak...

Modülleri İndirmek İçin Tıklayınız.

11 Mayıs 2012 Cuma

Veritabani SQL Kodlar(Sinavda Cikacak)

Indirmek Icin Tiklayin...

C# Randomla İşlem



İndirmek için Tıklayın...


BUTTON




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.Data.OleDb;

namespace WindowsFormsApplication2
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        int a = 0;
        int k=0;
        int s = 0;
        OleDbConnection emir = new OleDbConnection("Provider=microsoft.ace.oledb.12.0;data source=e.accdb");
        private void button14_Click(object sender, EventArgs e)
        {
            int m = 0;
            emir.Open();
            OleDbDataAdapter emir2 = new OleDbDataAdapter("select*from emir", emir);
            DataSet emir3 = new DataSet();
            emir2.Fill(emir3, "ş");
            int z = emir3.Tables[0].Rows.Count;
            for (int k = 0; k < z; k++)
            {
                if (textBox3.Text == emir3.Tables[0].Rows[k][0].ToString())
                {
                    m = 1;
                }
            }
            if (m == 1)
            {
                MessageBox.Show("aynı No Olamaz");
            }
            if (m == 0)
            {
                panel1.Visible = true;
                panel2.Visible = false;
                panel3.Visible = true;
                met();
                OleDbCommand emir5 = new OleDbCommand("insert into emir(okulno,ad,skor) values('" + textBox3.Text + "','" + textBox4.Text + "','0')", emir);
                emir5.ExecuteNonQuery();
            }
            emir.Close();
               
           
           
        }

        private void button1_Click(object sender, EventArgs e)
        {
            s = s + 1;
            if (s > 3)
            {
                s = 0;
                MessageBox.Show("En Fazla 3 Button Tıklayabilirsin");
            }
            else
            {
                a = a + Convert.ToInt32(button1.Text);
                button1.Enabled = false;
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            s = s + 1;
            if (s > 3)
            {
                s = 0;
                MessageBox.Show("En Fazla 3 Button Tıklayabilirsin");
            }
            else
            {
                a = a + Convert.ToInt32(button2.Text);
                button2.Enabled = false;
            }
        }

        private void button3_Click(object sender, EventArgs e)
        {
            s = s + 1;
            if (s > 3)
            {
                s = 0;
                MessageBox.Show("En Fazla 3 Button Tıklayabilirsin");
            }
            else
            {
                a = a + Convert.ToInt32(button3.Text);
                button3.Enabled = false;
            }
        }

        private void button4_Click(object sender, EventArgs e)
        {
            s = s + 1;
            if (s > 3)
            {
                s = 0;
                MessageBox.Show("En Fazla 3 Button Tıklayabilirsin");
            }
            else
            {
                a = a + Convert.ToInt32(button4.Text);
                button4.Enabled = false;
            }
        }

        private void button5_Click(object sender, EventArgs e)
        {
            s = s + 1;
            if (s > 3)
            {
                s = 0;
                MessageBox.Show("En Fazla 3 Button Tıklayabilirsin");
            }
            else
            {
                a = a + Convert.ToInt32(button5.Text);
                button5.Enabled = false;
            }
        }

        private void button6_Click(object sender, EventArgs e)
        {
            s = s + 1;
            if (s > 3)
            {
                s = 0;
                MessageBox.Show("En Fazla 3 Button Tıklayabilirsin");
            }
            else
            {
                a = a + Convert.ToInt32(button6.Text);
                button6.Enabled = false;
            }
        }

        private void button7_Click(object sender, EventArgs e)
        {
            s = s + 1;
            if (s > 3)
            {
                s = 0;
                MessageBox.Show("En Fazla 3 Button Tıklayabilirsin");
            }
            else
            {
                a = a + Convert.ToInt32(button7.Text);
                button7.Enabled = false;
            }
        }

        private void button8_Click(object sender, EventArgs e)
        {
            s = s + 1;
            if (s > 3)
            {
                s = 0;
                MessageBox.Show("En Fazla 3 Button Tıklayabilirsin");
            }
            else
            {
                a = a + Convert.ToInt32(button8.Text);
                button8.Enabled = false;
            }
        }

        private void button9_Click(object sender, EventArgs e)
        {
            s = s + 1;
            if (s > 3)
            {
                s = 0;
                MessageBox.Show("En Fazla 3 Button Tıklayabilirsin");
            }
            else
            {
                a = a + Convert.ToInt32(button9.Text);
                button9.Enabled = false;
            }
        }

        private void button10_Click(object sender, EventArgs e)
        {
            s = s + 1;
            if (s > 3)
            {
                s = 0;
                MessageBox.Show("En Fazla 3 Button Tıklayabilirsin");
            }
            else
            {
                a = a + Convert.ToInt32(button10.Text);
                button10.Enabled = false;
            }
        }

        private void button11_Click(object sender, EventArgs e)
        {
            s = s + 1;
            if (s > 3)
            {
                s = 0;
                MessageBox.Show("En Fazla 3 Button Tıklayabilirsin");
            }
            else
            {
                a = a + Convert.ToInt32(button11.Text);
                button11.Enabled = false;
            }
        }

        private void button12_Click(object sender, EventArgs e)
        {
            s = s + 1;
            if (s > 3)
            {
                s = 0;
                MessageBox.Show("En Fazla 3 Button Tıklayabilirsin");
            }
            else
            {
                a = a + Convert.ToInt32(button12.Text);
                button12.Enabled = false;
            }
        }

        private void button13_Click(object sender, EventArgs e)
        {
            int b = Convert.ToInt32(textBox1.Text);
            if (b == a)
            {
                a = 0;
                k = k + 10;
                textBox2.Text = k.ToString();
                s = 0;
                textBox1.Clear();
                MessageBox.Show("Doğru Bildiniz");
                me();
            }
           else
            {
                a = 0;
                k = k - 5;
                textBox2.Text = k.ToString();
                s = 0;
                textBox1.Clear();
                MessageBox.Show("Yanlış Bildiniz");
                me();
            }
        }
        public void met()
        {
            Random em = new Random();
            int c = em.Next(1, 30);
            int c1 = em.Next(1, 30);
            int c2 = em.Next(1, 30);
            int c3 = em.Next(1, 30);
            int c4 = em.Next(1, 30);
            int c5 = em.Next(1, 30);
            int c6 = em.Next(1, 30);
            int c7 = em.Next(1, 30);
            int c8 = em.Next(1, 30);
            int c9 = em.Next(1, 30);
            int c10 = em.Next(1, 30);
            int c11 = em.Next(1, 30);
            button1.Text = c.ToString();
            button2.Text = c1.ToString();
            button3.Text = c2.ToString();
            button4.Text = c3.ToString();
            button5.Text = c4.ToString();
            button6.Text = c5.ToString();
            button7.Text = c6.ToString();
            button8.Text = c7.ToString();
            button9.Text = c8.ToString();
            button10.Text = c9.ToString();
            button11.Text = c10.ToString();
            button12.Text = c11.ToString();
        }
        public void me()
        {
            emir.Open();
            OleDbCommand emir5 = new OleDbCommand("update emir set skor='" + textBox2.Text + "' where okulno='" + textBox3.Text + "'", emir);
            emir5.ExecuteNonQuery();
            emir.Close();
        }

        private void button15_Click(object sender, EventArgs e)
        {
            int i=0;
            emir.Open();
            OleDbDataAdapter emir2 = new OleDbDataAdapter("select*from emir order by skor desc", emir);
            DataSet emir3 = new DataSet();
            emir2.Fill(emir3, "ş");
            int z = emir3.Tables[0].Rows.Count;
            for (int k = 0; k < z; k++)
            {
                listBox1.Items.Add(++i + ")" + emir3.Tables[0].Rows[k][0] + " " + emir3.Tables[0].Rows[k][1] + " " + emir3.Tables[0].Rows[k][2]);
            }
        }
    }
}