Notes

namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
SqlConnection coni = new SqlConnection("data source=.;initial catalog=Ogrenciler;integrated security=sspi");
DataTable tablo = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand kmt = new SqlCommand();
private void Form1_Load(object sender, EventArgs e)
{
listele();
if (coni.State==ConnectionState.Closed)
{
coni.Open();
}

DataSet ds = new DataSet();
da = new SqlDataAdapter("select * from ogrbil",coni);
da.Fill(ds, "ogrbil");
dataGridView1.DataSource = ds.Tables["ogrbil"];
dataGridView1.Columns[0].HeaderText = "NUMARASI";
dataGridView1.Columns[1].HeaderText = "İSMİ";
dataGridView1.Columns[2].HeaderText = "SOY İSMİ";
dataGridView1.Columns[3].HeaderText = "SINIFI/ŞUBESİ";
dataGridView1.Columns[0].Width = 176;
dataGridView1.Columns[1].Width = 176;
dataGridView1.Columns[2].Width = 176;
dataGridView1.Columns[3].Width = 176;
}
void listele()
{
tablo.Clear();
da = new SqlDataAdapter("select * from ogrbil",coni);
da.Fill(tablo);
dataGridView1.DataSource = tablo;
}

private void btnGoster_Click(object sender, EventArgs e)
{
da = new SqlDataAdapter();
DataSet ds = new DataSet();
da = new SqlDataAdapter("select * from ogrbil where adi='" + txtbxIsmgr.Text + "'", coni);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
txtbxIsmgr.Text = "";
}

private void button1_Click(object sender, EventArgs e)
{
Form1_Load(sender,e);
}

private void btnEkle_Click(object sender, EventArgs e)
{
if (coni.State == ConnectionState.Closed)
{
coni.Open();
}
kmt.Connection = coni;
kmt.CommandText = "INSERT INTO ogrbil(nosu,adi,soyadi,sinifi) VALUES('" + Convert.ToInt32( txtbxNosu.Text )+ "','"+txtbxAdi.Text+"','"+txtbxSoyad.Text+"','"+txtbxSinif.Text+"') ";
kmt.ExecuteNonQuery();
kmt.Dispose();
coni.Close();
listele();
txtbxNosu.Clear();
txtbxAdi.Clear();
txtbxSoyad.Clear();
txtbxSinif.Clear();
}
}
}