OleDbConnection baglanti = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; DATA Source=" + Server.MapPath("App_Data/haber.accdb"));
baglanti.Open();
//www.aspnetornekleri.com
OleDbCommand db_komut = new OleDbCommand("Select * from notlar", baglanti);
OleDbDataReader alinan_veri;
alinan_veri = db_komut.ExecuteReader();
double ortalama = 0;
if (alinan_veri.HasRows)
{
while (alinan_veri.Read())
{
ortalama = (Int16.Parse(alinan_veri["not1"].ToString()) + Int16.Parse(alinan_veri["not2"].ToString()) + Int16.Parse(alinan_veri["not3"].ToString())) / 3;
OleDbCommand ekle = new OleDbCommand("Insert INTO ortalama ( ogrenci_id, ortalama ) Values( '" + alinan_veri["ogrenci_id"].ToString() + "'," + ortalama + ")", baglanti);
ekle.ExecuteNonQuery();
}
}
baglanti.Close();