Okul Veritabanı (Sql
Server)
AnaForm.cs
|
private void
button1_Click
//Öğrenci Formu
OgrenciForm
ogrForm = new OgrenciForm();
ogrForm.ShowDialog();
private void
button2_Click
//Ders Formu
DersForm
dersForm = new DersForm();
dersForm.ShowDialog();
private void
button4_Click
//Notlar Formu
NotlarForm
notlarForm = new NotlarForm();
notlarForm.ShowDialog();
private void
button3_Click
DataClasses1DataContext
icerik = new DataClasses1DataContext();
var sonuc
= icerik.Notlars.Where(p => p.OgrNo == textBox1.Text);
dataGridView1.DataSource = sonuc;
|
OgrenciForm.cs
|
//Linq2Sql ile Kayıt
Ekleme
Ogrenci yeniOgrenci = new Ogrenci();
yeniOgrenci.OgrNo =
textBox1.Text;
yeniOgrenci.Adi = textBox2.Text;
yeniOgrenci.Soyadi =
textBox3.Text;
DataClasses1DataContext icerik = new DataClasses1DataContext();
icerik.Ogrencis.InsertOnSubmit(yeniOgrenci);
icerik.SubmitChanges();
|
DersForm.cs
|
//Linq2Sql ile Ders
Ekleme
Der yeniDers = new Der();
yeniDers.DersKodu =
textBox1.Text;
yeniDers.DersAdi= textBox2.Text;
DataClasses1DataContext icerik = new DataClasses1DataContext();
icerik.Ders.InsertOnSubmit(yeniDers);
icerik.SubmitChanges();
|
NotlarForm.cs
|
private void
NotlarForm_Load(object sender, EventArgs e)
{
DataClasses1DataContext
icerik = new DataClasses1DataContext();
//Ogrenciler
comboBox1.DataSource = icerik.Ogrencis;
comboBox1.DisplayMember = "Adi";
comboBox1.ValueMember = "OgrNo";
//Dersler
comboBox2.DataSource = icerik.Ders;
comboBox2.DisplayMember = "DersAdi";
comboBox2.ValueMember = "DersKodu";
}
//Not Ekle
Notlar yeniNot = new Notlar();
yeniNot.DersKodu =
comboBox2.SelectedValue.ToString();
yeniNot.OgrNo =
comboBox1.SelectedValue.ToString();
yeniNot.Vize = int.Parse(textBox3.Text);
yeniNot.Final = int.Parse(textBox4.Text);
DataClasses1DataContext icerik = new DataClasses1DataContext();
icerik.Notlars.InsertOnSubmit(yeniNot);
icerik.SubmitChanges();
MessageBox.Show("Not
eklendi"); nchar(10)
|
Hiç yorum yok:
Yorum Gönder