public bool GoodDatabaseInstance(string SQLSrvrInstance, IntPtr WindowHandle) { ServerConnection SQLSrvrConnection = new ServerConnection(SQLSrvrInstance); SQLSrvrConnection.ServerInstance = SQLSrvrInstance; // Setup capture and execute to be able to display script SQLSrvrConnection.SqlExecutionModes = SqlExecutionModes.ExecuteAndCaptureSql; // Use Windows authentication SQLSrvrConnection.LoginSecure = true; // Go ahead and connect try { SQLSrvrConnection.Connect(); } catch (Exception ex) { ExceptionMessageBox emb = new ExceptionMessageBox(); emb.Message = ex; emb.Show(new WindowWrapper(WindowHandle)); return(false); } bool Connected = SQLSrvrConnection.InUse; SQLSrvrConnection.Disconnect(); return(Connected); }
private void ConnectButton_Click(object sender, EventArgs e) { try { Cursor.Current = Cursors.WaitCursor; sqlServer = new GeneralSqlServer(defaultDatabase); sqlServer.Connect(sqlConfig.ServerName); this.FillDatabases(); OptionsButton.Enabled = true; this.HideConnectPanel(sqlServer.Server.Name); CancelButton.Enabled = true; OnConnected(new EventArgs()); } catch (Exception ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } finally { Cursor.Current = Cursors.Default; } }
private void 更新并初始化数据UToolStripMenuItem_Click(object sender, EventArgs e) { try { Synchronize syncSub = new Synchronize(); // Disable the current form this.Enabled = false; syncSub.Show(this); syncSub.ReinitializeSubscriptionWithUpload(); } catch (Exception ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex, ExceptionMessageBoxButtons.OK); emb.Show(this); } finally { loadLastAgentSessionSummary(); // Enable the current form this.Enabled = true; } }
private void 只上传数据ToolStripMenuItem_Click(object sender, EventArgs e) { try { Synchronize syncSub = new Synchronize(); // Disable the current form this.Enabled = false; syncSub.Show(this); syncSub.SynchronizeSubscriptionUploadOnly(); syncWhenConnectedStatus.Visible = false; } catch (Exception ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex, ExceptionMessageBoxButtons.OK); emb.Show(this); } finally { // Enable the current form this.Enabled = true; } }
public static ExceptionMessageBoxDialogResult ShowExceptionMessageBox(IWin32Window owner, Exception ex) { //try //{ ExceptionMessageBoxDialogResult exceptionMessageBoxDialogResult; CustomException customEx = ex as CustomException; if (customEx != null) { CustomExceptionMessageBox customExceptionMessageBox = new CustomExceptionMessageBox(customEx); exceptionMessageBoxDialogResult = (ExceptionMessageBoxDialogResult)customExceptionMessageBox.ShowDialog(owner); } else { System.Data.Common.DbException dbException = ex as System.Data.Common.DbException; if (dbException != null && dbException.ErrorCode == -2146232060) ex = new Exception("Không thể lưu do trùng dữ liệu. Vui lòng kiểm tra lại."); ExceptionMessageBox exceptionMessageBox = new ExceptionMessageBox(ex); //exceptionMessageBox.ShowToolBar = false; exceptionMessageBoxDialogResult = (ExceptionMessageBoxDialogResult)exceptionMessageBox.Show(owner); } return exceptionMessageBoxDialogResult; //} //catch {}// Environment.Exit(0); return ExceptionMessageBoxDialogResult.None; } }
public virtual void StartWatching() { try { _log.Debug(string.Format("Started watching build status, poling interval: {0} seconds", Settings.PollInterval)); while (true) { GetBuildStatusAndFireEvents(); Thread.Sleep(Settings.PollInterval * 1000); } } catch (ThreadAbortException) { _log.Debug("Stopped watching build status (ThreadAbortException)"); StopWatching(); OnStoppedWatching(); } catch (TaskCanceledException) { _log.Debug("Stopped watching build status (TaskCanceledException)"); StopWatching(); OnStoppedWatching(); } catch (Exception ex) { _log.Error("uncaught exception in watcher", ex); StopWatching(); ExceptionMessageBox.Show(null, "Drat", "Error connecting to server", ex); } }
/// <summary> /// Select the second object to compare. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void objectBrowse2Button_Click(object sender, EventArgs e) { if (serverTextBox2.Text == null || serverTextBox2.Text.Length == 0) { ExceptionMessageBox emb = new ExceptionMessageBox(); emb.Text = Properties.Resources.SecondServerMustBeSpecified; emb.Show(this); return; } if (serverChanged2) { this.serverConn2 = new ServerConnection(this.serverTextBox2.Text); this.serverConn2.NonPooledConnection = false; this.serverConn2.LoginSecure = loginTextBox2.Text.Trim().Length == 0 ? true : false; if (!this.serverConn2.LoginSecure) { this.serverConn2.Login = loginTextBox2.Text; this.serverConn2.Password = passwordTextBox2.Text; } serverChanged2 = false; } this.objectBrowser = new SqlObjectBrowser(this.serverConn2); if (this.objectBrowser.Connected == true) { if (DialogResult.OK == this.objectBrowser.ShowDialog(this)) { this.urnTextBox2.Text = this.objectBrowser.Urn; } } }
private void ShowDatabases(bool selectDefault) { // Show the current databases on the server try { // Clear control DatabasesComboBox.Items.Clear(); // Limit the properties returned to just those that we use SqlServerSelection.SetDefaultInitFields(typeof(Database), new String[] { "Name", "IsSystemObject", "IsAccessible" }); // Add database objects to combobox; the default ToString // will display the database name foreach (Database db in SqlServerSelection.Databases) { if (db.IsSystemObject == false && db.IsAccessible == true) { DatabasesComboBox.Items.Add(db); } } if ((selectDefault == true) && (DatabasesComboBox.Items.Count > 0)) { DatabasesComboBox.SelectedIndex = 0; } } catch (SmoException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } }
public override void Generate(string wszInputFilePath, string bstrInputFileContents, string wszDefaultNamespace, out IntPtr rgbOutputFileContents, out int pcbOutput, IVsGeneratorProgress pGenerateProgress) { try { byte[] data = CodeGeneratorCustomTool.GenerateUnitTestCode(wszDefaultNamespace, wszInputFilePath); if (data == null) { rgbOutputFileContents = IntPtr.Zero; pcbOutput = 0; } else { rgbOutputFileContents = Marshal.AllocCoTaskMem(data.Length); Marshal.Copy(data, 0, rgbOutputFileContents, data.Length); pcbOutput = data.Length; } } catch (Exception e) { var applicationException = new ApplicationException("Unable to generate code", e); var messageBox = new ExceptionMessageBox(applicationException); messageBox.Show(null); throw; } }
private void GetServerList() { DataTable dt; // Set local server as default dt = SmoApplication.EnumAvailableSqlServers(false); if (dt.Rows.Count > 0) { // Load server names into combo box foreach (DataRow dr in dt.Rows) { ServerNamesComboBox.Items.Add(dr["Name"]); } // Default to this machine ServerNamesComboBox.SelectedIndex = ServerNamesComboBox.FindStringExact( System.Environment.MachineName); // If this machine is not a SQL server // then select the first server in the list if (ServerNamesComboBox.SelectedIndex < 0) { ServerNamesComboBox.SelectedIndex = 0; } } else { ExceptionMessageBox emb = new ExceptionMessageBox(); emb.Text = Properties.Resources.NoSqlServers; emb.Show(this); } }
public SqlObjectBrowser(ServerConnection serverConn) { InitializeComponent(); // Connect to SQL Server server = new Server(serverConn); try { server.ConnectionContext.Connect(); // In case connection succeeded we add the sql server node as root in object explorer (treeview) TreeNode tn = new TreeNode(); tn.Text = server.Name; tn.Tag = server.Urn; this.objUrn = server.Urn; objectBrowserTreeView.Nodes.Add(tn); AddDummyNode(tn); connected = true; } catch (ConnectionException) { ExceptionMessageBox emb = new ExceptionMessageBox(); emb.Text = Properties.Resources.ConnectionFailed; emb.Show(this); } catch (ApplicationException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } }
private void ListDatabaseSpace() { try { this.dataGridView1.Rows.Clear(); foreach (Database db in SqlServerSelection.Databases) { if (db.IsSystemObject == false) { if (db.LogFiles.Count > 0) { this.dataGridView1.Rows.Add(new object[] { db.Name, db.Size, db.SpaceAvailable / 1024.0, db.LogFiles[0].Size / 1024.0, db.LogFiles[0].UsedSpace / 1024.0 }); } else { this.dataGridView1.Rows.Add(new object[] { db.Name, db.Size, db.SpaceAvailable / 1024.0, 0.0, 0.0 }); } } } } catch (SmoException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } }
private void UpgradeThread() { try { byte[] hexFileData = File.ReadAllBytes(_firmwareFile.Text); using (var hexFileStream = new MemoryStream(hexFileData)) { SetStatus("Waiting for device to connect."); Program.SirenOfShameDevice.PerformFirmwareUpgrade(hexFileStream, UpdateProgress); SetStatus("Upgrade complete."); if (_onInstallFirmwareSuccess != null) { this.Invoke(() => _onInstallFirmwareSuccess()); } } } catch (Exception ex) { Log.Error("Error performing upgrade", ex); SetStatus("Error installing firmware"); ExceptionMessageBox.Show(this, "Error Performing Upgrade", "Error Performing Upgrade", ex); } finally { this.Invoke(() => { _begin.Enabled = true; }); } }
private void objectBrowserTreeView_AfterExpand(object sender, TreeViewEventArgs e) { // Remove dummy node e.Node.Nodes.RemoveAt(0); SqlSmoObject smoObj = null; Urn urnNode = (Urn)e.Node.Tag; try { smoObj = server.GetSmoObject(urnNode); AddCollections(e, smoObj); } catch (UnsupportedVersionException) { // Right now don't do anything... but you might change the // Icon so it will emphasize the version issue } catch (SmoException) { try { AddItemInCollection(e, server); } catch (Exception except) { ExceptionMessageBox emb = new ExceptionMessageBox(except); emb.Show(this); } } catch (ApplicationException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } }
public void OpenPort(string strCom) { _serialPort = new SerialPort(strCom, 19200, Parity.None, 8, StopBits.Two); try { _serialPort.Open(); _serialPort.RtsEnable = false; _serialPort.DataReceived += OnDataReceived; //serialPort.ErrorReceived += new SerialErrorReceivedEventHandler(OnErrorReceived); //serialPort.PinChanged += new SerialPinChangedEventHandler(OnSerialPinChanged); var buffer = new byte[1]; buffer[0] = 0x55; if (_serialPort.IsOpen) { _serialPort.Write(buffer, 0, buffer.Length); } Thread.Sleep(100); buffer[0] = 0xAA; if (_serialPort.IsOpen) { _serialPort.Write(buffer, 0, buffer.Length); } Thread.Sleep(500); } catch (Exception e) { ExceptionMessageBox.Show(e); } }
public void EditTag(string filename) { Mp3File mp3File = null; try { // create mp3 file wrapper; open it and read the tags mp3File = new Mp3File(filename); } catch (Exception e) { ExceptionMessageBox.Show(_form, e, "Error Reading Tag"); return; } // create dialog and give it the ID3v2 block for editing // this is a bit sneaky; it uses the edit dialog straight out of TagScanner.exe as if it was a dll. TagEditor.ID3AdapterEdit id3Edit = new TagEditor.ID3AdapterEdit(mp3File); if (id3Edit.ShowDialog() == System.Windows.Forms.DialogResult.OK) { try { using (new CursorKeeper(Cursors.WaitCursor)) { mp3File.Update(); } } catch (Exception e) { ExceptionMessageBox.Show(_form, e, "Error Writing Tag"); } } }
private void GetServices() { Cursor csr = null; ManagedComputer mc; ListViewItem ServiceListViewItem; try { csr = this.Cursor; // Save the old cursor this.Cursor = Cursors.WaitCursor; // Display the waiting cursor // Clear control ServicesListView.Items.Clear(); mc = new ManagedComputer(SqlServerSelection.Name); foreach (Service svc in mc.Services) { ServiceListViewItem = ServicesListView.Items.Add(svc.Name); ServiceListViewItem.SubItems.Add(svc.DisplayName); ServiceListViewItem.SubItems.Add(svc.ServiceState.ToString()); ServiceListViewItem.SubItems.Add(svc.StartMode.ToString()); ServiceListViewItem.SubItems.Add(svc.ServiceAccount); ServiceListViewItem.SubItems.Add(svc.State.ToString()); } } catch (SmoException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } finally { this.Cursor = csr; // Restore the original cursor } }
private static void HandleException(object sender, bool isTerminating, Exception exception) { ExceptionMessageBox emb = new ExceptionMessageBox(exception, ExceptionMessageBoxButtons.OK, ExceptionMessageBoxSymbol.Error); emb.Caption = "Unhandled Exception"; emb.Show(Program._form); }
public void ShowExceptionMessage() { try { // Do something that you don't expect to generate an exception. throw new ApplicationException(ExceptionMessage); } catch (ApplicationException ex) { // Define a new top-level error message. string str = "An Error has ocurred in while logging the Exception Information on System. " + Environment.NewLine + "Please contact support"; // Add the new top-level message to the handled exception. ApplicationException exTop = new ApplicationException(str, ex); ExceptionMessageBox box = new ExceptionMessageBox(exTop); box.Buttons = ExceptionMessageBoxButtons.OK; box.Caption = title; box.ShowCheckBox = false; box.ShowToolBar = true; box.Symbol = ExceptionMessageBoxSymbol.Stop; box.Show(this); this.Close(); } }
public static ExceptionMessageBoxDialogResult ShowExceptionMessageBox(IWin32Window owner, Exception ex) { //try //{ ExceptionMessageBoxDialogResult exceptionMessageBoxDialogResult; CustomException customEx = ex as CustomException; if (customEx != null) { CustomExceptionMessageBox customExceptionMessageBox = new CustomExceptionMessageBox(customEx); exceptionMessageBoxDialogResult = (ExceptionMessageBoxDialogResult)customExceptionMessageBox.ShowDialog(owner); } else { ExceptionMessageBox exceptionMessageBox = new ExceptionMessageBox(ex); //exceptionMessageBox.ShowToolBar = false; exceptionMessageBoxDialogResult = (ExceptionMessageBoxDialogResult)exceptionMessageBox.Show(owner); } return(exceptionMessageBoxDialogResult); //} //catch {}// Environment.Exit(0); return ExceptionMessageBoxDialogResult.None; } }
private IConfiguration NewObject(string classType, string caption, int height) { EditObject obj; IConfiguration config = null; try { ConfigurationPanel.EditObjectButton.Text = caption; Assembly a = Assembly.GetAssembly(this.GetType()); object[] args = new object[1]; args[0] = SqlConnectionControl.ServiceBroker; //Create a new instance of class type stored in classType. config = (IConfiguration)a.CreateInstance (classType, true, BindingFlags.CreateInstance, null, args, System.Globalization.CultureInfo.CurrentCulture, null); obj = ConfigurationPanel.AddObject("(New)", config); obj.Expand(height); obj.ButtonVisible = false; } catch (Exception ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } return(config); }
private void LoadButton_Click(object sender, RoutedEventArgs e) { this.IsEnabled = false; WebClient webClient = new WebClient(); webClient.DownloadStringCompleted += WebClient_DownloadStringCompleted; try { Uri uri = new Uri(URLTextBox.Text); webClient.DownloadStringAsync(uri); } catch (UriFormatException uriFormatEx) { ExceptionMessageBox.Show(this.Title, "The format of the URL " + $"{Environment.NewLine}{Environment.NewLine}{URLTextBox.Text}{Environment.NewLine}{Environment.NewLine}" + " is not correct.", uriFormatEx); } catch (Exception ex) { ExceptionMessageBox.Show(this.Title, "The following error occurred:", ex); } finally { webClient.Dispose(); this.IsEnabled = true; } }
public static void LoadRegexJob(String path) { TaskWindow taskWindow = new TaskWindow ( delegate(Object argument) { return(RegexHelper.Match(AppState.Current.Input)); }, path ) { Owner = App.MainWindow }; taskWindow.ShowDialog(); if (taskWindow.Exception == null) { RegexInput regexInput = taskWindow.Result as RegexInput; if (regexInput != null) { AppState.Current.Input = regexInput; AppState.Current.Update(path); } } else { ExceptionMessageBox.Show(App.MainWindow, App.Metadata.AssemblyTitle, "Invalid job file format.", taskWindow.Exception.InnerException); } }
public static void SaveRegexJob(String path) { TaskWindow taskWindow = new TaskWindow ( delegate(Object argument) { FileHelper.SaveRegexInput(argument.ToString(), AppState.Current.Input); return(null); }, path ) { Owner = App.MainWindow }; taskWindow.ShowDialog(); if (taskWindow.Exception == null) { AppState.Current.Update(path); } else { ExceptionMessageBox.Show(App.MainWindow, App.Metadata.AssemblyTitle, "Unexpected exception happened.", taskWindow.Exception.InnerException); } }
/// <summary> /// Used to create a custom app exception dialog. /// </summary> /// <param name="sender"><see cref="Form1.cmdApplicationExceptionDialog_Click"/>Calling form</param> /// <param name="ex">ApplicationException instance</param> /// <param name="title">Title for dialog</param> /// <returns>ExceptionMessageBoxDialogResult</returns> /// <remarks> /// https://docs.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.messagebox.exceptionmessagebox?view=sqlserver-2016 /// </remarks> public static ExceptionMessageBoxDialogResult AppExceptionDialog(Form sender, ApplicationException ex, string title = "Action failed. What do you want to do?") { var applicationException = new ApplicationException(title, ex) { Source = "Source" }; // Show the exception message box with three custom buttons. var box = new ExceptionMessageBox(applicationException) { Caption = "Karen's great application" }; // set the window caption/title // Set the names of the three custom buttons. box.SetButtonText("Skip", "Retry", "Stop Processing"); // Set the Retry button as the default. box.DefaultButton = ExceptionMessageBoxDefaultButton.Button2; box.Symbol = ExceptionMessageBoxSymbol.Question; box.Buttons = ExceptionMessageBoxButtons.Custom; box.Show(sender); return(box.CustomDialogResult); }
private void DependenciesTreeView_AfterSelect(object sender, TreeViewEventArgs e) { SqlSmoObject smoObject; Urn urn; ListViewItem item; Cursor csr = null; try { csr = this.Cursor; // Save the old cursor this.Cursor = Cursors.WaitCursor; // Display the waiting cursor // Get the Urn from the selected node urn = (Urn)(e.Node.Tag); // Clear the list this.PropertiesListView.Items.Clear(); // No Urn : we cannot display if (urn == null) { return; } // Instantiate the SMO object using the Urn smoObject = server.GetSmoObject(urn); // Initialize its properties smoObject.Initialize(true); // Now print each retrieved property in the ListView foreach (Property prop in smoObject.Properties) { if (prop.Retrieved == true) { item = new ListViewItem(prop.Name); if (prop.Value != null) { item.SubItems.Add(prop.Value.ToString()); } this.PropertiesListView.Items.Add(item); } } // Size it this.PropertiesListView.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); } catch (SmoException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } finally { // Restore the original cursor this.Cursor = csr; } }
static void OnUnhandledException(object sender, UnhandledExceptionEventArgs e) { var form = new ExceptionMessageBox(e.ExceptionObject as Exception); form.Caption = "Unexpected Error"; form.Text = "An unexpected error has occurred"; form.Show(null); }
private void OnStatementExecuted(object sender, StatementEventArgs args) { ExceptionMessageBox emb = new ExceptionMessageBox(); emb.Text = args.SqlStatement; emb.Show(this); }
private void mnuTellMeMore_Click(object sender, EventArgs e) { ExceptionMessageBox emb = new ExceptionMessageBox( Properties.Resources.TellMeMoreWebSync); emb.Symbol = ExceptionMessageBoxSymbol.Information; emb.Show(this); }
private void RefreshTables() { Cursor csr = null; Database database; try { csr = this.Cursor; // Save the old cursor this.Cursor = Cursors.WaitCursor; // Display the waiting cursor this.TableListView.BeginUpdate(); // Clear the list this.TableListView.Items.Clear(); // Get selected database from DatabaseComboBox database = (Database)(this.DatabasesComboBox.SelectedItem); // Set default initial fields for table database.Parent.SetDefaultInitFields(typeof(Table), "Name", "CreateDate", "RowCount", "DataSpaceUsed", "IsSystemObject"); // Get the updated list of tables database.Tables.Refresh(); // Iterate user Tables and add to ListView Using AddTableItem foreach (Table tbl in database.Tables) { if (tbl.IsSystemObject == false) { this.AddTableItem(tbl); } } // Resize columns this.TableListView.AutoResizeColumns( ColumnHeaderAutoResizeStyle.ColumnContent); // Select the first item if (this.TableListView.Items.Count > 0) { this.TableListView.Items[0].Selected = true; } } catch (SmoException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } finally { this.TableListView.EndUpdate(); // Restore the original cursor this.Cursor = csr; } }
private void ConnectToServer(string server) { try { Server srvr = new Server(server); srvr.ConnectionContext.ConnectTimeout = 5; srvr.ConnectionContext.Connect(); this.sqlServerSelection = srvr; } catch (ConnectionFailureException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); Cursor = Cursors.Default; this.sqlServerSelection = null; } this.serverVersionToolStripStatusLabel.Text = this.sqlServerSelection.Information.Version.ToString() + " " + this.sqlServerSelection.Information.Edition; this.SqlServerTreeView.Nodes.Clear(); // Add Server node TreeNode node = new TreeNode(this.sqlServerSelection.ConnectionContext.TrueName); node.Name = Properties.Resources.Server; root = node; node.Tag = this.sqlServerSelection; this.SqlServerTreeView.Nodes.Add(node); // Add Databases node node = new TreeNode(Properties.Resources.Databases); node.Name = Properties.Resources.Databases; node.Tag = this.sqlServerSelection.Databases; root.Nodes.Add(node); AddDummyNode(node); this.SqlServerTreeView.SelectedNode = root; // Optimizing code this.sqlServerSelection.SetDefaultInitFields(typeof(Database), "CreateDate", "IsSystemObject", "CompatibilityLevel"); this.sqlServerSelection.SetDefaultInitFields(typeof(Table), "CreateDate", "IsSystemObject"); this.sqlServerSelection.SetDefaultInitFields(typeof(Microsoft.SqlServer.Management.Smo.View), "CreateDate", "IsSystemObject"); this.sqlServerSelection.SetDefaultInitFields(typeof(StoredProcedure), "CreateDate", "IsSystemObject"); this.sqlServerSelection.SetDefaultInitFields(typeof(Column), true); }
private void runButton_Click(object sender, EventArgs e) { // Perform run on the connection // Connect to SQL Server Server server = new Server(serverConn); try { server.ConnectionContext.ExecuteNonQuery(collScript, ExecutionTypes.ContinueOnError); } catch (SmoException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } }
private void CreateStripButton_Click(object sender, EventArgs e) { if (this.ActiveEditObject != null) { try { this.ActiveEditObject.Configuration.Create(); this.outputTextBox.Text = this.ActiveEditObject.Configuration.SqlScript; this.SetStripButtonState(ObjectsSplitPanel.operations.Show); } catch (Exception ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } } }
private void AlterStripButton_Click(object sender, EventArgs e) { if (this.ActiveEditObject != null) { try { this.ActiveEditObject.Configuration.Alter(); this.outputTextBox.Text = this.ActiveEditObject.Configuration.SqlScript; this.outputDataGridView.AutoGenerateColumns = true; } catch (Exception ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } } }
private void AddTableButton_Click(object sender, System.EventArgs e) { Database db; Table tbl; Column col; Index idx; Default dflt; Cursor csr = null; try { csr = this.Cursor; // Save the old cursor this.Cursor = Cursors.WaitCursor; // Display the waiting cursor // Show the current tables for the selected database db = (Database)DatabasesComboBox.SelectedItem; if (db.Tables.Contains(TableNameTextBox.Text) == false) { // Create an empty string default dflt = db.Defaults["dfltEmptyString"]; if (dflt == null) { dflt = new Default(db, "dfltEmptyString"); dflt.TextHeader = "CREATE DEFAULT [dbo].[dfltEmptyString] AS "; dflt.TextBody = @"'';"; dflt.Create(); } // Create a new table object tbl = new Table(db, TableNameTextBox.Text, db.DefaultSchema); // Add the first column col = new Column(tbl, @"Column1", DataType.Int); tbl.Columns.Add(col); col.Nullable = false; col.Identity = true; col.IdentitySeed = 1; col.IdentityIncrement = 1; // Add the primary key index idx = new Index(tbl, @"PK_" + TableNameTextBox.Text); tbl.Indexes.Add(idx); idx.IndexedColumns.Add(new IndexedColumn(idx, col.Name)); idx.IsClustered = true; idx.IsUnique = true; idx.IndexKeyType = IndexKeyType.DriPrimaryKey; // Add the second column col = new Column(tbl, @"Column2", DataType.NVarChar(1024)); tbl.Columns.Add(col); col.DataType.MaximumLength = 1024; col.AddDefaultConstraint(null); // Use SQL Server default naming col.DefaultConstraint.Text = Properties.Resources.DefaultConstraintText; col.Nullable = false; // Add the third column col = new Column(tbl, @"Column3", DataType.DateTime); tbl.Columns.Add(col); col.Nullable = false; // Create the table tbl.Create(); // Refresh list and select the one we just created ShowTables(); // Clear selected items TablesComboBox.SelectedIndex = -1; // Find the table just created TablesComboBox.SelectedIndex = TablesComboBox.FindStringExact(tbl.ToString()); } else { ExceptionMessageBox emb = new ExceptionMessageBox(); emb.Text = string.Format(System.Globalization.CultureInfo.InvariantCulture, Properties.Resources.TableExists, TableNameTextBox.Text); emb.Show(this); } } catch (SmoException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } finally { this.Cursor = csr; // Restore the original cursor } }
private void RefreshService(Service svc) { // Update the service status field try { svc.Refresh(); ListViewItem ServiceListViewItem; ServiceListViewItem = ServicesListView.SelectedItems[0]; ServiceListViewItem.SubItems[2].Text = svc.ServiceState.ToString(); UpdateButtons(); } catch (SmoException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } }
private void DisplayIndexSizes() { Database db; Cursor csr = null; try { csr = this.Cursor; // Save the old cursor this.Cursor = Cursors.WaitCursor; // Display the waiting cursor db = (Database)DatabasesComboBox.SelectedItem; this.dataGridView1.Rows.Clear(); foreach (Table tbl in db.Tables) { if (tbl.IsSystemObject == false) { foreach (Index idx in tbl.Indexes) { if (idx.IndexKeyType != IndexKeyType.None) { continue; // Only show indexes } this.dataGridView1.Rows.Add(new object[] { tbl.ToString(), idx.Name, idx.SpaceUsed }); } } } } catch (SmoException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } finally { this.Cursor = csr; // Restore the original cursor } }
public void Draw(esriDrawPhase drawPhase, IDisplay display, ITrackCancel trackCancel) { switch (drawPhase) { case esriDrawPhase.esriDPGeography: if (Valid) { if (Visible) { try { var clipEnvelope = display.ClipEnvelope; // when loading from a file the active map doesn't exist yet // so just deal with it here. if (_map == null) { var mxdoc = (IMxDocument)_application.Document; _map = mxdoc.FocusMap; } Debug.WriteLine("Draw event"); var activeView = _map as IActiveView; Logger.Debug("Layer name: " + Name); if (activeView != null) { //_envelope = activeView.Extent; _envelope = clipEnvelope; Logger.Debug("Draw extent: xmin:" + _envelope.XMin + ", ymin:" + _envelope.YMin + ", xmax:" + _envelope.XMax + ", ymax:" + _envelope.YMax ); if (SpatialReference != null) { Logger.Debug("Layer spatial reference: " + SpatialReference.FactoryCode); } if (_map.SpatialReference != null) { Logger.Debug("Map spatial reference: " + _map.SpatialReference.FactoryCode); } var bruTileHelper = new BruTileHelper(_tileTimeOut); //_displayFilter.Transparency = (short)(255 - ((_transparency * 255) / 100)); //if (display.Filter == null) //{ // display.Filter = _displayFilter; //} var fileCache = CacheDirectory.GetFileCache(_cacheDir,_config,_enumBruTileLayer); bruTileHelper.Draw(_application.StatusBar.ProgressBar, activeView, fileCache, trackCancel, SpatialReference, ref _currentLevel, _tileSource, display); } } catch (Exception ex) { var mbox = new ExceptionMessageBox(ex); mbox.Show(null); } } // isVisible } // isValid break; case esriDrawPhase.esriDPAnnotation: break; } }
/// <summary> Exibe um DialogBox mostrando as informações sobre a exceção. </summary> /// <returns>Retorna um DialogResult da DialogBox</returns> public DialogResult ShowThreadExceptionDialog() { ApplicationException exTop = new ApplicationException(Detalhes, InnerException); exTop.Source = this.Message; ExceptionMessageBox box = new ExceptionMessageBox(exTop); box.Symbol = Icone; box.Buttons = Botoes; box.Caption = Titulo; box.ShowToolBar = true; return box.Show(null); }
private void ShowDatabases(bool selectDefault) { // Show the current databases on the server Cursor csr = null; try { csr = this.Cursor; // Save the old cursor this.Cursor = Cursors.WaitCursor; // Display the waiting cursor // Clear control DatabasesComboBox.Items.Clear(); // Limit the database properties returned to just those that we use SqlServerSelection.SetDefaultInitFields(typeof(Database), new String[] { "Name", "IsSystemObject", "IsAccessible" }); // Limit the table properties returned to just those that we use SqlServerSelection.SetDefaultInitFields(typeof(Table), new String[] { "Name", "CreateDate", "IsSystemObject" }); // Limit the column properties returned to just those that we use SqlServerSelection.SetDefaultInitFields(typeof(Column), new String[] {"Name", "DataType", "SystemType", "Length", "NumericPrecision", "NumericScale", "XmlSchemaNamespace", "XmlSchemaNamespaceSchema", "DataTypeSchema", "Nullable", "InPrimaryKey" }); // Add database objects to combobox; the default ToString will display the database name foreach (Database db in SqlServerSelection.Databases) { if (db.IsSystemObject == false && db.IsAccessible == true) { DatabasesComboBox.Items.Add(db); } } if ((selectDefault == true) && (DatabasesComboBox.Items.Count > 0)) { DatabasesComboBox.SelectedIndex = 0; } } catch (SmoException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } finally { this.Cursor = csr; // Restore the original cursor } }
private void ResumeButton_Click(System.Object sender, System.EventArgs e) { // Resume a paused service Cursor csr = null; Service svc; try { csr = this.Cursor; // Save the old cursor this.Cursor = Cursors.WaitCursor; // Display the waiting cursor svc = GetSelectedService(); if (svc != null) { if (svc.ServiceState == ServiceState.Paused) { sbrStatus.Text = Properties.Resources.Resuming; sbrStatus.Refresh(); svc.Resume(); } // Wait for service state to change WaitServiceStateChange(svc, ServiceState.Running); RefreshService(svc); sbrStatus.Text = Properties.Resources.Ready; } } catch (SmoException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } finally { this.Cursor = csr; // Restore the original cursor } }
private void DropStripButton_Click(object sender, EventArgs e) { if (this.ActiveEditObject != null) { try { if (MessageBox.Show ("Drop this object?", "Drop Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) == DialogResult.OK) { this.ActiveEditObject.Configuration.Drop(); this.SetStripButtonState(ObjectsSplitPanel.operations.Drop); this.RemoveAllObjects(); } } catch (Exception ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } } }
private IConfiguration NewObject(string classType, string caption, int height) { EditObject obj; IConfiguration config = null; try { ConfigurationPanel.EditObjectButton.Text = caption; Assembly a = Assembly.GetAssembly(this.GetType()); object[] args = new object[1]; args[0] = SqlConnectionControl.ServiceBroker; //Create a new instance of class type stored in classType. config = (IConfiguration)a.CreateInstance (classType, true, BindingFlags.CreateInstance, null, args, System.Globalization.CultureInfo.CurrentCulture, null); obj = ConfigurationPanel.AddObject("(New)", config); obj.Expand(height); obj.ButtonVisible = false; } catch (Exception ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } return config; }
private void exportToolStripMenuItem_Click(object sender, EventArgs e) { if (this.ActiveEditObject != null) { try { Cursor.Current = Cursors.WaitCursor; this.outputTextBox.Text = this.ActiveEditObject.Configuration.Export(String.Empty); DataSet ds = this.ActiveEditObject.Configuration.Query(); if (ds != null) this.outputDataGridView.DataSource = ds.Tables[0]; } catch (Exception ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } finally { Cursor.Current = Cursors.Default; } } }
private void QueryStripButton_Click(object sender, EventArgs e) { if (this.ActiveEditObject != null) { try { this.QueryObject(this.ActiveEditObject.Configuration); } catch (Exception ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } } }
private void DeleteTableButton_Click(object sender, System.EventArgs e) { Database db; Table tbl; Cursor csr = null; try { csr = this.Cursor; // Save the old cursor this.Cursor = Cursors.WaitCursor; // Display the waiting cursor // Show the current tables for the selected database db = (Database)DatabasesComboBox.SelectedItem; if (TablesComboBox.Items.Count > 0) { tbl = db.Tables[((Table)TablesComboBox.SelectedItem).Name, ((Table)TablesComboBox.SelectedItem).Schema]; if (tbl != null) { // Are you sure? Default to No to avoid accidents if (System.Windows.Forms.MessageBox.Show(this, string.Format( System.Globalization.CultureInfo.InvariantCulture, Properties.Resources.ReallyDrop, tbl.ToString()), this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2, 0) == DialogResult.No) { return; } tbl.Drop(); } // Refresh list and select first entry ShowTables(); if (TablesComboBox.Items.Count > 0) { TablesComboBox.SelectedIndex = 0; } } } catch (SmoException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } finally { this.Cursor = csr; // Restore the original cursor } }
private void ShowColumns() { Cursor csr = null; ListViewItem ColumnListViewItem; Table tbl; try { csr = this.Cursor; // Save the old cursor this.Cursor = Cursors.WaitCursor; // Display the waiting cursor // Delay rendering until after list filled ColumnsListView.BeginUpdate(); // Clear the columns list ColumnsListView.Items.Clear(); // Show the current columns for the selected table if (TablesComboBox.SelectedIndex >= 0) { // Get the selected table object tbl = (Table)TablesComboBox.SelectedItem; // Iterate through all the columns to fill list foreach (Column col in tbl.Columns) { ColumnListViewItem = ColumnsListView.Items.Add(col.Name); ColumnListViewItem.SubItems.Add(col.DataType.Name); ColumnListViewItem.SubItems.Add(col.DataType. MaximumLength.ToString( System.Globalization.CultureInfo.InvariantCulture)); ColumnListViewItem.SubItems.Add( col.Nullable.ToString()); ColumnListViewItem.SubItems.Add( col.InPrimaryKey.ToString()); } } // Now we render the listview ColumnsListView.EndUpdate(); UpdateButtons(); } catch (SmoException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } finally { this.Cursor = csr; // Restore the original cursor } }
private void ShowTables() { Database db; Cursor csr = null; try { csr = this.Cursor; // Save the old cursor this.Cursor = Cursors.WaitCursor; // Display the waiting cursor // Clear the tables list TablesComboBox.Items.Clear(); // Show the current tables for the selected database if (DatabasesComboBox.SelectedIndex >= 0) { db = (Database)DatabasesComboBox.SelectedItem; foreach (Table tbl in db.Tables) { if (tbl.IsSystemObject == false) { TablesComboBox.Items.Add(tbl); } } // Select the first item in the list if (TablesComboBox.Items.Count > 0) { TablesComboBox.SelectedIndex = 0; } else { // Clear the table detail list ColumnsListView.Items.Clear(); } } UpdateButtons(); } catch (SmoException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); } finally { this.Cursor = csr; // Restore the original cursor } }
private void WebSyncOptions_Load(object sender, EventArgs e) { passwordTextBox.Text = string.Empty; try { subscriberConn = new ServerConnection(subscriberServer); subscriberConn.Connect(); mergePullSub = new MergePullSubscription(subscriptionDatabase, publisherServer, publicationDatabase, publicationName, subscriberConn); mergePullSub.Load(); if (mergePullSub.UseWebSynchronization) { enableWebSyncChkBox.Checked = true; useWebSync = true; } if (string.IsNullOrEmpty(mergePullSub.InternetUrl) == false) { webSyncUrlTexBox.Text = mergePullSub.InternetUrl; } else { webSyncUrlTexBox.Text = webSynchronizationUrl; } if (string.IsNullOrEmpty(mergePullSub.InternetLogin) == false) { userNameTextBox.Text = mergePullSub.InternetLogin; } else { if (Environment.UserDomainName.Length != 0) { userNameTextBox.Text = Environment.UserDomainName + @"\" + Environment.UserName; } else { userNameTextBox.Text = Environment.UserName; } } if (mergePullSub.UseWebSynchronization == false) { userNameTextBox.Enabled = false; passwordTextBox.Enabled = false; } } catch (Exception ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); this.Close(); } }
private void 重新初始化数据RToolStripMenuItem_Click(object sender, EventArgs e) { try { Synchronize syncSub = new Synchronize(); // Disable the current form this.Enabled = false; syncSub.Show(this); syncSub.ReinitializeSubscription(); } catch (Exception ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex, ExceptionMessageBoxButtons.OK); emb.Show(this); } finally { loadLastAgentSessionSummary(); // Enable the current form this.Enabled = true; } }
private void okButton_Click(object sender, EventArgs e) { if (enableWebSyncChkBox.Checked == true && (string.IsNullOrEmpty(userNameTextBox.Text) == true || string.IsNullOrEmpty(passwordTextBox.Text) == true || string.IsNullOrEmpty(webSyncUrlTexBox.Text) == true)) { ExceptionMessageBox emb = new ExceptionMessageBox( Properties.Resources.ExceptionFormValidation); emb.Show(this); return; } else { if (enableWebSyncChkBox.Checked) { mergePullSub.UseWebSynchronization = true; mergePullSub.InternetLogin = userNameTextBox.Text; mergePullSub.InternetPassword = passwordTextBox.Text; mergePullSub.InternetUrl = webSyncUrlTexBox.Text; useWebSync = true; } else { mergePullSub.UseWebSynchronization = false; mergePullSub.InternetLogin = string.Empty; mergePullSub.InternetPassword = string.Empty; mergePullSub.InternetUrl = string.Empty; useWebSync = false; } mergePullSub.CommitPropertyChanges(); mergePullSub.Refresh(); subscriberConn.Disconnect(); this.Close(); } }
private ConnectedState GetConnectionState() { SelectQuery wmiQuery; ManagementObjectSearcher searcher; bool isConnected; try { // Query the WMI provider to determine if we are connected. wmiQuery = new SelectQuery("SELECT * FROM Win32_NetworkAdapter"); searcher = new ManagementObjectSearcher(wmiQuery); // Assume that we are not connected. isConnected = false; // Check the results for a NetConnectionStatus of 2 (connected). foreach (ManagementObject result in searcher.Get()) { if (Convert.ToInt32(result["NetConnectionStatus"], System.Globalization.CultureInfo.InvariantCulture) == 2) { isConnected = true; } } if (isConnected) { return ConnectedState.Connected; } else { return ConnectedState.Disconnected; } } catch (Exception ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex); emb.Show(this); return ConnectedState.Disconnected; } }
private void showSyncDialog() { try { Synchronize syncSub = new Synchronize(); // Disable the current form this.Enabled = false; syncSub.Show(this); // Check that the subscription exists. syncSub.CheckSubscription(); // Disable upload only if Web synchronization is enabled. if (syncSub.UseWebSynchronization) { mnuSynchronizeOnlyUploadData.Enabled = false; } } catch (SqlException ex) { ExceptionMessageBox emb = new ExceptionMessageBox( Properties.Resources.ExceptionVerifySqlServerRunning, Properties.Resources.ExceptionSqlServerError, ExceptionMessageBoxButtons.OK); emb.InnerException = ex; emb.Show(this); // Shutdown the application because we can't continue. Application.Exit(); } catch (ApplicationException ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex, ExceptionMessageBoxButtons.OK); emb.Show(this); // Shutdown the application because we can't continue. Application.Exit(); } catch (Exception ex) { ExceptionMessageBox emb = new ExceptionMessageBox(ex, ExceptionMessageBoxButtons.OK); emb.Show(this); // Shutdown the application because we can't continue. Application.Exit(); } catch { ExceptionMessageBox emb = new ExceptionMessageBox(@"CATASTROPHIC FAILURE!", @"CLOSING APPLICATION"); emb.Show(this); // Shutdown the application because we can't continue. Application.Exit(); } finally { // Enable the current form this.Enabled = true; } }
public static void LoadTextDocument(String path) { TaskWindow taskWindow = new TaskWindow ( delegate(Object argument) { // Use Encoding.Default to eliminate incorrect characters return(File.ReadAllText(argument.ToString(), Encoding.Default)); }, path ) { Owner = App.MainWindow }; taskWindow.ShowDialog(); if (taskWindow.Exception == null) { String text = taskWindow.Result as String; if (text != null) { AppState.Current.Input.Text = text; } } else { ExceptionMessageBox.Show(App.MainWindow, App.Metadata.AssemblyTitle, "Invalid job file format.", taskWindow.Exception.InnerException); } }