// Set Database Recovery Mode /// <summary> /// The btn recovery mode_ click. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> protected void btnRecoveryMode_Click(object sender, EventArgs e) { using (var DBName = new YafDBConnManager()) { try { string dbRecoveryMode = string.Empty; if (this.RadioButtonList1.SelectedIndex == 0) { dbRecoveryMode = "FULL"; } if (this.RadioButtonList1.SelectedIndex == 1) { dbRecoveryMode = "SIMPLE"; } if (this.RadioButtonList1.SelectedIndex == 2) { dbRecoveryMode = "BULK_LOGGED"; } DBName.InfoMessage += connMan_InfoMessage; this.txtIndexStatistics.Text = DB.db_recovery_mode_warning(DBName); DB.db_recovery_mode(DBName, dbRecoveryMode); this.txtIndexStatistics.Text = "Database recovery mode was successfuly set to " + dbRecoveryMode; } catch (Exception error) { this.txtIndexStatistics.Text = "Something went wrong with this operation.The reported error is: " + error.Message; } } }
protected void btnReindex_Click(object sender, EventArgs e) { using (YafDBConnManager connMan = new YafDBConnManager()) { connMan.InfoMessage += new YafDBConnManager.YafDBConnInfoMessageEventHandler(connMan_InfoMessage); txtIndexStatistics.Text = DB.db_reindex_warning(connMan); DB.db_reindex(connMan); } }
protected void btnReindex_Click( object sender, EventArgs e ) { using ( YafDBConnManager connMan = new YafDBConnManager() ) { connMan.InfoMessage += new YafDBConnManager.YafDBConnInfoMessageEventHandler( connMan_InfoMessage ); txtIndexStatistics.Text = DB.db_reindex_warning(connMan); DB.db_reindex( connMan ); } }
// Reindexing Database /// <summary> /// The btn reindex_ click. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> protected void btnReindex_Click(object sender, EventArgs e) { using (var connMan = new YafDBConnManager()) { connMan.InfoMessage += connMan_InfoMessage; this.txtIndexStatistics.Text = DB.db_reindex_warning(connMan); DB.db_reindex(connMan); } }
protected void btnGetStats_Click(object sender, EventArgs e) { using (YafDBConnManager connMan = new YafDBConnManager()) { connMan.InfoMessage += new YafDBConnManager.YafDBConnInfoMessageEventHandler(connMan_InfoMessage); // connMan.DBConnection.FireInfoMessageEventOnUserErrors = true; txtIndexStatistics.Text = DB.db_getstats_warning(connMan); DB.db_getstats(connMan); } }
protected void btnGetStats_Click( object sender, EventArgs e ) { using ( YafDBConnManager connMan = new YafDBConnManager() ) { connMan.InfoMessage += new YafDBConnManager.YafDBConnInfoMessageEventHandler( connMan_InfoMessage ); // connMan.DBConnection.FireInfoMessageEventOnUserErrors = true; txtIndexStatistics.Text = DB.db_getstats_warning(connMan); DB.db_getstats( connMan ); } }
protected void btnRunQuery_Click(object sender, EventArgs e) { txtResult.Text = ""; ResultHolder.Visible = true; using (YafDBConnManager connMan = new YafDBConnManager()) { connMan.InfoMessage += new YafDBConnManager.YafDBConnInfoMessageEventHandler(connMan_InfoMessage); string sql = txtQuery.Text.Trim(); // connMan.DBConnection.FireInfoMessageEventOnUserErrors = true; sql = sql.Replace("{databaseOwner}", DBAccess.DatabaseOwner); sql = sql.Replace("{objectQualifier}", DBAccess.ObjectQualifier); txtResult.Text = DB.db_runsql(sql, connMan); } }
protected void btnRunQuery_Click( object sender, EventArgs e ) { txtResult.Text = ""; ResultHolder.Visible = true; using ( YafDBConnManager connMan = new YafDBConnManager() ) { connMan.InfoMessage += new YafDBConnManager.YafDBConnInfoMessageEventHandler( connMan_InfoMessage ); string sql = txtQuery.Text.Trim(); // connMan.DBConnection.FireInfoMessageEventOnUserErrors = true; sql = sql.Replace( "{databaseOwner}", DBAccess.DatabaseOwner ); sql = sql.Replace( "{objectQualifier}", DBAccess.ObjectQualifier ); txtResult.Text = DB.db_runsql( sql, connMan ); } }
/// <summary> /// The btn run query_ click. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> protected void btnRunQuery_Click(object sender, EventArgs e) { this.txtResult.Text = string.Empty; this.ResultHolder.Visible = true; using (var connMan = new YafDBConnManager()) { connMan.InfoMessage += this.connMan_InfoMessage; string sql = this.txtQuery.Text.Trim(); // connMan.DBConnection.FireInfoMessageEventOnUserErrors = true; sql = sql.Replace("{databaseOwner}", Config.DatabaseOwner); sql = sql.Replace("{objectQualifier}", Config.DatabaseObjectQualifier); this.txtResult.Text = DB.db_runsql(sql, connMan, this.chkRunInTransaction.Checked); } }
// Mod By Touradg (herman_herman) 2009/10/19 // Shrinking Database /// <summary> /// The btn shrink_ click. /// </summary> /// <param name="sender"> /// The sender. /// </param> /// <param name="e"> /// The e. /// </param> protected void btnShrink_Click(object sender, EventArgs e) { using (var DBName = new YafDBConnManager()) { try { DBName.InfoMessage += connMan_InfoMessage; this.txtIndexStatistics.Text = DB.db_shrink_warning(DBName); DB.db_shrink(DBName); this.txtIndexStatistics.Text = "Shrink operation was Successful.Your database size is now: " + DB.DBSize + "MB"; } catch (Exception error) { this.txtIndexStatistics.Text = "Something went wrong with operation.The reported error is: " + error.Message; } } }
void connMan_InfoMessage( object sender, YafDBConnManager.YafDBConnInfoMessageEventArgs e ) { txtIndexStatistics.Text = e.Message; }
void connMan_InfoMessage( object sender, YafDBConnManager.YafDBConnInfoMessageEventArgs e ) { txtResult.Text = "\r\n" + e.Message; }