When doing a backup I'd like to increment a Progress bar to the user so they know something is going on...

Here is my code:

DBConn.OnSendProgress+=new EDBCommsProgressEvent(DBConn_OnSendProgress);   

SQL = "BACKUP DATABASE ListBuilder ";
SQL += " AS " + chrQuote + FileName + chrQuote;
SQL += " TO STORE Backups"  ;
SQL += " INCLUDE CATALOG ";
dbCommand = new EDBCommand(SQL, DBConn);
dbCommand.ExecuteNonQuery();

And here is my method

private void DBConn_OnSendProgress(object sender, EventArgs e)
{
     MessageBox.Show("Fired!");
}

However when I back up my database some 7MB the event never fires...what am I doing wrong?

Pete

Pete,

<< When doing a backup I'd like to increment a Progress bar to the user so
they know something is going on...

Here is my code:

DBConn.OnSendProgress+=new EDBCommsProgressEvent(DBConn_OnSendProgress);

SQL = "BACKUP DATABASE ListBuilder ";
SQL += " AS " + chrQuote + FileName + chrQuote;
SQL += " TO STORE Backups"  ;
SQL += " INCLUDE CATALOG ";
dbCommand = new EDBCommand(SQL, DBConn);
dbCommand.ExecuteNonQuery();

And here is my method >>

What you want is this event:

EDBCommand.OnProgress

http://www.elevatesoft.com/manual?action=mantopic&id=edb2dac&category=3&topic=19

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks!  Works like a champ!!

Its amazing how things work when you use the correct events and methods!!

Pete