ASP.NET Progress

[navyjax2]

What if your event handler has to be nonstatic?

[Frinavale]

Navyjax2, could you please provide more information about the problem you are facing?

There is the INotifyPropertyChanged.PropertyChanged Event. When this event is raised it indicates that the property has been changed.



-Frinny

[navyjax2]

Bare with me, I'm fairly new to delegates, interfaces, and events, even though I've been doing C# for almost 2 yrs and VB/VB .NET since VB6.

Basically I wanted to do an event whenever a variable's value changed. A public variable value (essentially a counter) is increased as a DataTable is parsed through a foreach loop. The variable's value changing would trigger an event that would change the innerHTML of a span tag on the page (which has to happen within a nonstatic function), to give an indication of what row we were on out of the total - creating a progress counter.

Something like:

    private long _rowCount = CSV.rowCount;
    public delegate void PrivateVariableChanged(object sender, EventArgs e);
    public event PrivateVariableChanged SelectedChanged
    {
        add { fileLinkArea.InnerHtml = "Processed " + CSV.rowCount + " of " + CSV.rowTotal; }
        remove { }
   };  
 
    private void NotifyPrivateVariableChanged(String info)
    {
        if (SelectedChanged != null)
        {
            SelectedChanged(this, new PrivateVariableChangedEventArgs(info));
        }
    }
    public long RowCount
    {
        get
        {
            return this._rowCount;
        }
 
        set
        {
            if (value != this._rowCount)
            {
                this._rowCount = value;
                NotifyPrivateVariableChanged("RowCount");
            }
        }
    }

But this is totally hosed and does not work. I checked MSDN and there is no PrivateVariableChangedEventArgs even though there is a PrivateVariableChanged. Any help?

Thanks,
Tom

[Frinavale]

I think that the easiest way to handle this is to make the public variable private and provide a public Property instead. That way your property could either raise an event that notifies all other classes of the change...or it could change the innerHTML (not sure why you're doing this but ok) of the element.

It's nice when encapsulation works for you :)

-Frinny

[navyjax2]

So what changed property would it be firing on? And is that the right syntax for the event?

I was trying this another way, too - as the foreach loop processes and increments the counter I have, couldn't I just set the innerHTML updating to occur there? But the thing is, _Default defaultClass = new _Default() won't instantiate the _Default class where my page is, so that it could run a function there that would take care of the innerHTML updating. Is there a way around this? If so, I might not even need events at all...

Thanks,
Tom

[Frinavale]

What is really confusing me is the that you're setting the innerHTML.
First of all this isn't typically done in ASP.NET any more. Instead the Text property is usually used (for example: myLabel.Text = "1 of 5")

The other thing that is confusing me is that your C# code is executed on the server...this means that the user will not see the change to the innerHTML (or even the Text property) until the response to the request is sent to the browser....in which case, why don't you just do your loop and when you're finished, set the innerHTML (or Text property) of the control?

-Frinny

[navyjax2]

Well, what I was doing was setting a span on the page equal to this text. I wanted the span to be able to show the progress to a user ("Row 1 of 14298 processed", etc.) as the DataTable is being looped through. I found that, even if I put the code into the _Default class (to prevent instantiation issues) and had it try and update the field "updateText" as the counter increased, it doesn't show on the page, at least while debugging it and letting it run a couple of loops - probably for the very reason you are saying - me not waiting til the end probably prevented it from displaying, but I want it to do it as it's going, not wait til the end.

So I thought about how you might be able to do this with JavaScript, since I know that JavaScript can do this, but adding an attribute to the button click that initiates this whole thing in Page_Load():

btnDBExport.Attributes.Add("onclick", "sendIt(" + data + ")");
 

where

function sendIt(data) {
   document.getElementById('updateText').innerHTML = data;
}

and

data = "Row " + rowCount + " of " + dt.Rows.Count + " processed.";

would only update the field once, and before my counter even exists - not throughout the loop. Is there a way to write on the fly to the page from C# to JavaScript in this way? Thanks for the replies.

-Tom

[Frinavale]

This is actually a little more complicated than you would think.
I'm sure that there may be another way to do this but this is the first thing that comes to my mind....

When you click the button that starts the processing, also start a Ajax Timer control that posts back to the server after a given amount of time has passed.

Have the loop set a Session variable so that when the Ajax Timer posts back to the server the method that handles the tick event can retrieve the value and display it in the web page.

I suggest using an ASP.Net Label control instead of your typical HTML <span> because this control renders as a <span> and lets you manipulate the Text and style aspects (along with a bunch of other properties) in your VB.NET/C# server code.

Place the Label that is going to display the text inside an UpdatePanel so that only that section of the page is updated....likewise place the GridView and the Button in an UpdatePanel so only that section of the page is being processed when you click the button.

-Frinny

[Frinavale]

I've moved your question into a thread of it's own because this question is straying off topic from the original question.

New questions should not be posted onto the end of old questions.

This thread has been split off of:
http://bytes.com/topic/net/answers/6...changes-vb-net

-Frinny

[jumbojs]

This sounds like it would work but I'm trying to add the Timer control in code behind after the button is clicked and it isn't really working

 protected void btnRunUpdateNow_Click(object sender, EventArgs e)
    {
 
 
        Timer timerControl = new Timer();
        timerControl.Tick += new EventHandler<EventArgs>(timerControl_Tick);
        timerControl.Interval = 3000;
 
       .......
   }

What am I missing. Nothings happening as I run this code

[Frinavale]

Instead of adding the event handler in this code try moving it to your declaration.
For example:

<asp:Timer ID="timerControl" runat="server" OnTick="timerControl_Tick" Interval="3000" ></asp:Timer>

Set your timer to be disabled at first....you will need to enable it when you need it to start ticking back to the server.

The thing is that I was a little mistaken earlier....you can't really enable the timer in your button click event because you need to send the request back to the client before you start the looping. You're probably going to have to send 2 requests: the first one starts the timer, the second starts the looping.

Or you need to figure out a way to send the request back to the client while the server continues to loop.

-Frinny

[jumbojs]

Thanks for the reply. I actually tried setting up the Timer control this way (disabling it and enabling it on button click) Didn't really work. I was trying to do something like this.

<asp:Timer ID="Timer1" runat="server" Interval="3000" Enabled="false" OnTick="Timer1_Tick">
    </asp:Timer>
 
    <asp:UpdatePanel ID="upProgress" runat="server" >
        <ContentTemplate>
            <div>
                <asp:Label ID="Progress" runat="server" Text="Sample"></asp:Label>
            </div>
        </ContentTemplate>
    </asp:UpdatePanel>

Then in my Timer Click Event

protected void Timer1_Tick(object sender, EventArgs e)
    {
 
        Session["Progress"] = "Started processing...";
 
        Progress.Text = (string)Session["Progress"];
    }

Then what I want to do here is on click, I start the import process by passing the control of to a class housed in an assembly.

protected void btnRunUpdateNow_Click(object sender, EventArgs e)
    {
                 Timer1.Enabled = true;
                 myClass.RunUpdate();
    }

Inside myClass housed in an assembly, I was trying to update progress using the Session variable.

public void RunUpdate()
   {
            .....
            HttpContext.Current.Session["Progress"] = _Orders.Count.ToString();
   }

I'm not sure how else to get this to work. If I need to move this to another thread, let me know.

[Frinavale]

I just tried to implement what I was suggesting and it doesn't work.
This comes back to a problem that I got stuck on about a year ago (or so) that I had forgotten about...

Apparently (I'm not sure if this is a Cassini thing or not) the server code will not process more than one request from the same webpage at the same time.

For example:

• Button posts back to server and a long process is started
• TimerControl posts back to server

The TimerControl postback won't be processed until the button click event is finished processing. This defeats the whole purpose of Asynchronous. I was very annoyed when I discovered this and never did find out why this was happening, nor did I find out how to get around this.

-Frinny

[Frinavale]

I think I'm getting closer to finding an answer.
Apparently you have to specify your page is Async in the @Page directive. Then you have to implement Begin and End methods for the things are going to take a long time so that they are executed asynchronously...

I'm reading Wicked Code:Asynchronous Pages in ASP.NET 2.0 in an attempt to solve this problem.

-Frinny

[Frinavale]

Upon further reading of the article I discovered the asynchronous page was simply for processing more than one thing in different threads before the response is sent to the browser. It was an interesting read but doesn't help with the problem.

So, I have something that sort of works....it works the very first time the page is loaded but after that it doesn't.

This is what I have in my ASPX page:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TestingProgress.aspx.cs" Inherits="WebApplication1.TestingProgress" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Testing</title>
</head>
<body>
    <form id="form1" runat="server">
    <asp:ScriptManager ID="sm" runat="server"></asp:ScriptManager>
    <div>
        <asp:UpdatePanel ID="upnl" runat="server">
        <ContentTemplate>
          <asp:Timer ID="timerControl" runat="server" Enabled="false" Interval="500" OnTick="timerControl_Tick"></asp:Timer>
 
          <asp:LinkButton ID="startTimer" runat="server" OnClick="startTimer_Click" Text="Start Timer" style="display:none;"></asp:LinkButton>
          <asp:Label ID="processingMessage" runat="server"></asp:Label>
          <asp:Button runat="server" ID="btnLongProcess" Text="start processing" OnClientClick="return startTimerBeforePosting();" OnClick="btnLongProcess_Click" />
          <script type="text/javascript">
              function startTimerBeforePosting() {
                  setTimeout(waitBeforeStartingTimer, 1000);
                  return true;
              }
              function waitBeforeStartingTimer() {
                  __doPostBack('<%=startTimer.ClientID %>', '');
              }
          </script>
        </ContentTemplate>
        </asp:UpdatePanel>
 
     </div>
    </form>
</body>
</html>

And this is what I have in my C# code:

namespace WebApplication1
{
    public partial class TestingProgress: System.Web.UI.Page
    {
        private static int loopIteration = 0;
        private int max = 10;
        protected void Page_Load(object sender, EventArgs e)
        {   if (!IsPostBack) {
            loopIteration = 0;
            }
        }
        protected void timerControl_Tick(object sender, EventArgs e)
        {  /*int iteration = 0;
            if (Session["loopIteration"] != null) {
                iteration = (int)Session["loopIteration"];
            }
            processingMessage.Text = iteration.ToString() +"/"+ max.ToString();
            if (loopIteration >= max-1)
            {
                timerControl.Enabled = false;
                processingMessage.Text = "Done. Timer stopped in tick.";
            }*/
 
            processingMessage.Text = loopIteration.ToString() + "/" + max.ToString();
            if (loopIteration >= max)
            {
                timerControl.Enabled = false;
                processingMessage.Text += " Done. Timer stopped in tick.";
            }
        }
        protected void startTimer_Click(object sender, EventArgs e)
        {
            timerControl.Enabled = true;
            processingMessage.Text = "Timer started...";
        }
        protected void btnLongProcess_Click(object sender, EventArgs e)
        {
            Session["loopIteration"] = 0;
            loopIteration = 0;
            for (loopIteration = 0; loopIteration < max; loopIteration++)
            {
                //Session["loopIteration"] = loopIteration;
                System.Threading.Thread.Sleep(1000);
            }
            timerControl.Enabled = false;
            processingMessage.Text = "Done. Timer stopped in button click.";
        }
    }
}

Now, like I said this works the first time.

The JavaScript in the ASPX page calls a function that preforms a postback for a hidden LinkButton on the page a second after the button is clicked. The code that handles the LinkButton click event enables the timer. So the Timer is started after button click the process begins.

The button click process sets a static integer to 0 and then increments the static integer by one in a loop that puts the main thread to sleep for a second each loop.

In the timer tick event, the static integer is displayed on the page along indicating how much more it has to go before the process is done.

This works the first time the page is ever loaded.
Once the button has been clicked and the processing stuff has been displayed it stops working.

What do I mean by that?
Well, if you click the button again the JavaScript waits for one second and fires the postback for the hidden LinkButton...the thing is that the click event for the link button is not fired until after the button click event is complete. This means that the timer is started after the looping process is done which is not really useful.

I don't know why this is the case...

Aside from that, another thing that I found is that you can't use Session in this solution. I never realized how slow accessing Session was until this experiment. I tried locking session every time I accessed it thinking that the timer tick event implementation couldn't access Session since the button click event was using it...but this didn't help. You can see the Session attempt commented out in my above posted code.

And, I don't think that using a static variable is going to really be feasible in your real-world application, but Session wasn't working...so I tried something else....which "kind of" worked.

I'm not sure what to suggest...

-Frinny

[navyjax2]

***************
This is actually a little more complicated than you would think.
I'm sure that there may be another way to do this but this is the first thing
that comes to my mind....

When you click the button that starts the processing, also start a Ajax Timer
control that posts back to the server after a given amount of time has passed.

Have the loop set a Session variable so that when the Ajax Timer posts back to
the server the method that handles the tick event can retrieve the value and
display it in the web page.

I suggest using an ASP.Net Label control instead of your typical HTML <span>
because this control renders as a <span> but lets you manipulate the Text and
style aspects (along with a bunch of other properties) in your VB.NET/C# server
code.

Place the Label that is going to display the text inside an UpdatePanel so that
only that section of the page is updated....likewise place the GridView and the
Button in an UpdatePanel so only that section of the page is being processed
when you click the button.

-Frinny

Thank you very much for your help. This is everything I did, for the benefit of someone in the future. I'm fairly new to AJAX, but I installed it from http://www.microsoft.com/downloads/e...displayLang=en, updated the web.config file using http://www.asp.net/AJAX/documentatio...SPNETAJAX.aspx, created an UpdatePanel, but I found that I needed to just start from scratch to create an AJAX-enabled site because of all of the misguided web.config references (see [<link snipped>] .... seems Microsoft didn't tell us you can't just put some stuff in your web.config and throw some non-existant DLLs into your Bin folder to make this work....anyway...) ....

Followed the first half of <link snipped> to get me going once I created my AJAX-enabled ASP .NET site.

So once I had that (and corrected a "Sys.WebForms.PageRequestManagerTimeoutExcepti on" by setting AsyncPostBackTimeout really high), I tried invoking the .Tick() method on the timer to make it update the panel manually during my database "foreach" loop, but this doesn't work to make the content update; allowing it to load something "onload" did execute correctly, however. So the best I could do was to disable the timer at Page_Load, enable it right before the "foreach" loop, try to set the interval fast/low enough that I can see the number of records change to something other than the last number, and disable it right after the loop. And for some reason it only runs after the 2nd time I click my button - not sure why that is. In trying to find out/find a better way, I ran across a site (<link snipped>) where they say not to run a server-side timer, so I'm a little confused if I'm doing things right and if this is the best I can achieve. At any rate, here's my code... note that this is a stripped down version of my real program, but I want it to work here in this "tester" program, because if it works here, it will work in my main program.

Default.aspx:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Search Monitoring:  Message Validation</title>
    <script type="text/javascript">
 
    function activateClock() {
        document.getElementById('formatText').innerHTML = "<img src='https://<% =ConfigurationManager.AppSettings["FQDN"] %>/SearchMonitoringSite/images/animated-clock.gif' />";
    }
 
    </script>    
</head>
<body>
 
    <form id="form1" runat="server">
 
    <asp:ScriptManager ID="ScriptManager1" runat="server" AsyncPostBackTimeout="360000" />
    <asp:Button ID="btnDBExport" runat="server" Text="Export DB" OnClick="btnDBExport_Click" />
     <asp:UpdatePanel ID="UpdatePanel1" runat="server" OnLoad="UpdatePanel1_Load" UpdateMode="conditional">
        <ContentTemplate>
    <asp:Timer ID="Timer1" runat="server" Interval="10000" OnTick="Timer1_Tick">
    </asp:Timer>   
<asp:Label ID="lblDBExport" runat="server"></asp:Label>
        </ContentTemplate>
        <Triggers >
            <asp:AsyncPostBackTrigger ControlID="Timer1" EventName="Tick" />
        </Triggers>
    </asp:UpdatePanel>  
        <table>      
        <tr><td><span id="formatText" style="color:red;font-size:13px;font-family:Arial" runat="server"></span></td></tr>
        </table>
    </form>
</body>
</html>
 

Default.aspx.cs:

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Web.Configuration;
using System.Windows.Forms;
using System.Threading;
 
public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(string data, object sender, EventArgs e)
    {
        btnDBExport.Attributes.Add("onclick", "activateClock();");
        ScriptManager1.RegisterAsyncPostBackControl(btnDBExport);
        Timer1.Enabled = false;
    }
 
    private static long rowCount = 0;
    private static long rowTotal = 0;
 
    protected void btnDBExport_Click(object sender, EventArgs e)
    {
        rowCount = 0;
 
        try
        {
            Configuration rootWebConfig =
                WebConfigurationManager.OpenWebConfiguration("/ShowDBProgress");
            if (0 < rootWebConfig.ConnectionStrings.ConnectionStrings.Count)
            {
                string connString = (string)WebConfigurationManager.ConnectionStrings["RemoteSqlServer"].ConnectionString;
 
                SqlConnection sqlConn = new SqlConnection(connString);
                if (sqlConn.State == ConnectionState.Open)
                {
                    sqlConn.Close();
                }
                sqlConn.Open();
 
                string sqlCmd = "SELECT * FROM SearchMon.dbo.MsgStatus";
                SqlDataAdapter myDataAdapter = new SqlDataAdapter(sqlCmd, sqlConn);
                DataTable dt = new DataTable();
                myDataAdapter.Fill(dt);
                string name = "";
                Timer1.Enabled = true;
                Timer1.Interval = 1;
                rowTotal = dt.Rows.Count;
                foreach (DataRow r in dt.Rows)
                {
                    name = r["MessageId"].ToString();
                    rowCount++;
                }
                Timer1.Enabled = false;
                sqlConn.Close();
            }
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.ToString(), "Error");            
        }
    }
 
    protected void UpdatePanel1_Load(object sender, EventArgs e)
    {
        lblDBExport.Text = "Processed " + rowCount + " of " + rowTotal;
    }
 
    protected void Timer1_Tick(object sender, EventArgs e)
    {
        UpdatePanel1.Update();
    }
 

[Frinavale]

Navyjax2, I don't know how I missed your last post.
This is very interesting. I'm going to check out that last egghead article that you posted to see if I can make sense of it.

-Frinny

[Frinavale]

I didn't realize that the link you had posted was to a competing forum (not an article). I had to remove the link but it didn't have anything helpful on it anyways. The advise you were trying to follow was posted in 2006....it's 2010 now and technology has changed a lot.

-Frinny

[navyjax2]

I figured out a way to make what I was trying to do work. It's funny - I was doing the exact same thing using ASP that I did with Atlas, but the Atlas stuff worked and the ASP stuff didn't. I still don't get it, because you can literally swap out the ASP timer for an Atlas one and the Atlas one will tick, the ASP one won't until all of the other server side code has been run, even if you put it in a new Thread like I used from an Atlas-enabled site I found the code for and modified to my particular project from http://www.codeproject.com/KB/aspnet...or_ASPNET.aspx. You have to register there to download the code, but I'll paste what I did with it here:

Default.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>UpdatePanel Site</title> 
 
</head>
<body>
    <form id="form1" runat="server">
 
  <atlas:ScriptManager ID="ScriptManager1" runat="server" EnablePartialRendering="True" />
<div>
            &nbsp;<atlas:TimerControl ID="Timer1" runat="server" OnTick="Timer1_Tick" Enabled="false" Interval="10">
            </atlas:TimerControl>
        </div>
 
              <atlas:UpdatePanel ID="UpdatePanel1" runat="server" Mode="Conditional">
  <Triggers>
            <atlas:ControlEventTrigger ControlID="Timer1" EventName="Tick" /></Triggers>
        <ContentTemplate><div style="background-color:Black; height:10px; width:300px">
                <div id="bar" runat="server" style="height:10px; width:0px; background-color:#006699">
                </div>
            </div>
             <asp:Label ID="Label1" runat="server" Text="0 %"></asp:Label><br />
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/Default.aspx" Visible="False">Refresh Page</asp:HyperLink><br />          <br />
        </ContentTemplate>
    </atlas:UpdatePanel>
            <br />    
      <asp:Button ID="btnDBExport" Text="Export DB" OnClick="btnDBExport_Click" runat="server" />&nbsp;<br />
            <br />                      
            <br />
     <br />       
 
    </form>
</body>
</html>
 

Default.aspx.cs

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Security.Principal;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Threading;
 
public partial class _Default : System.Web.UI.Page 
{
    // Progress Bar controls
    private static long rowCount = 0;
    private static long rowTotal = 0;
    private static string msgUrl = "";
 
    protected void Page_Load(object sender, EventArgs e)
    {
        ScriptManager1.RegisterAsyncPostBackControl(Timer1);
        Timer1.Enabled = false;
    }
    protected void btnDBExport_Click(object sender, EventArgs e)
    {
        Timer1.Interval = 10;
        Timer1.Enabled = true;
        Session["status"] = 0;
        Thread objThread = new Thread(new ThreadStart(DoTheWork));
        objThread.IsBackground = true;
        objThread.Start();
        Session["Thread"] = objThread;
        btnDBExport.Enabled = false;
    }
 
    protected void DoTheWork()
    {
        string verified = "";
        string sqlCmdText = "";
        DataTable dtDbList = new DataTable();
        SqlDataAdapter sdaDbList = new SqlDataAdapter();
        rowTotal = 0;
        rowCount = 0;
 
        try
        {
            ConnectionStringSettings cs = ConfigurationManager.ConnectionStrings["RemoteSqlServer"];
            string connString = cs.ConnectionString;
 
                // Open the DB
                SqlConnection sqlConn = new SqlConnection(connString);
                if (sqlConn.State == ConnectionState.Open)
                {
                    sqlConn.Close();
                }
                sqlConn.Open();
 
                // Set the database query and fill the DataTable
                sqlCmdText = "SELECT * FROM SearchMon.dbo.MsgStatus";
                sdaDbList = new SqlDataAdapter(sqlCmdText, sqlConn);
                sdaDbList.Fill(dtDbList);
                rowTotal = dtDbList.Rows.Count;
 
                // Cycle through the database
                foreach (DataRow dr in dtDbList.Rows)
                {
                    verified = dr["Verified"].ToString();
                    msgUrl = dr["MsgUrl"].ToString();
                    rowCount++;
                }
 
                // Dispose of our loose ends
                Timer1.Enabled = false;
                dtDbList.Clear();
                sdaDbList.Dispose();
 
                // Close the connection
                sqlConn.Close();
 
        }
        catch (Exception ex)
        {
            MsgBox("Error in DB or DB Connection String: " + ex.ToString());
        }
 
        Timer1.Enabled = false;
        Thread objThread = (Thread)Session["Thread"];
        objThread.Abort();
    }
 
    protected void Timer1_Tick(object sender, EventArgs e)
    {
        decimal complete = 0;
        if (rowTotal != 0)
            complete = (rowCount * 100) / rowTotal;
        else
            complete = 0;
 
        if (complete == 100)
        {
            Timer1.Enabled = false;
            HyperLink1.Visible = true;
            btnDBExport.Enabled = true;
        }
        Label1.Text = complete.ToString() + "% complete, MsgUrl = " + msgUrl + ", Row: " + rowCount + " of " + rowTotal + " complete.";
        HtmlGenericControl div = (HtmlGenericControl)this.FindControl("bar");
        complete = complete * 3;
        div.Style["width"] = complete.ToString() + "px";
 
    }
 
    private void MsgBox(string sMessage)
    {
        string msg = "<script language=\"javascript\">";
        msg += "alert('" + sMessage + "');";
        msg += "</script>";
        Response.Write(msg);
    }
 
}
 

I'm obviously going to do more in that database "foreach" loop above, just wanted to prove I could show a progress bar while I was doing it.

-Tom