TFF Faal Hakem Birlikleri Üye Girişi C#.NET(C.NET)
TFF Faal Hakem Birlikleri Üye Girişi C#.NET(C.NET)…
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Data.OleDb;
using System.Windows.Forms;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0; Data Source=tff.mdb");
DataSet dtst = new DataSet();
OleDbCommand kmt = new OleDbCommand();
void listele()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("Select * From veriler", bag);
adtr.Fill(dtst, "veriler");
dataGridView1.DataSource = dtst;
dataGridView1.DataMember = "veriler";
bag.Close();
adtr.Dispose();
}
private void Form1_Load(object sender, EventArgs e)
{
listele();
}
private void button2_Click(object sender, EventArgs e)
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "INSERT INTO veriler (Lisans,Ad,Soyad,Dogum_tarih,Lisans_bas,il,brans) VALUES ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox7.Text + "') ";
kmt.ExecuteNonQuery();
bag.Close();
kmt.Dispose();
dtst.Clear();
listele();
}
private void button3_Click(object sender, EventArgs e)
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "DELETE FROM veriler WHERE Lisans='" + textBox8.Text + "'";
kmt.ExecuteNonQuery();
bag.Close();
kmt.Dispose();
dtst.Clear();
listele();
}
private void button1_Click(object sender, EventArgs e)
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "UPDATE veriler SET Lisans= '" + textBox1.Text + "', Ad='" + textBox2.Text + "',Soyad='" + textBox3.Text + "',Dogum_tarih='" + textBox4.Text + "',Lisans_bas='" + textBox5.Text + "',il='" + textBox6.Text + "',brans='" + textBox7.Text + "' WHERE Lisans='" + textBox1.Text + "'";
kmt.ExecuteNonQuery();
bag.Close();
kmt.Dispose();
dtst.Clear();
listele();
}
private void button4_Click(object sender, EventArgs e)
{
Application.Exit();
}
}
}
güzel proje,ellerinize salık,indirme linki yok 🙁