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";
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())
{
lblTotalRecord.Text = rs.GetValue(0).ToString();
}
rs.Close();
cmd.Dispose();
cn.Close();
Fill_Repeater();
int cnt = Request.QueryString.Count;
if (cnt == 2)
{
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
{
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);
}
}
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();
}