DataTable MakaleOzetGetir()
{
DatabaseMethods db = new DatabaseMethods();
db.OpenConnection();
DataSet ds = db.GetDataset("SELECT m.MakaleId , Baslik , m.Tarih , Ozet , Count(y.MakaleID) " +
" as Yorum_Count FROM Makale m LEFT JOIN Yorum y " +
"ON m.MakaleId = y.MakaleID GROUP BY m.MakaleId , Baslik , m.Tarih , Ozet" +
" ORDER BY m.Tarih DESC");
rptMakaleOzet.DataSource = ds.Tables[0];
rptMakaleOzet.DataBind();
db.CloseConnection();
return ds.Tables[0];
}
