using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.EnterpriseServices;
using System.Data.EntityModel;
using jayModel;
using System.Data.Linq.SqlClient;
public partial class Default2 : System.Web.UI.Page
{
jayEntities j = new jayEntities();
Table1 t = new Table1();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
int i = Convert.ToInt32(TextBox1.Text);
/* If where condition for one field Require */
var a = j.Table1.Where(m => m.id == i).ToList().Select(m => m.name);
GridView1.DataSource = a;
GridView1.DataBind();
/* if where condition require */
var d1 = j.Table1.Where(f => f.name.StartsWith("h")&& f.name.Contains("c")).Select(f=>f.name);
/*Display two field
//var d1 = j.Table1.Select(f => new { f.id,f.name}).OrderBy(f=>f.name).Where(f=>f.id==i);
// var d4 = j.Table1.Select(f => new { f.name });*/
GridView2.DataSource = d1;
GridView2.DataBind();
/*All Table Data */
var d2 = j.Table1.ToList();
GridView3.DataSource = d2;
GridView3.DataBind();
/*If where condition for two field Require */
//List<jayModel.Table1> list = new List<jayModel.Table1>();
var list = j.Table1.Where(m => m.id == i).ToList();
//var list1 = j.count_tbl.Where(m => m.id == i).ToList();
var objJoin = list.Join(list, b => b.id, c => c.id, (b, c) => new { name = b.name, address = b.Address });
//left outer join
var q = from t1 in j.Table1
join t2 in j.count_tbl on t1.id equals t2.id into t1t2
from t2 in t1t2.DefaultIfEmpty()
select new { t1.id, t1.name };
//right outer join
var q1 = from t2 in j.count_tbl join t1 in j.Table1 on t2.id equals t1.id into t1t2 from t1 in t1t2.DefaultIfEmpty() select new { t2.month, t2.number, t1.name };
GridView4.DataSource = q1;
GridView4.DataBind();
}
}
/*souce*/
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="TextBox1" runat="server">
</asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
<br />
<br />
<br />
<br />
<asp:GridView ID="GridView1" runat="server">
<%-- <Columns>
<asp:TemplateField>
<HeaderTemplate>
Name</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="lab1" runat="server" Text='<%#Eval("name") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>--%>
</asp:GridView>
<asp:GridView ID="GridView2" runat="server">
</asp:GridView>
<asp:GridView ID="GridView3" runat="server">
</asp:GridView>
<asp:GridView ID="GridView4" runat="server">
</asp:GridView>
</div>
</form>
</body>
</html>
No comments:
Post a Comment