DataTable GetComments()
{
DatabaseMethods db = new DatabaseMethods();
db.OpenConnection();
DataTable dt = db.GetDataTable("Select * from Yorum");
GridViewComments.DataSource = dt;
GridViewComments.DataBind();
db.CloseConnection();
return dt;
}
DataTable GetComments(String id)
{
DatabaseMethods db = new DatabaseMethods();
db.OpenConnection();
DataTable dt = db.GetDataTable("Select y.YorumId , y.YorumIcerik , y.MakaleID , y.Tarih , y.Onay , u.Name from Yorum y , Users u where y.User_id = u.User_Id and y.MakaleId=" + makale_id);
rpt_Comment.DataSource = dt;
rpt_Comment.DataBind();
db.CloseConnection();
return dt;
}
void GetTags(String id)
{
DatabaseMethods db = new DatabaseMethods();
db.OpenConnection();
DataTable dt = db.GetDataTable("SELECT e.EtiketAd FROM Makale m , MakaleEtiket me , Etiket e WHERE me.MakaleId = m.MakaleId AND me.EtiketId = e.EtiketId AND m.MakaleId = " + makale_id);
dl_Tags.DataSource = dt;
dl_Tags.DataBind();
db.CloseConnection();
}
string GetCommentCount()
{
DatabaseMethods db = new DatabaseMethods();
db.OpenConnection();
DataTable dt = db.GetDataTable("Select COUNT(y.MakaleID) as Comment_Count from Yorum y where y.MakaleID = " + makale_id);
db.CloseConnection();
return dt.Rows[0]["Comment_Count"].ToString();
}
void GetContent(String id)
{
DatabaseMethods db = new DatabaseMethods();
db.OpenConnection();
DataTable dt = db.GetDataTable("Select * from Makale Where MakaleId =" + makale_id);
rpt_Makale.DataSource = dt;
rpt_Makale.DataBind();
db.CloseConnection();
}