Remove all cookies from browser in c# | Pravin Prajapati

Remove all cookies from browser in c#

Create Method

 protected void removeCookie()
        {
            HttpCookie aCookie;
            string cookieName;
            int limit = Request.Cookies.Count;
            for (int i = 0; i < limit; i++)
            {
                cookieName = Request.Cookies[i].Name;
                aCookie = new HttpCookie(cookieName);
                aCookie.Expires = DateTime.Now.AddDays(-1);
                aCookie.Value = string.Empty;
                Response.Cookies.Add(aCookie);
            }
        }

Call Method

 protected void Page_Load(object sender, EventArgs e)
        {
            removeCookie(); //call method here
        }

Compare Date,Time in Sql, Comapre date,Compare time in Sql | Pravin Prajapati

  Compare Date/Time with Currant Date/Time in Sql

SELECT COUNT(*)

FROM tablename

WHERE
--compare date here with current date.
 CONVERT(DATE, [dateTimeColumn]) = CONVERT(DATE, GETDATE())
--compare time here with current time
 AND CONVERT(TIME, [dateTimeColumn]) <= CONVERT(TIME, GETDATE())