Comparing Date between Two dates

Example: to_date(AUTHORIZEDTIME,'mm/dd/YYYY HH12:MI:SS AM') between to_date('" + fromdate + "','dd/mm/yyyy') and to_date('" + tilldate + "','dd/mm/yyyy') ORDER BY dateorder DESC


Syntax: to_date(Fieldname,'Date Format')  between to_date(Fieldname,'Date Format') and to_date(Fieldname,'Date Format')

For checking all the rows in a gridview to check for already existing Identical values

int rowindex = GVRules.SelectedIndex;
        foreach (GridViewRow gvrow in GVRules.Rows)
        {
            if (gvrow.RowIndex != rowindex)
            {
                if (DdlRule.SelectedValue == GVRules.DataKeys[gvrow.RowIndex].Values[2].ToString()

&& DdlMemPrmZone.SelectedItem.Text == gvrow.Cells[2].Text && DdlMemProvZone.SelectedItem.Text ==

gvrow.Cells[3].Text)
                {
                    Label1.Text = "Rule " + DdlRule.SelectedItem.Text + " for Member Premium Zone "

+ DdlMemPrmZone.SelectedItem.Text + " and Member Provider Zone " + DdlMemProvZone.SelectedItem.Text

+ " is already added to this Policy !!";
                    return false;
                }
            }

        }

Sorting the gridview column wise, using datasource

using System;
using System.Data;
using System.Configuration;
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;

/// <summary>
/// Summary description for AutowithholdruleforDS
/// </summary>
public class AutowithholdruleforDS
{
    public AutowithholdruleforDS()
    {
        string Cachekey = "AutowithholdRule_" + HttpContext.Current.Session.SessionID;
         this.CD1 = (DataTable)HttpRuntime.Cache[Cachekey];
    }
    private DataTable CD1;

    public DataView Select()
    {
        if (this.CD1 != null)
        {
            this.CD1.DefaultView.Sort = "";
            return this.CD1.DefaultView;
        }
        else
        {
            return null;
        }
    }
}

Email validation using Javascript

function EmailValidCheck(emailtxt)
{
 var email1=document.getElementById(emailtxt).value;
 var emailfilter=/^\w+[\+\.\w-]*@([\w-]+\.)*\w+[\w-]*\.([a-z]{2,4}|\d+)$/i;
 if(email1.length>0)
 {
 var returnval=emailfilter.test(email1);
 if (returnval==false)
 {
 alert("Please Enter Valid Employee Email ID !!")
 document.getElementById(emailtxt).focus();
 return false;
 }
 }
}