private bool SelectConnection(DesignerDataConnection conn) { if (conn.IsConfigured) { foreach (DataConnectionItem item in this._connectionsComboBox.Items) { DesignerDataConnection designerDataConnection = item.DesignerDataConnection; if (designerDataConnection.IsConfigured && (designerDataConnection.Name == conn.Name)) { this._connectionsComboBox.SelectedItem = item; return(true); } } } else { foreach (DataConnectionItem item2 in this._connectionsComboBox.Items) { DesignerDataConnection connection2 = item2.DesignerDataConnection; if (!connection2.IsConfigured && SqlDataSourceDesigner.ConnectionsEqual(connection2, conn)) { this._connectionsComboBox.SelectedItem = item2; return(true); } } } return(false); }
public override bool OnNext() { if (!base.CheckValidProvider()) { return(false); } DesignerDataConnection dataConnection = this.DataConnection; if (!dataConnection.IsConfigured) { this._needsToPersistConnectionInfo = false; SqlDataSourceSaveConfiguredConnectionPanel nextPanel = base.NextPanel as SqlDataSourceSaveConfiguredConnectionPanel; if (nextPanel == null) { nextPanel = ((SqlDataSourceWizardForm)base.ParentWizard).GetSaveConfiguredConnectionPanel(); base.NextPanel = nextPanel; } if (!SqlDataSourceDesigner.ConnectionsEqual(dataConnection, nextPanel.CurrentConnection)) { nextPanel.SetConnectionInfo(dataConnection); } return(true); } this._needsToPersistConnectionInfo = true; return(base.OnNext()); }
public void SetQueries(DesignerDataConnection dataConnection, SqlDataSourceQuery selectQuery, SqlDataSourceQuery insertQuery, SqlDataSourceQuery updateQuery, SqlDataSourceQuery deleteQuery) { DesignerDataConnection connection = dataConnection; if (!SqlDataSourceDesigner.ConnectionsEqual(this._dataConnection, connection)) { this._dataConnection = connection; Cursor current = Cursor.Current; ArrayList storedProcedures = null; try { Cursor.Current = Cursors.WaitCursor; IDataEnvironment service = (IDataEnvironment)this._sqlDataSourceDesigner.Component.Site.GetService(typeof(IDataEnvironment)); if (service != null) { IDesignerDataSchema connectionSchema = service.GetConnectionSchema(this._dataConnection); if ((connectionSchema != null) && connectionSchema.SupportsSchemaClass(DesignerDataSchemaClass.StoredProcedures)) { ICollection schemaItems = connectionSchema.GetSchemaItems(DesignerDataSchemaClass.StoredProcedures); if ((schemaItems != null) && (schemaItems.Count > 0)) { storedProcedures = new ArrayList(); foreach (DesignerDataStoredProcedure procedure in schemaItems) { if (!procedure.Name.ToLowerInvariant().StartsWith("AspNet_".ToLowerInvariant(), StringComparison.Ordinal)) { storedProcedures.Add(procedure); } } } } } } catch (Exception exception) { UIServiceHelper.ShowError(base.ServiceProvider, exception, System.Design.SR.GetString("SqlDataSourceConnectionPanel_CouldNotGetConnectionSchema")); } finally { Cursor.Current = current; } this._selectCommandEditor.SetConnection(this._dataConnection); this._selectCommandEditor.SetStoredProcedures(storedProcedures); this._insertCommandEditor.SetConnection(this._dataConnection); this._insertCommandEditor.SetStoredProcedures(storedProcedures); this._updateCommandEditor.SetConnection(this._dataConnection); this._updateCommandEditor.SetStoredProcedures(storedProcedures); this._deleteCommandEditor.SetConnection(this._dataConnection); this._deleteCommandEditor.SetStoredProcedures(storedProcedures); this._selectCommandEditor.SetQuery(selectQuery); this._insertCommandEditor.SetQuery(insertQuery); this._updateCommandEditor.SetQuery(updateQuery); this._deleteCommandEditor.SetQuery(deleteQuery); } }
public void SetConnectionInfo(DesignerDataConnection dataConnection) { this._dataConnection = dataConnection; this.ResetUI(); bool saveConfiguredConnectionState = this._sqlDataSourceDesigner.SaveConfiguredConnectionState; DesignerDataConnection connection = new DesignerDataConnection(string.Empty, this._sqlDataSourceDesigner.ProviderName, this._sqlDataSourceDesigner.ConnectionString); if (SqlDataSourceDesigner.ConnectionsEqual(dataConnection, connection)) { if (!saveConfiguredConnectionState) { this._saveCheckBox.Checked = false; } if (this._nameTextBox.Text.Length == 0) { this._nameTextBox.Text = this.CreateDefaultConnectionName(); } } else { this._nameTextBox.Text = this.CreateDefaultConnectionName(); } }