Oct 06

How To add Alphabet Paging in GridView

asp.net No Comments »


<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AlphabetPaging.aspx.cs" Inherits="AlphabetPaging" %>

<!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 runat="server">
  <title>Untitled Page</title>
</head>
<body>
  <form id="form1" runat="server">
      <div>
          <asp:GridView ID="GridView1" runat="server" ShowFooter="True" OnRowCreated="GridView1_RowCreated"
               OnRowCommand="GridView1_RowCommand">
          </asp:GridView>
      </div>
  </form>
</body>
</html>



<br />.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: Consolas, "Courier New", Courier, Monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br /><br />.csharpcode pre { margin: 0em; }<br /><br />.csharpcode .rem { color: #008000; }<br /><br />.csharpcode .kwrd { color: #0000ff; }<br /><br />.csharpcode .str { color: #006080; }<br /><br />.csharpcode .op { color: #0000c0; }<br /><br />.csharpcode .preproc { color: #cc6633; }<br /><br />.csharpcode .asp { background-color: #ffff00; }<br /><br />.csharpcode .html { color: #800000; }<br /><br />.csharpcode .attr { color: #ff0000; }<br /><br />.csharpcode .alt<br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br /><br />.csharpcode .lnum { color: #606060; }<br />

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Web.Script.Serialization;

public partial class AlphabetPaging : System.Web.UI.Page
{
   protected void Page_Load(object sender, EventArgs e)
   {

       if (!IsPostBack)
       {
           if (Session["strTemp"] != null)
           {

               GridView1.DataSource = Session["strTemp"] as DataTable;

               GridView1.DataBind();

           }
           else
           {
               GridView1.DataSource = GetCustomMadeDataTable();
               GridView1.DataBind();
           }
       }

   }
   public DataTable GetCustomMadeDataTable()
   {

       //Create a new DataTable object
       System.Data.DataTable objDataTable = new System.Data.DataTable();
       //Create three columns with string as their type
       objDataTable.Columns.Add("Id", typeof(string));
       objDataTable.Columns.Add("Column1", typeof(string));
       objDataTable.Columns.Add("Column2", typeof(string));
       objDataTable.Columns.Add("Column3", typeof(string));

       //Adding some data in the rows of this DataTable
       DataRow dr;
       for (int i = 65; i <= (65 + 25); i++)
       {

           dr = objDataTable.NewRow();
           dr[0] = i.ToString();
           dr[1] = Char.ConvertFromUtf32(i)+"Column1Data" + i.ToString();
           dr[2] = Char.ConvertFromUtf32(i+1)+"Column2Data" + i.ToString();
           dr[3] = Char.ConvertFromUtf32(i+2)+"Column3Data" + i.ToString();
           objDataTable.Rows.Add(dr);

       }
       DataColumn[] dcPk = new DataColumn[1];
       dcPk[0] = objDataTable.Columns["Id"];
       objDataTable.PrimaryKey = dcPk;
       Session["strTemp"] = objDataTable;

       return objDataTable;
   }
   protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
   {
       if (e.Row.RowType == DataControlRowType.Footer)
       {

           TableCell cell = e.Row.Cells[0];
           cell.ColumnSpan = 2;

           for (int i = 65; i <= (65 + 25); i++)
           {
               LinkButton lb = new LinkButton();

               lb.Text = Char.ConvertFromUtf32(i) + " ";

               lb.CommandArgument = "%" + Char.ConvertFromUtf32(i) + "%";
               lb.CommandName = "AlphaPaging";

               cell.Controls.Add(lb);

           }
       }
   }
   protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
   {
       //At first I check that if the CommandName is “AlphaPaging”
       if (e.CommandName.Equals("AlphaPaging"))
       {

           GridView1.DataSource = GetById(e.CommandArgument.ToString());
           GridView1.DataBind();
       }
   }

   public DataView GetById(string id)
   {

       //Fetch record from database using like operator.
       DataTable dt = new DataTable();
       dt = Session["strTemp"] as DataTable;
       DataView dv = dt.DefaultView;

       dv.RowFilter = "Column1 LIKE '" + id + "'";
       return dv;

   }
}
Oct 06

How To add Vertical Scroll in GridView and maintain Div’s Scroll Position

asp.net No Comments »
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridViewPostion.aspx.cs" Inherits="GridViewPostion" %>

<!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 runat="server">
   <title>Untitled Page</title>
  <style type="text/css">
     #divTest{width:500px;height:200px;overflow:auto}
   </style>
   <script type="text/javascript">
     window.onload = function(){
       var strCook = document.cookie;
       if(strCook.indexOf("!~")!=0){
         var intS = strCook.indexOf("!~");
         var intE = strCook.indexOf("~!");
         var strPos = strCook.substring(intS+2,intE);
         document.getElementById("divTest").scrollTop = strPos;
       }
     }
     function SetDivPosition(){
       var intY = document.getElementById("divTest").scrollTop;
       document.title = intY;
       document.cookie = "yPos=!~" + intY + "~!";
     }
   </script>
</head>
<body>
   <form id="form1" runat="server">
   <div id="divTest" onscroll="SetDivPosition()">
  <asp:GridView ID="GridView1" runat="server"></asp:GridView>

   </div>
   </form>
</body>
</html>


<br />.csharpcode, .csharpcode pre<br />{<br /> font-size: small;<br /> color: black;<br /> font-family: Consolas, "Courier New", Courier, Monospace;<br /> background-color: #ffffff;<br /> /*white-space: pre;*/<br />}<br /><br />.csharpcode pre { margin: 0em; }<br /><br />.csharpcode .rem { color: #008000; }<br /><br />.csharpcode .kwrd { color: #0000ff; }<br /><br />.csharpcode .str { color: #006080; }<br /><br />.csharpcode .op { color: #0000c0; }<br /><br />.csharpcode .preproc { color: #cc6633; }<br /><br />.csharpcode .asp { background-color: #ffff00; }<br /><br />.csharpcode .html { color: #800000; }<br /><br />.csharpcode .attr { color: #ff0000; }<br /><br />.csharpcode .alt<br />{<br /> background-color: #f4f4f4;<br /> width: 100%;<br /> margin: 0em;<br />}<br /><br />.csharpcode .lnum { color: #606060; }<br />

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class GridViewPostion : System.Web.UI.Page
{
   protected void Page_Load(object sender, EventArgs e)
   {
       if (!IsPostBack)
       {
           if (Session["strTemp"] != null)
           {

               GridView1.DataSource = Session["strTemp"] as DataTable;

               GridView1.DataBind();

           }
           else
           {
               GridView1.DataSource = GetCustomMadeDataTable();

               GridView1.DataBind();
           }
       }

   }
   public DataTable GetCustomMadeDataTable()
   {

       //Create a new DataTable object

       System.Data.DataTable objDataTable = new System.Data.DataTable();

       //Create three columns with string as their type

       objDataTable.Columns.Add("Id", typeof(string));
       objDataTable.Columns.Add("Column1", typeof(string));
       objDataTable.Columns.Add("Column2", typeof(string));
       objDataTable.Columns.Add("Column3", typeof(string));

       //Adding some data in the rows of this DataTable
       DataRow dr;
       for (int i = 0; i <= 20; i++)
       {
           dr = objDataTable.NewRow();
           dr[0] = i.ToString();
           dr[1] = "Column1Data" + i.ToString();
           dr[2] = "Column2Data" + i.ToString();
           dr[3] = "Column3Data" + i.ToString();
           objDataTable.Rows.Add(dr);
       }
       DataColumn[] dcPk = new DataColumn[1];
       dcPk[0] = objDataTable.Columns["Id"];
       objDataTable.PrimaryKey = dcPk;
       Session["strTemp"] = objDataTable; return objDataTable;
   }
}
Oct 06

How To Set The Column Width Of a GridView

asp.net No Comments »

You don’t see any “width” property in the columns collection,you can set the width of GridView column in code behind.

protected void Page_Load(object sender, EventArgs e)
{

GridView1.Columns[0].ItemStyle.Width = 500;
}

Oct 06

How To Hide GridView column using javascript

asp.net No Comments »
<%@ Page Language="C#" AutoEventWireup="true"
CodeFile="HideColumnGridview.aspx.cs"
 Inherits="HideColumnGridview" %>

<!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">

 <script language="JavaScript">
function hideColumn()
{
col_num = document.getElementById("column_numbder").value;
rows = document.getElementById("GridView1").rows;
for(i=0;i <rows.length;i++)
{
 rows[i].cells[col_num].style.display="none";
}
}
 </script>

 <title>Untitled Page</title>
</head>
<body>
 <form id="form1" runat="server">
     <div>
         <asp:GridView ID="GridView1" runat="server">
         </asp:GridView>
     </div>
     <input id="column_numbder" type="text">
     <input type="button" value="Hide" onclick="hideColumn()">
 </form>
</body>
</html>



using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class HideColumnGridview : System.Web.UI.Page
{
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         if (Session["strTemp"] != null)
         {

             GridView1.DataSource = Session["strTemp"] as DataTable;

             GridView1.DataBind();

         }
         else
         {
             GridView1.DataSource = GetCustomMadeDataTable();

             GridView1.DataBind();
         }
     }

 }
 public DataTable GetCustomMadeDataTable()
 {

     //Create a new DataTable object

     System.Data.DataTable objDataTable = new System.Data.DataTable();

     //Create three columns with string as their type

     objDataTable.Columns.Add("Id", typeof(string));
     objDataTable.Columns.Add("Column1", typeof(string));
     objDataTable.Columns.Add("Column2", typeof(string));
     objDataTable.Columns.Add("Column3", typeof(string));

     //Adding some data in the rows of this DataTable
     DataRow dr;
     for (int i = 0; i <= 20; i++)
     {
         dr = objDataTable.NewRow();
         dr[0] = i.ToString();
         dr[1] = "Column1Data" + i.ToString();
         dr[2] = "Column2Data" + i.ToString();
         dr[3] = "Column3Data" + i.ToString();
         objDataTable.Rows.Add(dr);
     } DataColumn[] dcPk = new DataColumn[1];
     dcPk[0] = objDataTable.Columns["Id"];
     objDataTable.PrimaryKey = dcPk;
     Session["strTemp"] = objDataTable;
     return objDataTable;
 }
}