Sunday, 4 May 2014

Use of Search Data from GridView In ASP.NET.



Objective:-Use of Search Data from GridView In ASP.NET.

STEPS :-
STEP:- 1  CREATE NEW PROJECT.
Go to File -> New -> Project -> Select asp.net web forms application -> Entry Application Name -> Click OK.
STEP:-2 Attach  "jquery-1.7.1.min" file in Scripts Folder




********HTML Code***************
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  2. <html xmlns="http://www.w3.org/1999/xhtml">
  3. <head runat="server">
  4.     <title>Search GridView Data</title>
  5.     <style type="text/css">
  6.     body
  7.     {
  8.         font-family: Arial;
  9.         font-size : 10pt;
  10.     }
  11.     .links
  12.     {
  13.         font-weight: bold;
  14.     }
  15.     </style>

  17.     <script type="text/javascript" src="Scripts/jquery-1.7.1.min.js"></script>

  19.     <script type="text/javascript" language="javascript">
  20.     $(document).ready(function() {
  21.         $('#<%=lblNoRecords.ClientID%>').css('display','none');
  22.         
  23.         $('#<%=btnSubmit.ClientID%>').click(function(e)
  24.         {
  25.             $('#<%=lblNoRecords.ClientID%>').css('display','none'); // Hide No records to display label.
  26.             $("#<%=gdRows.ClientID%> tr:has(td)").hide(); // Hide all the rows.
  27.             
  28.             var iCounter = 0;
  29.             var sSearchTerm = $('#<%=txtSearch.ClientID%>').val(); //Get the search box value
  30.             
  31.             if(sSearchTerm.length == 0) //if nothing is entered then show all the rows.
  32.             {
  33.               $("#<%=gdRows.ClientID%> tr:has(td)").show(); 
  34.               return false;
  35.             }
  36.             //Iterate through all the td.
  37.             $("#<%=gdRows.ClientID%> tr:has(td)").children().each(function() 
  38.             {
  39.                 var cellText = $(this).text().toLowerCase();
  40.                 if(cellText.indexOf(sSearchTerm.toLowerCase()) >= 0) //Check if data matches
  41.                 {    
  42.                     $(this).parent().show();
  43.                     iCounter++;
  44.                     return true;
  45.                 } 
  46.             });
  47.             if(iCounter == 0)
  48.             {
  49.                 $('#<%=lblNoRecords.ClientID%>').css('display','');
  50.             }
  51.             e.preventDefault();
  52.         })
  53.     })
  54.     </script>

  56. </head>
  57. <body>
  58.     <form id="form1" runat="server">
  59.         <br />
  60.         <br />
  61.         Search Text :
  62.         <asp:TextBox ID="txtSearch" runat="server"></asp:TextBox>
  63.         &nbsp;
  64.         <asp:Button ID="btnSubmit" runat="server" Text="Search" />
  65.         <br /><br />
  66.         <asp:GridView ID="gdRows" runat="server" BackColor="LightGoldenrodYellow" BorderColor="Tan"
  67.             BorderWidth="1px" CellPadding="6" Font-Names="Arial" Font-Size="Small" GridLines="None"
  68.             ForeColor="Black" Width="36%">
  69.             <FooterStyle BackColor="Tan" />
  70.             <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />
  71.             <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
  72.             <HeaderStyle BackColor="Tan" Font-Bold="True" HorizontalAlign="Left" />
  73.             <AlternatingRowStyle BackColor="PaleGoldenrod" />
  74.             <RowStyle HorizontalAlign="Left" />
  75.         </asp:GridView>
  76.         <asp:Label ID="lblNoRecords" Text="No records to display" runat="server" ForeColor="red"></asp:Label>
  77.     </form>
  78. </body>
  79. </html>


********C# Code***************
  1. using System;
  2. using System.Data;
  3. using System.Configuration;
  4. using System.Web;
  5. using System.Web.Security;
  6. using System.Web.UI;
  7. using System.Web.UI.WebControls;
  8. using System.Web.UI.WebControls.WebParts;
  9. using System.Web.UI.HtmlControls;

  11. public partial class _Default : System.Web.UI.Page 
  12. {
  13.     protected void Page_Load(object sender, EventArgs e)
  14.     {
  15.         if (!IsPostBack)
  16.             BindGrid();
  17.     }

  19.     private void BindGrid()
  20.     {
  21.         DataTable dt = new DataTable();
  22.         DataColumn dc;
  23.         dc = new DataColumn();
  24.         dc.ColumnName = "ID";
  25.         dc.DataType = System.Type.GetType("System.Int32");
  26.         dt.Columns.Add(dc);

  28.         dc = new DataColumn();
  29.         dc.ColumnName = "ProductName";
  30.         dt.Columns.Add(dc);

  32.         dc = new DataColumn();
  33.         dc.ColumnName = "Quantity";
  34.         dc.DataType = System.Type.GetType("System.Int32");
  35.         dt.Columns.Add(dc);

  37.         dc = new DataColumn();
  38.         dc.ColumnName = "Price";
  39.         dc.DataType = System.Type.GetType("System.Int32");
  40.         dt.Columns.Add(dc);


  43.         DataRow dr;
  44.         dr = dt.NewRow();
  45.         dr["ID"] = 1;
  46.         dr["ProductName"] = "Mouse";
  47.         dr["Quantity"] = 10;
  48.         dr["Price"] = 100;
  49.         dt.Rows.Add(dr);

  51.         dr = dt.NewRow();
  52.         dr["ID"] = 2;
  53.         dr["ProductName"] = "Speaker";
  54.         dr["Quantity"] = 15;
  55.         dr["Price"] = 990;
  56.         dt.Rows.Add(dr);

  58.         dr = dt.NewRow();
  59.         dr["ID"] = 3;
  60.         dr["ProductName"] = "Hard Drive";
  61.         dr["Quantity"] = 35;
  62.         dr["Price"] = 3990;
  63.         dt.Rows.Add(dr);

  65.         dr = dt.NewRow();
  66.         dr["ID"] = 4;
  67.         dr["ProductName"] = "RAM";
  68.         dr["Quantity"] = 22;
  69.         dr["Price"] = 399;
  70.         dt.Rows.Add(dr);

  72.         dr = dt.NewRow();
  73.         dr["ID"] = 5;
  74.         dr["ProductName"] = "Wireless Keyboard";
  75.         dr["Quantity"] = 10;
  76.         dr["Price"] = 3500;
  77.         dt.Rows.Add(dr);

  79.         dr = dt.NewRow();
  80.         dr["ID"] = 6;
  81.         dr["ProductName"] = "Wi-Fi Router";
  82.         dr["Quantity"] = 1;
  83.         dr["Price"] = 3990;
  84.         dt.Rows.Add(dr);

  86.         dr = dt.NewRow();
  87.         dr["ID"] = 7;
  88.         dr["ProductName"] = "LCD";
  89.         dr["Quantity"] = 62;
  90.         dr["Price"] = 3000;
  91.         dt.Rows.Add(dr);

  93.         dr = dt.NewRow();
  94.         dr["ID"] = 8;
  95.         dr["ProductName"] = "Intel Processor";
  96.         dr["Quantity"] = 5;
  97.         dr["Price"] = 7000;
  98.         dt.Rows.Add(dr);

  100.         dr = dt.NewRow();
  101.         dr["ID"] = 9;
  102.         dr["ProductName"] = "Monitor";
  103.         dr["Quantity"] = 25;
  104.         dr["Price"] = 1990;
  105.         dt.Rows.Add(dr);

  107.         dr = dt.NewRow();
  108.         dr["ID"] = 10;
  109.         dr["ProductName"] = "Keyboard";
  110.         dr["Quantity"] = 20;
  111.         dr["Price"] = 350;
  112.         dt.Rows.Add(dr);

  114.         dr = dt.NewRow();
  115.         dr["ID"] = 11;
  116.         dr["ProductName"] = "headphones";
  117.         dr["Quantity"] = 12;
  118.         dr["Price"] = 500;
  119.         dt.Rows.Add(dr);

  121.         gdRows.DataSource = dt;
  122.         gdRows.DataBind();

  124.     }
  125. }


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)