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

LINQ Find Minimum value using ASP.NET C#

Dear viewer I will show how to get Minimum value using LINQ in ASP.NET C#. I have shown a very simple example to get Minimum 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 lowest number for each subject using LINQ Min() Method.

Find Minimum Value in LINQ


<html xmlns="">
<head id="Head1" runat="server">
  <title> LINQ Min Value</title>
  <style type="text/css">
  color: red;
  <form id="form1" runat="server">
  <table width="100%">
  <h2 class="style4">
  LINQ Find Minimum Value </h2>
  <asp:GridView ID="gvMin" runat="server" AutoGenerateColumns="False"
  CellPadding="3" GridLines="Horizontal" Width="40%" BackColor="White"
  BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px">
  <AlternatingRowStyle BackColor="#F7F7F7" />
  <asp:BoundField DataField="StudentName" HeaderText="StduentName" ItemStyle-HorizontalAlign="Center">
  <ItemStyle HorizontalAlign="Center" />
  <asp:BoundField DataField="MinNumber" HeaderText="Minimum Number" ItemStyle-HorizontalAlign="Center">
  <ItemStyle HorizontalAlign="Center" />
  <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
   <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
  <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
  <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
  <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
  <SortedAscendingCellStyle BackColor="#F4F4FD" />
  <SortedAscendingHeaderStyle BackColor="#5A4C9D" />
  <SortedDescendingCellStyle BackColor="#D8D8F0" />
  <SortedDescendingHeaderStyle BackColor="#3E3277" />


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class LinqMin : 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,
  MinNumber = g.Min(i => i.m.ObtainNumber),
  gvMin.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 =54},
  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