using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using Microsoft.Win32;
using System.Data.OleDb;
namespace Den1
{
public partial class profil : Form
{
public girispaneli frmgiris;
public profil()
{
InitializeComponent();
}
public OleDbConnection baglanti = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=sql.mdb");
public OleDbCommand komut = new OleDbCommand();
public DataSet tablo = new DataSet();
public object Listview1 { get; private set; }
private **** verilerigöster()
{
baglanti.Open();
OleDbDataAdapter yenial = new OleDbDataAdapter("Select * from verilerigöster", baglanti);
yenial.Fill(tablo, "verilerigöster");
dataGridView1.DataSource = tablo.Tables["verilerigöster"];
baglanti.Close();
{
}
}
private **** button2_Click(object sender, EventArgs e)
{
buttonguncelle.Enabled = true;
txtisim.Enabled = true;
txtsinif.Enabled = true;
txtnumara.Enabled = true;
txt9sinif.Enabled = true;
txt10sinif.Enabled = true;
txt11sinif.Enabled = true;
txt12sinif.Enabled = true;
txt12sinif.Enabled = true;
txtnot. Enabled = true;
}
private **** profil_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'sqlDataSet.Profil' table. You can move, or remove it, as needed.
this.profilTableAdapter.Fill(this.sqlDataSet.Profil);
}
private **** buttonkaydet_Click(object sender, EventArgs e)
{
}
private **** dataGridView2_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
}
private **** buttonguncelle_Click(object sender, EventArgs e)
{
try
{
baglanti.Open();
komut.Connection = baglanti;
komut.CommandText = "update Profil set İsim='"+txtisim.Text+"',Sınıf='"+txtsinif.Text+"',Numara='"+txtnumara.Text+"',9 sınıf='"+txt9sinif.Text+"',10 sınıf='"+txt10sinif.Text+"',11 sınıf='"+txt11sinif.Text+"',12 sınıf='"+txt12sinif.Text+"',Hakkında='"+txtnot.Text+"'where id = '"+txtid.Text+"'";
komut.ExecuteNonQuery();
baglanti.Close();
tablo.Tables["verilerigöster"].Clear();
verilerigöster();
}
catch
{
MessageBox.Show("Seçmediniz!");
}
}
private **** buttonyenikayit_Click(object sender, EventArgs e)
{
verilerigöster();
}
}
}
