Gelişmiş Anket Sistemi — Csharp

Gelişmiş Anket Sistemi — Csharp

Anket Giriş

 

 

[code lang=”csharp”]using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;//www.gorselprogramlama.com
using System.Text;
using System.Windows.Forms;

using System.Data.OleDb;

namespace Gelişmiş_Anket_Sistemi
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

OleDbConnection baglanti = new OleDbConnection("Provider=Microsoft.Ace.OleDb.12.0;Data Source=anket.accdb");

void baglantiKur()
{
if (baglanti.State == ConnectionState.Closed)
{
baglanti.Open();
}
}//www.gorselprogramlama.com

private void btnAnketAdd_Click(object sender, EventArgs e)
{
if (txtNick.Text == "coelho" && txtPass.Text == "123")
{
Form2 frm2 = new Form2();
frm2.Show();
this.Hide();
}
else
{
MessageBox.Show("Yanlış kullanıcı adı veya şifre");
}//www.gorselprogramlama.com
}

private void cbAnket_Click(object sender, EventArgs e)
{
cbAnket.Items.Clear();

baglantiKur();
string sql_Getir = "SELECT DISTINCT anket_soru FROM anket_sorulari";
OleDbCommand cmd_Getir = new OleDbCommand(sql_Getir,baglanti);
OleDbDataReader oku;
oku = cmd_Getir.ExecuteReader();
while (oku.Read())
{
cbAnket.Items.Add(oku[0]);
}//www.gorselprogramlama.com

baglanti.Close();
}

private void btnAnket_Click(object sender, EventArgs e)
{
if (cbAnket.SelectedIndex != -1)
{
Form3 frm3 = new Form3();
frm3.anket_Sorusu = cbAnket.Text;
frm3.Show();
this.Hide();
}
else
{
MessageBox.Show("Anket Sorusunu Seçiniz.");
}

}

private void btnSonucView_Click(object sender, EventArgs e)
{
if (cbAnket.SelectedIndex != -1)
{
Form4 frm4 = new Form4();
frm4.anket_Sorusu = cbAnket.Text;
frm4.Show();
this.Hide();
}
else
{
MessageBox.Show("Anket Sorusunu Seçiniz.");
}
}//www.gorselprogramlama.com

}
}
[/code]

Anket Kayıt

 

 

[code lang=”csharp”]using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;//www.gorselprogramlama.com
using System.Text;
using System.Windows.Forms;

using System.Data.OleDb;

namespace Gelişmiş_Anket_Sistemi
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}

OleDbConnection baglanti = new OleDbConnection("Provider=Microsoft.Ace.OleDb.12.0;Data Source=anket.accdb");

void baglantiKur()
{
if (baglanti.State == ConnectionState.Closed)
{
baglanti.Open();
}//www.gorselprogramlama.com
}

private void btnSecSil_Click(object sender, EventArgs e)
{
if (lstSec.SelectedIndex != -1)
{
lstSec.Items.RemoveAt(lstSec.SelectedIndex);
}
}

string SecBirlestir()
{
string sec = "";
for (int i = 0; i < lstSec.Items.Count; i++)
{
sec += lstSec.Items[i].ToString() + "|";
}
sec = sec.Remove(sec.Length – 1, 1);
return sec;
}

private void btnAnketKayit_Click(object sender, EventArgs e)
{
txtAnketAdi.Text = txtAnketAdi.Text.Replace(‘\”,’ ‘);
baglantiKur();
string sql_Ekle = "INSERT INTO anket_sorulari(anket_soru,anket_cevap) VALUES(‘" + txtAnketAdi.Text + "’,’" + SecBirlestir() + "’)";
OleDbCommand cmd_Ekle = new OleDbCommand(sql_Ekle, baglanti);
cmd_Ekle.ExecuteNonQuery();
baglanti.Close();

lstSec.Items.Clear();
txtAnketAdi.Text = "";
txtSec.Text = "";

Form1 frm1 = new Form1();
frm1.Show();
this.Hide();//www.gorselprogramlama.com
}

private void btnSecEkle_Click(object sender, EventArgs e)
{
lstSec.Items.Add(txtSec.Text);
txtSec.Text = "";
}

}
}
[/code]

Anket

 

[code lang=”csharp”]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;
//www.gorselprogramlama.com
namespace Gelişmiş_Anket_Sistemi
{
public partial class Form3 : Form
{
public Form3()
{
InitializeComponent();
}

public string anket_Sorusu = "";
string sonuc = "";

OleDbConnection baglanti = new OleDbConnection("Provider=Microsoft.Ace.OleDb.12.0;Data Source=anket.accdb");

int top = 0;
void baglantiKur()
{
if (baglanti.State == ConnectionState.Closed)
{
baglanti.Open();
}
}//www.gorselprogramlama.com

private void Form3_Load(object sender, EventArgs e)
{
lblAnketSoru.Text = anket_Sorusu;

baglantiKur();
string sql = "SELECT * FROM anket_sorulari WHERE anket_soru=’" + anket_Sorusu + "’";
OleDbCommand cmd = new OleDbCommand(sql, baglanti);
OleDbDataReader oku;
oku = cmd.ExecuteReader();
while (oku.Read())
{
string[] secenekler = oku[2].ToString().Split(‘|’);
for (int i = 0; i < secenekler.Length; i++)
{
RadioButton rb = new RadioButton();
rb.Left = 6;
top += 23;
rb.Top = top;
rb.Text = secenekler[i];
rb.Click += new EventHandler(rb_Click);
this.Controls.Add(rb);
}
}
baglanti.Close();

Button btn = new Button();
btn.Left = 6;
top+=23;
btn.Top = top;
btn.Size = new Size(150,30);
btn.Text = "Oy veriniz.";
btn.Click += new EventHandler(btn_Click);
this.Controls.Add(btn);

}//www.gorselprogramlama.com

void rb_Click(object sender, EventArgs e)
{
sonuc = ((RadioButton)sender).Text;
}

void btn_Click(object sender, EventArgs e)
{
baglantiKur();
string sql = "INSERT INTO anket_sonuclari(anket_soru,anket_cevap) VALUES(‘" + anket_Sorusu + "’,’" + sonuc + "’)";
OleDbCommand cmd = new OleDbCommand(sql,baglanti);
cmd.ExecuteNonQuery();
baglanti.Close();

MessageBox.Show("Oy verdiğiniz için teşekkürler.");
((Button)sender).Enabled = false;
}//www.gorselprogramlama.com

private void Form3_FormClosing(object sender, FormClosingEventArgs e)
{
Form1 frm1 = new Form1();
frm1.Show();
}
}
}
[/code]

Anket Sonuçları

 

[code lang=”csharp”]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 Gelişmiş_Anket_Sistemi
{//www.gorselprogramlama.com
public partial class Form4 : Form
{
public Form4()
{
InitializeComponent();
}

public string anket_Sorusu = "";

OleDbConnection baglanti = new OleDbConnection("Provider=Microsoft.Ace.OleDb.12.0;Data Source=anket.accdb");
int toplamOy = 0;
int top = 56;
void baglantiKur()
{
if (baglanti.State == ConnectionState.Closed)
{
baglanti.Open();
}//www.gorselprogramlama.com
}

string SecenekleriGetir()
{
string sec = "";
baglantiKur();
string sql = "SELECT * FROM anket_sorulari WHERE anket_soru =’" + anket_Sorusu + "’";
OleDbCommand cmd = new OleDbCommand(sql, baglanti);
OleDbDataReader oku;
oku = cmd.ExecuteReader();
while (oku.Read())
{
sec = oku[2].ToString();
}
return sec;
}//www.gorselprogramlama.com

private void Form4_Load(object sender, EventArgs e)
{
//SecenekleriGetir();
lblAnketSoru.Text = anket_Sorusu;
baglantiKur();
string sql = "SELECT * FROM anket_sonuclari WHERE anket_soru = ‘" + anket_Sorusu + "’";
OleDbCommand cmd = new OleDbCommand(sql, baglanti);
OleDbDataReader oku;
oku = cmd.ExecuteReader();
string[] secenekler = SecenekleriGetir().Split(‘|’);
int[] adet = new int[secenekler.Length];
while (oku.Read())
{
for (int i = 0; i < secenekler.Length; i++)
{
if (secenekler[i] == oku[1].ToString())
{
adet[i]++;
}
}
toplamOy++;
}
baglanti.Close();

for (int i = 0; i < secenekler.Length; i++)
{
Label lbl = new Label();
ProgressBar pb = new ProgressBar();
lbl.Left = 12;
top += 23;
lbl.Top = top;
lbl.Text = secenekler[i] + " : " + adet[i].ToString();

pb.Left = lbl.Size.Width + 20;
pb.Top = top – 3;
pb.Size = new Size(131, 17);

if (toplamOy != 0)//www.gorselprogramlama.com
{
pb.Value = (100 * adet[i]) / toplamOy;
}

this.Controls.Add(lbl);
this.Controls.Add(pb);
}

lblOy.Text = toplamOy.ToString();
}

private void Form4_FormClosing(object sender, FormClosingEventArgs e)
{
Form1 frm1 = new Form1();
frm1.Show();
}
//www.gorselprogramlama.com

}
}
[/code]

Projeyi İNDİR