ASP.NET

if (Request.QueryString["username"] != null) {
        username = Request.QueryString["username"].ToString();
        lbluname.Text = "Welcome   :" + username;
        lbldate.Text = System.DateTime.Now.ToString();
} else {

//TODO
}

username = Request.QueryString["username"];

lbluname.Text = "Welcome   :" + HttpUtility.HtmlEncode(username)

Quote:

C#

string yesterday = DateTime.Today.AddDays(-1).ToShortDateString();

string yesterday = db.database_BWICs.Find(d => d.UploadDate == yesterday);

db.database_WICs.Find(d => d.UploadDate == yesterday

namespace Wic_T1
{
    using System;
    using System.Collections.Generic;
    using System.Runtime.Serialization;

     [DataContract]
    public partial class database_WICs
    {
        [DataMember]
        public int ID { get; set; }
        [DataMember]
        public string Name { get; set; }
        public Nullable<System.DateTime> SaleDateTime { get; set; }
        public string Region { get; set; }
        [DataMember]
        public string CUSIP { get; set; }
        [DataMember]
        public string Size__m_ { get; set; }
        public string OriginalRating { get; set; }
        public Nullable<System.DateTime> MaturityDate { get; set; }
        public string Manager { get; set; }
        [DataMember]
        public string priceTalk { get; set; }
        [DataMember]
        public string Cover { get; set; }
        public Nullable<System.DateTime> LastUpdated { get; set; }
        [DataMember]
        public Nullable<System.DateTime> UploadDate { get; set; }
        [DataMember]
        public string Type { get; set; }
        [DataMember]
        public string ISINs { get; set; }
        [DataMember]
        public Nullable<float> Decimal_price { get; set; }
        public string CMBS_spread { get; set; }
        public Nullable<float> CMBS_decimal { get; set; }
        [DataMember]
        public string Current_size { get; set; }
    }
}