Tuesday, April 16, 2013

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! :)