linq gridview

最新推荐文章于 2022-06-01 09:47:29 发布

macrohasdefined

最新推荐文章于 2022-06-01 09:47:29 发布

阅读量435

点赞数

分类专栏： Temp

Temp 专栏收录该内容

22 篇文章 0 订阅

订阅专栏

Here I am going to show how you can bind the GridView with Linq.
First let us have a look to our aspx page.
/*.aspx page*/

<%@ 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">

<title>Untitled Page</title>

</head>

<body>

<asp:ScriptManager ID="ScriptManager1" runat="server">

</asp:ScriptManager>

<div>

<tr>

<td>

<asp:Label ID="Label1" runat="server" Text="Region:"></asp:Label>

</td>

<td>

<asp:UpdatePanel ID="UpdatePanel1" runat="server">

<asp:DropDownList ID="ddlregion" runat="server" AutoPostBack="True"

onselectedindexchanged="ddlregion_SelectedIndexChanged">

</asp:DropDownList>

</ContentTemplate>

</asp:UpdatePanel>

</td>

</tr>

<tr>

<td>

</td>

<td>

<asp:UpdatePanel ID="UpdatePanel2" runat="server">

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px"

CellPadding="4" ForeColor="Black" GridLines="Vertical">

<asp:BoundField HeaderText="Name" DataField="name" />

<asp:BoundField HeaderText="Country" DataField="country" />

<asp:BoundField HeaderText="Region" DataField="region"/>

<asp:BoundField HeaderText="City" DataField="city"/>

</Columns>

</asp:GridView>

</ContentTemplate>

</asp:UpdatePanel>

<asp:UpdateProgress ID="UpdateProgress1" runat="server">

</ProgressTemplate>

</asp:UpdateProgress>

</td>

</tr>

</table>

</div>

</form>

</body>
</html>
The code behind to fetch the records through linq and bind it to the GridView.
/*.cs file for Bind Gridview*/

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class Default2 : System.Web.UI.Page

{

connect connect = new connect(); // Connection class contain connection string.

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

Bindregiondata();

}

private void Bindregiondata()

{

using (SqlConnection con = new SqlConnection(connect.Getconnection()))

{

con.Open();

testLINQinfoDataContext db = new testLINQinfoDataContext();

var regioninfo = from p in db.REGIONs

orderby p.regionname

select new

{

regionid = p.regionid,

regionname = p.regionname

};

ddlregion.DataSource = regioninfo;

ddlregion.DataTextField = "regionname";

ddlregion.DataValueField = "regionid";

ddlregion.DataBind();

ddlregion.Items.Insert(0, "--Select Regioname--");

}

protected void ddlregion_SelectedIndexChanged(object sender, EventArgs e)

{

using (SqlConnection con = new SqlConnection(connect.Getconnection()))

{

testLINQinfoDataContext db = new testLINQinfoDataContext();

var employeeinfo = from p in db.EMPLOYEEINFOs

join c in db.COUNTRies

on p.countryid equals c.countryid

join r in db.REGIONs

on p.regionid equals r.regionid

join d in db.CITies

on p.cityid equals d.cityid

where p.regionid == Convert.ToInt32(ddlregion.SelectedItem.Value)

select new

{

name = p.empname,

country = c.countryname,

region = r.regionname,

city = d.cityname

};

GridView1.DataSource = employeeinfo;

GridView1.DataBind();

}

macrohasdefined

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
linq gridview

Here I am going to show how you can bind the GridView with Linq. First let us have a look to our aspx page. /*.aspx page*/@Page Language="C#"AutoEventWireup="true"CodeFile="Default2.aspx.c
复制链接

扫一扫

专栏目录