Sunday, 27 April 2014

How to Remove GridView Columns In ASP.NET.


Objective:-How to Remove GridView Columns 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">

  3. <html xmlns="http://www.w3.org/1999/xhtml" >
  4. <head runat="server">
  5.     <title>Remove Column From GridView Demo</title>
  6.     <style type="text/css">
  7.     body
  8.     {
  9.     font-family: Arial;
  10.     font-size : 10pt;
  11.     }
  12.     </style>
  13.     <script type="text/javascript" src="Script/jquery-1.7.1.min.js" ></script>
  14.     
  15.     <script type="text/javascript" language="javascript">
  16.     $(document).ready(function() {
  17.      $("#<%=gdRows.ClientID%> th").click(function() {
  18.        var iIndex = $(this).closest("th").prevAll("th").length;
  19.        $(this).parents("#<%=gdRows.ClientID%>").find("tr").each(function() {
  20.           $(this).find("td:eq(" + iIndex + ")").remove();
  21.           $(this).find("th:eq(" + iIndex + ")").remove();
  22.        });
  23.     });
  24.     
  25.     $("#<%=gdRows.ClientID%> th").mouseover(function() {
  26.         $(this).css('cursor','pointer');
  27.     });
  28. });
  29.     </script>
  30. </head>
  31. <body>
  32.     <form id="form1" runat="server">
  33.     <div>
  34.         <b>Click on the column to remove the column.</b>
  35.         <br />
  36.         <br />
  37.         <asp:GridView ID="gdRows" runat="server" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" Font-Names="Arial" Font-Size="Small" GridLines="Vertical">
  38.             <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
  39.             <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
  40.             <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
  41.             <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
  42.             <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
  43.             <AlternatingRowStyle BackColor="#DCDCDC" />
  44.         </asp:GridView>
  45.         <br /><br />
  46.         <asp:Button ID="btnReset" Text="Reset" runat="server" OnClick="btnReset_Click" />
  47.     </div>
  48.     </form>
  49. </body>
  50. </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"] = "Keyboard";
  75.         dr["Quantity"] = 20;
  76.         dr["Price"] = 350;
  77.         dt.Rows.Add(dr);

  79.         dr = dt.NewRow();
  80.         dr["ID"] = 6;
  81.         dr["ProductName"] = "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"] = "Processor";
  96.         dr["Quantity"] = 5;
  97.         dr["Price"] = 7000;
  98.         dt.Rows.Add(dr);

  100.         gdRows.DataSource = dt;
  101.         gdRows.DataBind();
  102.         
  103.     }
  104.     protected void btnReset_Click(object sender, EventArgs e)
  105.     {
  106.         BindGrid();
  107.     }
  108. }


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)