create  function DateOnly(@DateTime

create function TimeSpan(@Days int, @Hours int, @Minutes int, @Seconds int)
-- returns a datetime the specified # of days/hours/minutes/seconds from the "base"

create  function DateOnly(@DateTime DateTime)
-- Returns @DateTime at midnight;

ViewState["USERCONTROLNAME"]= anyinstance;

public partial class rptViewer : System.Web.UI.Page
{
    static ReportDocument rd = new ReportDocument();
    ConnectionInfo ci = new ConnectionInfo();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["rpt"] != null)
        {

 string grdqry = "SELECT EMPCARD.CARDID, EMPCARD.CARDNO, EMPCARD.ISSUEDATE, EMPCARD.EXPIRYDATE, EMPCARD.STATUS, EMPDATA.EMPID FROM   EMPCARD INNER JOIN  EMPDATA ON EMPCARD.EMPID = EMPDATA.EMPID ";

            if (!LoadGrid(ref dgvECard, grdqry + " where EMPDATA.DEPTID=" + cmbDept.SelectedValue.ToString()))

void AddControl(int index, Panel container)
{
CheckBox cb = new CheckBox();
cb.Name = "chk_"+index;
container.Controls.Add(cb);
}

pbThumbImage.Image = new Bitmap(new MemoryStream(objEmployee.Picture));
[B]Application.DoEvents();[/B]
Thread.Sleep(5000);
pbThumbImage.Image = global::TimeEntrySystem.Properties.Resources.DefaultImage;