CREATE TABLE `tyorumlar` (
`YorumID` int(11) NOT NULL AUTO_INCREMENT,
`Yorum` varchar(255) COLLATE utf8_turkish_ci DEFAULT NULL,
`EkleyenID` int(11) DEFAULT NULL,
PRIMARY KEY (`YorumID`),
KEY `fk_uye_yorum` (`EkleyenID`),
CONSTRAINT `fk_uye_yorum` FOREIGN KEY (`EkleyenID`) REFERENCES `tuyeler` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci
CREATE TABLE `tuyeler` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`adsoyad` varchar(450) COLLATE utf8_turkish_ci DEFAULT NULL,
`uye` varchar(50) COLLATE utf8_turkish_ci NOT NULL,
`sifre` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
`eposta` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
`seviye` int(11) DEFAULT NULL,
`iuser` tinyint(4) DEFAULT '0',
`auser` tinyint(4) DEFAULT '0',
`suser` tinyint(4) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci<asp:RadioButtonList ID="RadioButtonList1" runat="server" AutoPostBack="True"
onselectedindexchanged="RadioButtonList1_SelectedIndexChanged"
RepeatDirection="Horizontal">
<asp:ListItem>Üyeler Tablosuna Göre</asp:ListItem>
<asp:ListItem>Yorumlar Tablosuna Göre</asp:ListItem>
</asp:RadioButtonList>
<br />
<asp:Literal ID="Literal1" runat="server"></asp:Literal>using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using balikesirModel;
using System.Text;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
private void UyeToYorumlar()
{
using (var db = new balikesirEntities())
{
var uyeler = from uye in db.tuyelers.Include("tyorumlars")
select uye;
StringBuilder sb = new StringBuilder();
foreach (var uye in uyeler)
{
sb.AppendFormat("<p><b>{0}</b>", uye.adsoyad);
foreach (var yorum in uye.tyorumlars)
{
sb.AppendFormat("<br />|-->{0}", yorum.Yorum);
}
sb.Append("</p>");
}
Literal1.Text = sb.ToString();
}
}
private void YorumFromUyeler()
{
using (var db = new balikesirEntities())
{
var yorumlar = from yorum in db.tyorumlars.Include("tuyeler")
select yorum;
StringBuilder sb = new StringBuilder();
foreach (var yorum in yorumlar)
{
sb.AppendFormat("<p><b>{0}</b>", yorum.Yorum);
sb.AppendFormat("<br />Gönderen:{0}", yorum.tuyeler.adsoyad);
sb.Append("</p>");
}
Literal1.Text = sb.ToString();
}
}
protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e)
{
if(RadioButtonList1.SelectedIndex==0)
this.UyeToYorumlar();
else
this.YorumFromUyeler();
}
}