使用linq查询在gridview中显示字段 [英] show fields in gridview using linq query
本文介绍了使用linq查询在gridview中显示字段的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨!
我有两张桌子1.city 2.training
1.city有字段a。 cityid(PK)b)city_name
2.培训有字段a。 trainingid(pk)b)training_name c)cityid
我想用以下字段显示网格视图。
1. training_name 2. city_name
请告诉显示上述字段的asp.net的linq查询。
解决方案
var q = 来自 n in dataContext.city
join m in dataContext.training on
n.cityid等于m.cityid
选择 新 {
n.city_name,
m.training_name
};
GridView1.DataSource = q.ToList();
GridView1.DataBind();
使用 System.Collections.Generic;
使用 System.Linq;
class program
{
static void Main( string [] args)
{
List< city> lstCity = new 列表< city>();
列表< training> lstTraining = new List< training>();
lstCity.Add( new City(){cityid = 1 ,city_name = tamilnadu});
lstCity.Add( new City(){cityid = 2 ,city_name = karanataka});
lstTraining.Add( new Training(){training_name = c#,cityid = 1 });
lstTraining.Add( new Training(){training_name = java,cityid = 1 });
var data = lstTraining.Join(lstCity,(k = > k.cityid),(k = > k.cityid),(t,c)= > ; new {t,c})。选择(k = > new
{
TraingName = kttraining_name,
CityName = kccity_name
})。ToList();
}
}
public class City
{
public int cityid {获得跨度>; set ; }
public string city_name { get 跨度>; set ; }
}
public class 培训
{
public int trainingid { get ; set ; }
public string training_name { get 跨度>; set ; }
public int cityid { get 跨度>; set ; }
} < / training > < / 培训 > < / city > < / city > 跨度>
Hi!
i have two tables 1.city 2.training
1.city have the fields a. cityid(PK) b)city_name
2. training have the fields a. trainingid(pk) b)training_name c)cityid
i want to show grid view with the following fields.
1. training_name 2. city_name
please tell the linq query for asp.net that show the above fields.
解决方案
var q = from n in dataContext.city join m in dataContext.training on n.cityid equals m.cityid select new{ n.city_name, m.training_name }; GridView1.DataSource=q.ToList(); GridView1.DataBind();
using System.Collections.Generic; using System.Linq; class program { static void Main(string[] args) { List<city> lstCity = new List<city>(); List<training> lstTraining = new List<training>(); lstCity.Add(new City() { cityid = 1, city_name = "tamilnadu" }); lstCity.Add(new City() { cityid = 2, city_name = "karanataka" }); lstTraining.Add(new Training() { training_name = "c#", cityid = 1 }); lstTraining.Add(new Training() { training_name = "java", cityid = 1 }); var data = lstTraining.Join(lstCity, (k => k.cityid), (k => k.cityid), (t, c) => new { t, c }).Select(k => new { TraingName = k.t.training_name, CityName = k.c.city_name }).ToList(); } } public class City { public int cityid { get; set; } public string city_name { get; set; } } public class Training { public int trainingid { get; set; } public string training_name { get; set; } public int cityid { get; set; } }</training></training></city></city>
这篇关于使用linq查询在gridview中显示字段的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文