protected void Button1_Click(object sender, EventArgs e)
{
try
{
var blg = (from b in db.TBLBLOCG
join c in db.TBLCATEGORY
on b.BLOGCATEGORY equals c.CATID
join t in db.TBLTYPE
on b.BLOGTYPE equals t.TYPEID
where b.BLOGBASLIQ.Contains(txtSearch.Text) || c.CATNAME.Contains(txtSearch.Text) || t.TYPENAME.Contains(txtSearch.Text)
select new
{
BLOGID = b.BLOGID,
BLOGBASLIQ = b.BLOGBASLIQ,
BLOGTAARIX = b.BLOGTAARIX,
BLOGMEDIA = b.BLOGMEDIA,
BLOGTYPE = t.TYPENAME,
BLOGCATEGORY = c.CATNAME
}).ToList();
RepCatBlog.DataSource = blg;
RepCatBlog.DataBind();
}
catch (Exception ex)
{
Label1.Text = ex + " Tapılmaı";
}
}
protected void Page_Load(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["CATID"]);
var cat = db.TBLBLOCG.Where(m => m.BLOGCATEGORY == id).ToList();
RepCatBlog.DataSource = cat;
RepCatBlog.DataBind();
}