ASP.NET

<br />
         OleDbConnection cnc = new OleDbConnection((string)Session["cs"]);<br />
            cnc.Open();<br />
            string qc = "select Date1 from friends where Username='" + (string)Session["uname"] + "' and Confirm='No'";<br />
            OleDbCommand cmdc = new OleDbCommand(qc, cnc);<br />
            OleDbDataReader drc = cmdc.ExecuteReader();<br />
            while(drc.Read())<br />
            {<br />
                DateTime dtc = Convert.ToDateTime(drc[0].ToString());<br />
<br />
                string da1 = DateTime.Now.ToShortDateString();<br />
                DateTime date1 = Convert.ToDateTime(da1);<br />
                string dttc = Convert.ToString(dtc);<br />
              <br />
                TimeSpan ko = date1.Subtract(dtc);<br />
                int day = ko.Days;<br />
<br />
                <br />
<br />
             if(day>=10)<br />
                {<br />
                   <br />
                   OleDbConnection cnc1 = new OleDbConnection((string)Session["cs"]);<br />
                    cnc1.open()<br />
                      string qc1 = "Delete from friends where Username='" + (string)Session["uname"] + "' and confirm='yes' and Date1='" + dttc + "'";<br />
                      OleDbCommand cmdc1 = new OleDbCommand(qc1, cnc1);<br />
                       cmdc1.ExecuteNonQuery();<br />
                       cnc1.Close();<br />
                }<br />
<br />
<br />
<br />
            }<br />
<br />
            cnc.Close();