使用linq查询在gridview中显示字段 [英] show fields in gridview using linq query

问题描述

嗨！

我有两张桌子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屋！