Asp.Net GridView useful tips and tricks

Asp.Net GridView useful tips and tricks

OUTSIDE GRIDVIEW CODE BEHIND

//Filtering only just DataRow inside GridView RowDataBound (i.e. Excluding Header, Footer and Pager)
if (e.Row.RowType == DataControlRowType.DataRow)
{
//Finding Control inside the GridViewRow
 Button b = ((Button)e.Row.FindControl("MyButtonID"));

//Get Data Item field (Might need to validate as your own)
string CustomerID = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "CustomerID"));
} 

//Get GridViewRow in the button click of GridView ItemTemplate
Method 1) GridViewRow gvr = (GridViewRow)(sender as Button).NamingContainer;
Method 2) GridViewRow gvr = (sender as Button).Parent.Parent as GridViewRow;

//Get Parent's GridViewRow in the button click of Nested GridView ItemTemplate
GridViewRow ParentRow = e.Row.Parent.Parent.Parent.Parent as GridViewRow;

INSIDE GRIDVIEW

//Add auto increase Sr. No. (1,2,3,4.....)
<%#Container.DataItemIndex+1 %>

//Binding Data Item
Text='<%#Eval("CustomerID")%>'

//Binding Multiple Data Items
Text='<%#Eval("Key")+"|"+Eval("Line_No") %>'

//Binding Data Item with Custom Text
Text='<%#"Customer ID is " + Eval("CustomerID")%>'

//Add Codebehind Class property inside the GridView
<%# CodeBehindProperty %>

//Adding HyperLinkField
<asp:HyperLinkField HeaderText="Customer ID" DataTextField="CustomerID" DataNavigateUrlFormatString="CustomerDetail.aspx?c=y&amp;id={0}&amp;name={1}" DataNavigateUrlFields="CustomerID,CustomerName" ControlStyle-CssClass="blulink">

 //Adding HyperLink Control in ItemTemplate

<asp:HyperLink ID="HyperLink1" runat="server"  navigateurl='<%# String.Format("~/GLEntryDetails.aspx?uid={0}&section={1}&des={2}&Field4=something", Eval("UserID"), Eval("Section"), Eval("Description")) %>' Text='<%#Eval("Click Here") %>'></asp:HyperLink>

//BoundField Data Format of Date
<asp:BoundField DataFormatString="{0:dd/MM/yyyy}" />

//Item Template Data Format of Date
<asp:ItemTemplate><asp:Label Text='<%# Bind("Expiry_Date","{0:dd-MM-yyyy}") %>'/></asp:ItemTemplate>

//BoundField Data Format of Currency
Method 1) DataFormatString="{0:#,###.00}"
Method 2) DataFormatString="{0:N2}"
Method 3) DataFormatString="{0:dd/MM/yyyy hh:mm:ss tt}"

Maintaining Cookies Variable in DLL in Asp.Net

I have mentioned about Maintaining Session Variable in DLL in Asp.net in this blog before and this is something similar to that session post.
Let me have a brief explanation of this post.
As we know, we usually see a check box saying remember me or keep logged in most of the web sites log in page.
Thus, we have to play cookie in user's browser with these functions Read, Write, Clear cookies.
Imagine how messy if we create/write/clear cookie inside the code in every time of creating/writing/clearing cookies.
In such case, how if we create CookieHelper class having Read/Write/Clearing only one time.
The example mechanism code snippet of keep me logged in is as below.

namespace MyCookieHouse
{
    public enum COOKIE_NAME
    {
        CK_KEEPLOGIN, // login
        USERINFO_USERID
    }

    [Serializable()]
    public class MyCookieHelper
    {
        public static string USER_ID //login user id OR Shipping Agent Code
        {
            get
            {
                return GetCookieValue(COOKIE_NAME.CK_KEEPLOGIN, COOKIE_NAME.USERINFO_USERID);
            }
            set
            {
                SetCookieValue(COOKIE_NAME.CK_KEEPLOGIN, COOKIE_NAME.USERINFO_USERID, value);
            }
        }
  
        public CurrentCOOKIE()
        {
            //
            // TODO: Add constructor logic here
            //
        }

        public static bool IsKeepLogin()
        {
            HttpCookie ck = System.Web.HttpContext.Current.Request.Cookies[COOKIE_NAME.CK_KEEPLOGIN.ToString()];
            if (ck != null)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        public static void ClearCookie(string CookieName)
        {
            HttpCookie ck = System.Web.HttpContext.Current.Request.Cookies[CookieName];
            if (ck != null)
            {
                ck.Expires = DateTime.Now.AddDays(-1d);
                System.Web.HttpContext.Current.Response.Cookies.Add(ck);
            }
        }

        private static string GetCookieValue(COOKIE_NAME CK_NAME, COOKIE_NAME CK_NAME_KEY)
        {
            HttpCookie ck = System.Web.HttpContext.Current.Request.Cookies[CK_NAME.ToString()];
            if (ck != null)
            {
                return ck[CK_NAME_KEY.ToString()];
            }
            else
            {
                return null;
            }
        }

        private static void SetCookieValue(COOKIE_NAME CK_NAME, COOKIE_NAME CK_NAME_KEY, string COOKIEVALUE)
        {
            HttpCookie ck = System.Web.HttpContext.Current.Request.Cookies[CK_NAME.ToString()];
            if (ck != null)
            {
                ck[CK_NAME_KEY.ToString()] = COOKIEVALUE;
                System.Web.HttpContext.Current.Response.Cookies.Add(ck);
            }
            else
            {
                ck = new HttpCookie(CK_NAME.ToString());
                ck[CK_NAME_KEY.ToString()] = COOKIEVALUE;
                ck.Expires = DateTime.Now.AddYears(5);
                System.Web.HttpContext.Current.Response.Cookies.Add(ck);
            }
        }

    }
}

This is something about sharing knowledge and appreciate your comment if you have some better way.
Million thanks. Enjoy! :)

Select or Deselect all by checkbox in Gridview

By JQuery

<script type="text/javascript">
$(document).ready(function() {

var headerCheckbox = $('#GridView1 > tbody > tr > th > input:checkbox');

headerCheckbox.click(function() {
var headerChecked = $(this).attr('checked');
var rowCheckboxes = $('#GridView1 > tbody > tr > td > input:checkbox');
rowCheckboxes.attr('checked', headerChecked);
});

});
</script>
Go to complete example


By classic javascript 

<script type="text/javascript">
function CheckAllRow(chkBox) {
var gridViewCtlId = '<%=GridView1.ClientID%>';
var grid = document.getElementById(gridViewCtlId);
var gridLength = grid.rows.length;
for (var i = 1; i < gridLength; i++) {
cell = grid.rows[i].cells[1];
for (var j = 0; j < cell.childNodes.length; j++) {
if (cell.childNodes[j].type == 'checkbox') {
cell.childNodes[j].checked = chkBox;
}
}
}
}
</script>
Go to complete example

Calling Web Services from Javascript

This also quite straight simple and I am using Asp.Net. The requirement and the procedures are as stated below.

It might be helpful if compare with Calling Code behind Server function from Javascript.

1. Using Ajax.

2. Add ScriptManager or ToolkitScriptManager
3. And a new Web Services Assuming that returning List<string>.

public class MyWebService : System.Web.Services.WebService
{

[WebMethod]
    public List<string> GetData(string CatID)
    {
        List<string> list = new List<string>();
        if (CatID== "1")
        {
            list.Add("Nokia N95");
            list.Add("Nokia N70");
            list.Add("Nokia 6630");
        }
        else
        {
            list.Add("Dell Laptop");
            list.Add("HP Laptop");
            list.Add("Sony Laptop");
        }
        return list;
    }

}

4. Add javascript function as following.

<script type="text/javascript">
       function CallWS_onclick() {
         var catid = $get('<%= txtCatID.ClientID %>').value;
         MyWebService.GetData(catid , onSuccess, onFailed);
      }
      function onSuccess(result)
      {
          var Result= $get('<%= lblResult.ClientID %>');             
         Result.innerHTML = "";
            
         for(i=0 ; i<result.length ; i++)
         {
            Result.innerHTML += result[i] + "<br />";
         }
      }
      function onFailed(error)
      {
          var Result= $get('<%= lblResult.ClientID %>');
         Result.innerHTML = "Service Error: " + error.get_message();
      }
   </script>
5. Add one input button in design page.

<input id="Button1" type="button" value="Get Products"
      onclick="Button1_onclick(this)" /> 

That's it.

Enjoy Programming ! 
Ref:http://www.ezzylearning.com/tutorial.aspx?tid=3967791&q=calling-web-services-in-client-script-using-asp-net-ajax

Calling Code behind Server function from Javascript

It is quite straight simple and I am using Asp.Net. The requirement and the procedures are as following.
It might be helpful if compare with Calling Web Services from Javascript .
1. Using Ajax
2. Set EnablePageMethods="true" in ScriptManager or ToolkitScriptManager attribute.
3. Code behind method must be public.
4. Apply WebMethod attribute to the codebehind function [System.Web.Services.WebMethod]

[System.Web.Services.WebMethod]

public static string GetContactName(string custid)

{
   //Do Logic staff here
   return "Result";
}
5. Create javascript function
(If javascript is external file, add ref in body tag. Not in head tag.)

function CallMe(custidTextBox,DestTextBox)

 {    

     var ctrl = document.getElementById(src);

     // call server side method

     PageMethods.GetContactName(ctrl.value, CallSuccess, CallFailed, DestTextBox);

 }

 // set the destination textbox value with the ContactName

 function CallSuccess(res, destCtrl)

 {    

     var dest = document.getElementById(destCtrl);

     dest.value = res;

 }

 // alert message on some failure

 function CallFailed(res, destCtrl)

 {

     alert(res.get_message());

 }
6. Attach this javascript to desired control.
<input id="BtnSave" class="button_sub" name='<%# Eval("Document_No") + "|"+ Eval("Line_No")%>' type="button" value="Save" onclick="SaveByMe(this,this)" /> 

That's it.
Enjoy Programming.  

Ref : http://www.dotnetcurry.com/ShowArticle.aspx?ID=109

Gridview Row Mouseover highlight and anchor link

 protected void Gridview_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            Label lblDreceive = ((Label)e.Row.FindControl("lblDateReceive"));
            Label lblDissue = ((Label)e.Row.FindControl("lblDateIssue"));

            object d1 = DataBinder.Eval(e.Row.DataItem, "Posted_Purch_Receipt_Date");
            object d2 = DataBinder.Eval(e.Row.DataItem, "Sales_Shipment_Date");
            if (d1 != null)
            {
                DateTime dReceive = DateTime.Parse(d1.ToString());
                lblDreceive.Text = dReceive.Year > 1999 ? dReceive.Day.ToString("00") + "-" + dReceive.Month.ToString("00") + "-" + dReceive.Year.ToString("00") : "";
            }
            else
            {
                lblDreceive.Text = "";
            }

            if (d2 != null)
            {
                DateTime dIssue = DateTime.Parse(d2.ToString());
                lblDissue.Text = dIssue.Year > 1999 ? dIssue.Day.ToString("00") + "-" + dIssue.Month.ToString("00") + "-" + dIssue.Year.ToString("00") : "";
            }
            else
            {
                lblDissue.Text = "";
            }

            string script = String.Format("window.open('./EditBufferExchange.aspx?t=tool&entryno={0}&purrec={1}','_self')", DataBinder.Eval(e.Row.DataItem, "Entry_No"), DataBinder.Eval(e.Row.DataItem, "Posted_Purch_Receipt_No"));
            e.Row.Attributes.Add("onclick", script);

            if (e.Row.RowState == DataControlRowState.Alternate)
            {
                e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#F9E5B6';this.style.cursor='pointer';");
                e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#ffffff';");
            }
            else
            {
                e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#F9E5B6';this.style.cursor='pointer';");
                e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#f1f3f6';");
            }


        }
    }

SQL Helper Class

Download