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]; }