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

LINQ Where condition Example using ASP.NET C#

Dear viewers I will show how to where Condition Example LINQ. I have shown a very simple example to search row from a list using where condition in LINQ. After creating a collection of student list a textbox and a submit button has been taken to search student result where marks above 40.

Where Condition Example LINQ

HTML

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
  <title></title>
  <style type="text/css">
  .style1
  {
  color: #336600;
  }
  .style4
  {
  color: #99CC00;
  }
  </style>
</head>
<body>
  <form id="form1" runat="server">
  <div>
  <div>
  <table width="100%">
  <tr>
  <td colspan="3">
  <h2 class="style4">
  LINQ Where Condition Example</h2>
  </td>
  </tr>
   <tr>
  <td width="260" class="style1">
  <strong>Enter Marks above 40 </strong>
  </td>
  <td width="10">
  </td>
  <td>
  <asp:TextBox ID="txtContactsSearch" runat="server"></asp:TextBox>
  <asp:Button ID="btnSubmit" runat="server" Text="Search" OnClick="btnSubmit_Click" />
  </td>
  </tr>
   <tr>
  <td width="260">
  &nbsp;
  </td>
  <td width="10">
  &nbsp;
  </td>
  <td>
  &nbsp;
  </td>
  </tr>
  <tr>
  <td colspan="3">
  <asp:GridView ID="gvLikeOperator" runat="server" AutoGenerateColumns="False" CellPadding="4"
  ForeColor="#333333" GridLines="None" Width="40%">
  <AlternatingRowStyle BackColor="White" />
  <Columns>
  <asp:BoundField DataField="StudentName" HeaderText="Student Name" ItemStyle-HorizontalAlign="Center">
  <ItemStyle HorizontalAlign="Center" />
  </asp:BoundField>
  <asp:BoundField DataField="Number" HeaderText="Marks" ItemStyle-HorizontalAlign="Center">
  <ItemStyle HorizontalAlign="Center" />
  </asp:BoundField>
  </Columns>
  <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" />
  </asp:GridView>
  </td>
  </tr>
  </table>
  </div>
  </div>
  </form>
</body>
</html>
 

CODE BEHIND

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Linq.SqlClient;
 
public partial class LinqWhereExample : System.Web.UI.Page
{
  protected void Page_Load(object sender, EventArgs e)
  {
  if (!IsPostBack)
  {
 
 
  gvLikeOperator.DataSource = GetStudentList();
  gvLikeOperator.DataBind();
  }
  }
  protected void btnSubmit_Click(object sender, EventArgs e)
  {
  if (txtContactsSearch.Text.Trim() != string.Empty)
  {
  var data = (from m in GetStudentList()
  where m.Number <= Convert.ToInt32(txtContactsSearch.Text.Trim())
  select m);
 
  gvLikeOperator.DataSource = data;
  gvLikeOperator.DataBind();
 
 
  }
  }
 
 
  private List<Student> GetStudentList()
  {
 
  List<Student> StudentStudents = new List<Student>{
  new Student{StudentID=1,  StudentName="Amin", Number =55},
  new Student{StudentID=2,  StudentName="Alomgir" , Number =55},
  new Student{StudentID=3,  StudentName="Ashikur Rahman", Number =65},
  new Student{StudentID=4,  StudentName="Shamim Ahmed" , Number =55},
  new Student{StudentID=5,  StudentName="Amolash" , Number =95},
  new Student{StudentID=6,  StudentName="Alum" , Number =95},
  new Student{StudentID=7,  StudentName="Abil", Number =75},
   new Student{StudentID=8,  StudentName="Enamul", Number =95},
  new Student{StudentID=9,  StudentName="Nahid", Number =95},
  new Student{StudentID=10,  StudentName="Asraf", Number =95},
  new Student{StudentID=11,  StudentName="Asfaq", Number =85},
  new Student{StudentID=12,  StudentName="kbil", Number =95},
  new Student{StudentID=13,  StudentName="Masum", Number =95},
  new Student{StudentID=14,  StudentName="Nasid", Number =45},
   new Student{StudentID=15,  StudentName="Babu", Number =75},
  new Student{StudentID=16,  StudentName="Titu", Number =85}
  };
 
  return StudentStudents;
 
  }
 
  public class Student
  {
  public int StudentID { get; set; }
  public string StudentName { get; set; }
  public  int  Number{ get; set; }
  }
}
 

Out Put

Linq-Where-condition-examlpe



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 asp.net control dynamically
Learn HTML for beginner
DataList example in C Sharp
Mail sending in asp.net 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#
asp.net c # basic tutorial
How to use ajax toolkit in asp.net C#
How to use different types of validation control using asp.net c#
How to use grid view in asp.net c#
Protected by Copyscape Online Plagiarism Detection