ASP.NET

Private Sub grid_ItemDataBound(ByVal sender as object, Byval e as System.Web.UI.WebControls.DataGridItemEventArgs) handles grid.ItemDataBound
  Dim itemType as ListItemType = e.Item.ItemType
  If ((itemType.Equals(ListItemType.Header)) Or (itemType.Equals(ListItemType.Footer)) Or (itemType.Equals(ListItemType.Pager)) Then
     Return
  End If
  e.Item.Attributes("onload") = "loadGrid();"
End Sub

function loadGrid()
{
  var x = 1;
}

<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();