Server Error: System.NullReferenceException: Object Reference Not Set to An Instance

See more:

C#

ASP.NET4

Hello,

Below Error Is Thrown On My VPS Server When The Page Is Loaded After Login:

[NullReferenceException: Object reference not set to an instance of an object.]
   pgHome.Fill_Repeater() +88
   pgHome.Page_Load(Object sender, EventArgs e) +687
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

But When I connect my local codes to Server it runs perfectly without any exception thrown can you please give me a solution

Page Load Event Code below

protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Username"].ToString() == "")
        {
            Response.Redirect("pgLogin.aspx");
        }
        cn.ConnectionString = ConfigurationManager.ConnectionStrings["TLI"].ConnectionString;
        if (!IsPostBack)
        {

            Session["LoadMore"] = "15";
            //string html = AddToCatalog("0");
            //cat.InnerHtml = html;

            cn.Open();
            cmd.Connection = cn;
            cmd.CommandText = "Select FirstName from UserProfile where Username='" + Session["Username"].ToString() + "'";
            rs = cmd.ExecuteReader();
            while (rs.Read())
            {
                lblFirstName.Text ="Welcome "+ rs.GetValue(0).ToString();
            }
            rs.Close();
            cmd.Dispose();
            cn.Close();

            cn.Open();
            cmd.Connection = cn;
            cmd.CommandText = "Select COUNT(DISTINCT(SKU)) from CategoryDetails";
            rs = cmd.ExecuteReader();
            while (rs.Read())
            {
                //lblShowingRecords.Text = rs.GetValue(0).ToString();
                lblTotalRecord.Text = rs.GetValue(0).ToString();
            }
            rs.Close();
            cmd.Dispose();
            cn.Close();
            Fill_Repeater();

            int cnt = Request.QueryString.Count;
            if (cnt == 2)
            {
                //Session["CatalogBlock"] = "True";
                string id = Request.QueryString["q2"];
                string image_id = "", sku = "", catalogname = "";
                cn.Open();
                cmd.Connection = cn;
                cmd.CommandText = "Select * from ProductCatalog where id=" + id;
                rs = cmd.ExecuteReader();
                while (rs.Read())
                {
                    image_id = rs.GetValue(3).ToString();
                    sku = rs.GetValue(2).ToString();
                    catalogname = rs.GetValue(4).ToString();
                }
                rs.Close();
                cmd.Dispose();
                cn.Close();

                Session["CatalogID"] = id;
                Session["ImageID"] = image_id;
                Session["SKU"] = sku;
                Session["Catalog_Saved_Boolean"] = "true";
                string html = MakeULLIAfterSaving(catalogname);
                cat.InnerHtml = html;
                Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "myfun", "tabStyle();", true);
            }
            else
            {
                //Session["CatalogBlock"] = "false";
                string html = AddToCatalog("0");
                cat.InnerHtml = html;
            }

        }
    }

Fill_Repeater Function Code Below

public void Fill_Repeater()
    {
        ArrayList sess_id = new ArrayList();
        sess_id.Clear();
        foreach (string temp in Session["ImageID"].ToString().Split(','))
        {
            if (temp != "")
            {
                sess_id.Add(temp);
            }
        }
        //string section = "TABLE CUST (SEASONAL PRD)";
        ArrayList SKU = new ArrayList();
        SKU.Clear();
        cn.Open();
        cmd.Connection = cn;
        cmd.CommandText = "Select DISTINCT(SKU) from CategoryDetails";
        rs = cmd.ExecuteReader();
        while (rs.Read())
        {
            SKU.Add(rs.GetValue(0).ToString());
        }
        rs.Close();
        cmd.Dispose();
        cn.Close();
        DataTable dt = new DataTable("CategoryDetails");
        dt.Columns.Add("ID", typeof(string));
        dt.Columns.Add("Title", typeof(string));
        dt.Columns.Add("ImageName", typeof(string));
        dt.Columns.Add("Count", typeof(string));
        dt.Columns.Add("ClassToAdd", typeof(string));
        int loadmore = Convert.ToInt32(Session["LoadMore"].ToString());
        int loopIteration = 0;
        if (loadmore <= SKU.Count)
        {
            loopIteration = loadmore;
            lblShowingRecords.Text = loopIteration.ToString();
        }
        else
        {
            loopIteration = SKU.Count;
            lblShowingRecords.Text = loopIteration.ToString();
        }
        for (int i = 0; i < loopIteration; i++)
        {
            string qry = "select TOP 1 t1.id,t1.Title, t1.ImageName, COUNT(t2.SKU) as Count from CategoryDetails t1 inner join CategoryDetails t2 ON t1.SKU= t2.SKU  where t2.SKU = '" + SKU[i].ToString() + "' group by t1.id,t1.Title, t1.ImageName";
            cn.Open();
            cmd.Connection = cn;
            cmd.CommandText = qry;
            rs = cmd.ExecuteReader();
            while (rs.Read())
            {
                if (sess_id.Contains(rs.GetValue(0).ToString()))
                {
                    dt.Rows.Add(new string[5] { rs.GetValue(0).ToString(), rs.GetValue(1).ToString(), rs.GetValue(2).ToString(), (int.Parse(rs.GetValue(3).ToString()) - 1).ToString(), "catlg-icon brd-none selected" });
                }
                else
                {
                    dt.Rows.Add(new string[5] { rs.GetValue(0).ToString(), rs.GetValue(1).ToString(), rs.GetValue(2).ToString(), (int.Parse(rs.GetValue(3).ToString()) - 1).ToString(), "catlg-icon brd-none" });
                }
            }
            rs.Close();
            cmd.Dispose();
            cn.Close();
        }
        rptSlide.DataSource = dt;
        rptSlide.DataBind();
    }