Posted by : Anwar Hossain
Category : How to use LINQ in ASP.NET C#

LINQ Find Max value example using ASP.NET C#

Dear viewer I will show how to get maximum value using LINQ in ASP.NET C#. I have shown a very simple example to get Max Value from list. I have created a two classes one student and another studentMark to provide temporary data to grid view .In this case student and studentMark class has a parent and child class relationship to each other. Hear I will find Max number for each subject using LINQ Max() Method.

Find Max value in LINQ


<html xmlns="">
<head id="Head1" runat="server">
  <title> LINQ Find Max Value</title>
  <style type="text/css">
  color: red;
  <form id="form1" runat="server">
  <table width="100%">
  <h2 class="style4">
  LINQ Find Max Value</h2>
  <asp:GridView ID="gvMax" runat="server" AutoGenerateColumns="False" CellPadding="4"
  ForeColor="#333333" GridLines="None" Width="40%">
  <AlternatingRowStyle BackColor="White" />
  <asp:BoundField DataField="StudentName" HeaderText="StduentName" ItemStyle-HorizontalAlign="Center">
  <ItemStyle HorizontalAlign="Center" />
  <asp:BoundField DataField="MaxNumber" HeaderText="Max Number" ItemStyle-HorizontalAlign="Center">
  <ItemStyle HorizontalAlign="Center" />
  <EditRowStyle BackColor="#7C6F57" />
  <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
  <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
  <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
  <RowStyle BackColor="#E3EAEB" />
  <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
   <SortedAscendingCellStyle BackColor="#F8FAFA" />
  <SortedAscendingHeaderStyle BackColor="#246B61" />
  <SortedDescendingCellStyle BackColor="#D4DFE1" />
  <SortedDescendingHeaderStyle BackColor="#15524A" />

Generate Odd number in c#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class LinqMax : System.Web.UI.Page
  private void Page_Load(object sender, EventArgs e)
  if (!IsPostBack)
  var data = from s in GetStudentList()
  join m in GetStudentMarkList() on s.ID equals m.StduentID
  group new { m, s } by new
  } into g
  select new
  StudentName = g.Key.StduentName,
  MaxNumber = g.Max(i => i.m.ObtainNumber),
  gvMax.DataSource = data;
  private List<Student> GetStudentList()
  List<Student> StudentList = new List<Student>
  new Student{ID=1, StduentName="Ashikur Rahman"},
  new Student{ID=2, StduentName="Roman Mozomder"},
  new Student{ID=3, StduentName="Iqbal Hossain"},
  return StudentList;
  private List<StudentMark> GetStudentMarkList()
  List<StudentMark> StudentMarkStudentMarks = new List<StudentMark>{
  new StudentMark{StduentID=1, Subject="English", ObtainNumber =88},
  new StudentMark{StduentID=1, Subject="Math", ObtainNumber =95},
  new StudentMark{StduentID=1, Subject="Accounting", ObtainNumber =65},
  new StudentMark{StduentID=2, Subject="English" , ObtainNumber =75},
  new StudentMark{StduentID=2, Subject="Math" , ObtainNumber =93},
  new StudentMark{StduentID=2, Subject="Accounting" , ObtainNumber =55},
  new StudentMark{StduentID=3, Subject="English" , ObtainNumber =88},
  new StudentMark{StduentID=3, Subject="Math" , ObtainNumber =85},
  new StudentMark{StduentID=3, Subject="Accounting" , ObtainNumber =79}
  return StudentMarkStudentMarks;
  public class StudentMark
  public int StduentID { get; set; }
  public string StduentName { get; set; }
  public string Subject { get; set; }
  public decimal  ObtainNumber { get; set; }
  public class Student
  public int ID { get; set; }
  public string StduentName { get; set; }

Out Put


Realted Article Headline

LINQ Average Example using ASP.NET C#
LINQ Sum Example using ASP.NET C#
LINQ Find Minimum value using ASP.NET C#
LINQ Find Max value example using ASP.NET C#
LINQ Count Row example using ASP.NET C#
LINQ Sorting Example using ASP.NET C#
LINQ Equals Example using ASP.NET C#
LINQ Where condition Example using ASP.NET C#
How to skip row in LINQ using ASP.NET C#
How to select Top row in LINQ using ASP.NET C#
How to use SQL like Operator in LINQ using ASP.NET C#
How to join two collections data using LINQ in ASP.NET C#

Article Category

How to create control dynamically
Learn HTML for beginner
DataList example in C Sharp
Mail sending in c#
State Management in ASP C #
Basic sql tutorial for Beginner
DataTable example in ASP.Net C#
How to use LINQ in ASP.NET C# c # basic tutorial
How to use ajax toolkit in C#
How to use different types of validation control using c#
How to use grid view in c#
Protected by Copyscape Online Plagiarism Detection