Saturday, 23 August 2014

How to Drag Drop Grid View Rows In ASP.NET.


Objective:-Write a Programme In ASP.NET to Drag Drop Grid View Rows using jQuery.

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 id="Head1" runat="server">
  5.     <title>Drag And Drop GridView Rows Demo</title>
  6.     <style type="text/css">
  7.     body
  8.     {
  9.         font-family: Arial;
  10.         font-size : 10pt;
  11.     }
  12.     .myDragClass
  13.     {
  14.         font-family: Arial;
  15.         font-size : 18pt;
  16.         color : Red !important;
  17.         background-color : yellow !important;
  18.     }
  19.     </style>
  20.     <script type="text/javascript" src="Script/jquery-1.7.1.min.js" ></script>
  21.     <script type="text/javascript" src="Script/jquery.tablednd.0.6.min.js" ></script>
  22.     
  23.     <script type="text/javascript" language="javascript">
  24.     $(document).ready(function() {
  25.         $("#<%=gdRows.ClientID%>").tableDnD({
  26.             onDragClass: "myDragClass"
  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="#CC9966" BorderStyle="Solid" BorderWidth="1px" CellPadding="4" Font-Names="Arial" Font-Size="Small">
  38.             <RowStyle BackColor="White" ForeColor="#330099" />
  39.             <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
  40.             <PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
  41.             <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
  42.             <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
  43.         </asp:GridView>
  44.         <br /><br />
  45.         <asp:Button ID="btnReset" Text="Reset" runat="server" OnClick="btnReset_Click" />
  46.     </div>
  47.     </form>
  48. </body>
  49. </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();

  103.     }

  105.     protected void btnReset_Click(object sender, EventArgs e)
  106.     {
  107.         BindGrid();
  108.     }
  109. }


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)