Sunday, 3 August 2014

How to Get GridView Cell Data In ASP.NET.



Objective:-Create a Program in ASP.NET to Get GridView Cell Data in A simple Label..........

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>Get GridView Cell Data</title>
  5.     <style type="text/css">
  6.     body
  7.     {
  8.         font-family: Arial;
  9.         font-size : 10pt;
  10.     }
  11.     .selected
  12.     {
  13.         background-color: Yellow;
  14.         color : Green;
  15.     }
  16.     </style>

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

  20.     <script type="text/javascript" language="javascript">
  21.     $(document).ready(function() {
  22.         $("#<%=gdRows.ClientID%> tr:has(td)").hover(function(e) {
  23.             $(this).css("cursor", "pointer");
  24.         });    

  26.         $("#<%=gdRows.ClientID%> tr:has(td)").click(function(e) {
  27.             var selTD = $(e.target).closest("td");
  28.             $("#<%=gdRows.ClientID%> td").removeClass("selected");
  29.             selTD.addClass("selected");
  30.             $("#<%=lblSelected.ClientID%>").html('Selected Cell Value is: <b> ' + selTD.text() + '</b>');
  31.         });
  32.     })
  33.     </script>

  35. </head>
  36. <body>
  37.     <form id="form1" runat="server">
  38.         <div>
  39.             <asp:GridView ID="gdRows" runat="server" BackColor="White" BorderColor="#3366CC"
  40.                 BorderWidth="1px" CellPadding="4" Font-Names="Arial" Font-Size="Small" Width="36%"
  41.                 BorderStyle="None">
  42.                 <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
  43.                 <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
  44.                 <SelectedRowStyle BackColor="#009999" ForeColor="#CCFF99" Font-Bold="True" />
  45.                 <HeaderStyle BackColor="#003399" Font-Bold="True" HorizontalAlign="Left" ForeColor="#CCCCFF" />
  46.                 <RowStyle HorizontalAlign="Left" BackColor="White" ForeColor="#003399" />
  47.             </asp:GridView>
  48.             <br />
  49.             <br />
  50.             <asp:Label id="lblSelected" runat="server"></asp:Label>
  51.         </div>
  52.     </form>
  53. </body>
  54. </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)