I have a page called CustomerSlides.aspx which contains an iframe(with the
source Lookupage.aspx). The iframe page will look continuously in the
database to see if a value has changed: if it is true it will run a java
script dynamically to update the parent page CustomerSlides.aspx.cs.
The value in the Database is changed from another aspx page så all the
changes made in this page will be updated in CustomerSlides.aspx.
I used the code below and it is working as long as it is only one client
looking at CustomerSlides.aspx. If more than one client are looking at the
same page from diffrent browsers(computers) no updates are done. Then have to
refresh manually. I wonder why it is working for one client and not for the
other? Is there any solution? Any help is highly appreciated.
See my code below:
Code behind for(CustomerSlides.aspx.cs):
public class CustomerSlides : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label Message;
protected System.Web.UI.HtmlControls.HtmlGenericControl mainIframe;
public string fullPath;
private void Page_Load(object sender, System.EventArgs e)
{
//Get the logged on administrator's email, retrieved from
"signincustomer.aspx.cs"(Will be used in the next step)
// string adminEmail = Convert.ToString(Session["senderAdmin"]);
string adminEmail = "te**@test.se";
//Retrieve the fullPath to the slide to be shown
// Create Instance of Connection and Command Object
SqlConnection myConnection = new
SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
// SqlCommand myCommand = new
SqlCommand("Portal_GetSlideFullPathFlag2", myConnection);
SqlCommand myCommand = new SqlCommand("SELECT DISTINCT
FullPath FROM TTflag2 WHERE AdminEmail = @AdminEmail ", myConnection);
// Mark the Command as a SPROC
// myCommand.CommandType = CommandType.StoredProcedure;
// Add Parameters to SPROC
SqlParameter parameterAdminEmail = new
SqlParameter("@AdminEmail", SqlDbType.NVarChar, 50);
parameterAdminEmail.Value = adminEmail;
myCommand.Parameters.Add(parameterAdminEmail);
try
{
// Execute the command
myConnection.Open();
SqlDataReader dr =
myCommand.ExecuteReader(CommandBehavior.CloseConne ction);
dr.Read();
fullPath = dr.GetString(0);
dr.Close();
}
catch (Exception ex)
{
Message.Text = ex.Message + " " + ex.StackTrace;
}
if ((fullPath != string.Empty) & (fullPath !=
null))
{
//Find the mainIframe control and add a source attribute
to it
HtmlControl mainIframe =
(HtmlControl)this.FindControl("menuForm").FindCont rol("mainIframe");
mainIframe.Attributes["src"] = fullPath;
}
else
{
HtmlControl mainIframe =
(HtmlControl)this.FindControl("menuForm").FindCont rol("mainIframe");
mainIframe.Attributes["src"] = "MainCustomer.aspx";
}
}
//-------------------------------------------------------------------------------------------------------------------------------------------------------
Code Behind for (LookupPage.aspx.cs):
public class LookupPage : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label Message;
public string adminEmail;
private void Page_Load(object sender, System.EventArgs e)
{
//Get the logged on administrator's email(Will be used in the
next step)
// string adminEmail = Convert.ToString(Session["adminEmail"]);
string adminEmail = "te**@test.se";
//************************************************** *******************
//
// This gets the count of the slides in Table TTflag,
// This tell us if we need to refresh CustomerSlides.aspx.
//
//************************************************** *******************
// Create Instance of Connection and Command Object
SqlConnection myConnection = new
SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
SqlCommand myCommand = new
SqlCommand("Portal_GetSlideInsertFlag2", myConnection);
// Mark the Command as a SPROC
myCommand.CommandType = CommandType.StoredProcedure;
// Add Parameters to SPROC
SqlParameter parameterAdminEmail = new
SqlParameter("@AdminEmail", SqlDbType.NVarChar, 50);
parameterAdminEmail.Value = adminEmail;
myCommand.Parameters.Add(parameterAdminEmail);
// myCommand.CommandTimeout = 300;
try
{
// Execute the command
myConnection.Open();
//Get the slide which has been clicked by the
administrator
//from database table TTflag
int myInsert = Convert.ToInt32(myCommand.ExecuteScalar());
ViewState["myInsert"]= myInsert;
}
catch(Exception ex)
{
Message.Text = ex.Message + " " + ex.StackTrace;
}
finally
{
//Close connection
if(myConnection.State != ConnectionState.Closed)
myConnection.Close();
}
//Control if there is a slide in database table TTflag
(inserted by the logged on administrator)
if(Convert.ToInt32(ViewState["myInsert"]) > 1)
{
//Refreshes the actual page
//Add the script to declare the
function
StringBuilder sb = new
StringBuilder("");
sb.Append("<script language =
javascript>");
sb.Append("{");
sb.Append("window.parent.location.reload();");
sb.Append("}");
//Close script
sb.Append("<");
sb.Append("/");
sb.Append("script>");
//Register the script (names
are CASE-SENSITIVE)
// if
(!IsClientScriptBlockRegistered("window.parent.loc ation.reload();"))
RegisterStartupScript("ReloadScript", sb.ToString());
//Delete the slide (inserted by the logged on
administrator) from TTflag
PresentationDB deleteSlideInsert = new PresentationDB();
deleteSlideInsert.DeleteSlideInsertFlag2(adminEmai l);
}
}
