ASP.NET

"SELECT * FROM [sheet1$] where [LoginDate]='" + myLoginDate.ToString("yyyy-MM-dd hh:mm:ss") + "'" 

class KgToLbsConverter
    {
        public double _qty;
        public bool _isKgs;
        /// <summary>
        /// 
        /// </summary>
        /// <param name="qty">The amount of kgs/lbs</param>
        /// <param name="isKgs">determines if the quantity provided is in kgs or lbs</param>
        public KgToLbsConverter(double qty) 
        { 
            _qty = qty;            
        }
        public bool QuantityIsInKilograms
        {
            get { return _isKgs; } // the value of _isKgs is returned
            set { _isKgs = value; } // we set the value for _isKgs
        }
        //Properties with no set accessor are readonly
        public double Kilograms
        {
            get 
            {
                //If the quantity provided is in kilograms,it returns the quantity
                //Otherwise, it converts the quantity to kilograms before returning it.
                if (_isKgs) { return _qty; }
                else { return _qty * 2.20462262; };
            }            
        }

        public double Pounds
        {
            get
            {
                //If the quantity provided is in pounds,it returns the quantity
                //Otherwise, it converts the quantity to pounds before returning it.
                if (!_isKgs) { return _qty; }
                else { return _qty / 2.20462262; };
            }  
        }        
    }

KgToLbsConverter convert = new KgToLbsConverter(1);
convert.QuantityIsInKilograms = true;
//convert.Pounds will have a value of 2.20462262
//convert.Kilograms will have a value of 1

<tr style="border:solid 1px Black;" onclick="ToggleColor(event);">

function ToggleColor(ev) {
    var tar;
    //IE and Firefox treats the event caller differently. This snippet is to make sure 
    //that what we are selecting is the right element before setting its background color.
    if (ev.srcElement != null) {
        tar = ev.srcElement.parentElement;
    }
    else {
        tar = ev.currentTarget;
    }

    if (tar.bgColor == "#eeeeee") {
        tar.bgColor = "#ffffff";
    }
    else {
        tar.bgColor = "#eeeeee";
    };
}

95ulisse wrote:

I solved the problem creating a third page and requesting it via AJAX