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();
}
}
