Click here to Skip to main content
15,895,471 members
Articles / Web Development / XHTML

SQL Simple Utilities

Rate me:
Please Sign up or sign in to vote.
4.68/5 (13 votes)
22 Sep 2016CPOL15 min read 35.7K   1.8K   32  
This project provides utilities for SQL server, such as executing a list of SQL scripts, exporting data to an SQL script, and displaying relationships between records.
<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _
Partial Class FormExportToScript
    Inherits System.Windows.Forms.Form

    'Form overrides dispose to clean up the component list.
    <System.Diagnostics.DebuggerNonUserCode()> _
    Protected Overrides Sub Dispose(ByVal disposing As Boolean)
        Try
            If disposing AndAlso components IsNot Nothing Then
                components.Dispose()
            End If
        Finally
            MyBase.Dispose(disposing)
        End Try
    End Sub

    'Required by the Windows Form Designer
    Private components As System.ComponentModel.IContainer

    'NOTE: The following procedure is required by the Windows Form Designer
    'It can be modified using the Windows Form Designer.  
    'Do not modify it using the code editor.
    '<System.Diagnostics.DebuggerStepThrough()> _
    Private Sub InitializeComponent()
        Me.components = New System.ComponentModel.Container()
        Dim resources As System.ComponentModel.ComponentResourceManager = New System.ComponentModel.ComponentResourceManager(GetType(FormExportToScript))
        Me.TabPageConnection = New System.Windows.Forms.TabPage()
        Me.NumericUpDownMaxRecords = New System.Windows.Forms.NumericUpDown()
        Me.Label1 = New System.Windows.Forms.Label()
        Me.CtrlConnection1 = New SqlSimpleUtilities.ctrlConnection()
        Me.TabPageExecution = New System.Windows.Forms.TabPage()
        Me.SplitContainer1 = New System.Windows.Forms.SplitContainer()
        Me.SplitContainer2 = New System.Windows.Forms.SplitContainer()
        Me.TextBoxSQLStatement = New System.Windows.Forms.TextBox()
        Me.PanelSQLStatementLabel = New System.Windows.Forms.Panel()
        Me.LabelSQLStatement = New System.Windows.Forms.Label()
        Me.SplitContainer3 = New System.Windows.Forms.SplitContainer()
        Me.PanelTablesList = New System.Windows.Forms.Panel()
        Me.ListBox1 = New System.Windows.Forms.ListBox()
        Me.PanelTablesLabel = New System.Windows.Forms.Panel()
        Me.LabelTables = New System.Windows.Forms.Label()
        Me.SplitContainer4 = New System.Windows.Forms.SplitContainer()
        Me.DataGridView1 = New System.Windows.Forms.DataGridView()
        Me.ColumnParentTable = New System.Windows.Forms.DataGridViewTextBoxColumn()
        Me.ColumnParentColumn = New System.Windows.Forms.DataGridViewTextBoxColumn()
        Me.ColumnChildTable = New System.Windows.Forms.DataGridViewTextBoxColumn()
        Me.ColumnChildColumn = New System.Windows.Forms.DataGridViewTextBoxColumn()
        Me.ColumnUnique = New System.Windows.Forms.DataGridViewComboBoxColumn()
        Me.ContextMenuStrip1 = New System.Windows.Forms.ContextMenuStrip(Me.components)
        Me.ToolStripMenuItemDelete = New System.Windows.Forms.ToolStripMenuItem()
        Me.PanelForeignKeysGridLabel = New System.Windows.Forms.Panel()
        Me.LabelForeignKeysGrid = New System.Windows.Forms.Label()
        Me.TreeView1 = New System.Windows.Forms.TreeView()
        Me.PanelForeignKeysTreeLabel = New System.Windows.Forms.Panel()
        Me.LabelForeignKeysTree = New System.Windows.Forms.Label()
        Me.PanelScriptText = New System.Windows.Forms.Panel()
        Me.PanelTablesProcessingListView = New System.Windows.Forms.Panel()
        Me.ListView1 = New System.Windows.Forms.ListView()
        Me.ColumnHeaderName = CType(New System.Windows.Forms.ColumnHeader(), System.Windows.Forms.ColumnHeader)
        Me.ColumnHeaderOrder = CType(New System.Windows.Forms.ColumnHeader(), System.Windows.Forms.ColumnHeader)
        Me.ImageList1 = New System.Windows.Forms.ImageList(Me.components)
        Me.PanelTablesProcessingLabel = New System.Windows.Forms.Panel()
        Me.LabelTablesProcessing = New System.Windows.Forms.Label()
        Me.PanelScriptLabel = New System.Windows.Forms.Panel()
        Me.ButtonScriptFile = New System.Windows.Forms.Button()
        Me.TextBoxScriptFile = New System.Windows.Forms.TextBox()
        Me.LabelScript = New System.Windows.Forms.Label()
        Me.TabControl1 = New System.Windows.Forms.TabControl()
        Me.ToolStripButtonRun = New System.Windows.Forms.ToolStripButton()
        Me.ToolStripExecution = New System.Windows.Forms.ToolStrip()
        Me.ToolStripButtonPrepare = New System.Windows.Forms.ToolStripButton()
        Me.ToolStripButtonPause = New System.Windows.Forms.ToolStripButton()
        Me.ToolStripButtonCancel = New System.Windows.Forms.ToolStripButton()
        Me.ToolStripStatusLabel = New System.Windows.Forms.ToolStripStatusLabel()
        Me.StatusStrip1 = New System.Windows.Forms.StatusStrip()
        Me.ToolStripProgressBar1 = New System.Windows.Forms.ToolStripProgressBar()
        Me.Timer1 = New System.Windows.Forms.Timer(Me.components)
        Me.MenuStrip1 = New System.Windows.Forms.MenuStrip()
        Me.FileMenu = New System.Windows.Forms.ToolStripMenuItem()
        Me.ToolStripMenuItemExit = New System.Windows.Forms.ToolStripMenuItem()
        Me.ErrorProvider1 = New System.Windows.Forms.ErrorProvider(Me.components)
        Me.Panel1 = New System.Windows.Forms.Panel()
        Me.TabPageConnection.SuspendLayout()
        CType(Me.NumericUpDownMaxRecords, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.TabPageExecution.SuspendLayout()
        CType(Me.SplitContainer1, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.SplitContainer1.Panel1.SuspendLayout()
        Me.SplitContainer1.Panel2.SuspendLayout()
        Me.SplitContainer1.SuspendLayout()
        CType(Me.SplitContainer2, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.SplitContainer2.Panel1.SuspendLayout()
        Me.SplitContainer2.Panel2.SuspendLayout()
        Me.SplitContainer2.SuspendLayout()
        Me.PanelSQLStatementLabel.SuspendLayout()
        CType(Me.SplitContainer3, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.SplitContainer3.Panel1.SuspendLayout()
        Me.SplitContainer3.Panel2.SuspendLayout()
        Me.SplitContainer3.SuspendLayout()
        Me.PanelTablesList.SuspendLayout()
        Me.PanelTablesLabel.SuspendLayout()
        CType(Me.SplitContainer4, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.SplitContainer4.Panel1.SuspendLayout()
        Me.SplitContainer4.Panel2.SuspendLayout()
        Me.SplitContainer4.SuspendLayout()
        CType(Me.DataGridView1, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.ContextMenuStrip1.SuspendLayout()
        Me.PanelForeignKeysGridLabel.SuspendLayout()
        Me.PanelForeignKeysTreeLabel.SuspendLayout()
        Me.PanelScriptText.SuspendLayout()
        Me.PanelTablesProcessingListView.SuspendLayout()
        Me.PanelTablesProcessingLabel.SuspendLayout()
        Me.PanelScriptLabel.SuspendLayout()
        Me.TabControl1.SuspendLayout()
        Me.ToolStripExecution.SuspendLayout()
        Me.StatusStrip1.SuspendLayout()
        Me.MenuStrip1.SuspendLayout()
        CType(Me.ErrorProvider1, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.Panel1.SuspendLayout()
        Me.SuspendLayout()
        '
        'TabPageConnection
        '
        Me.TabPageConnection.Controls.Add(Me.NumericUpDownMaxRecords)
        Me.TabPageConnection.Controls.Add(Me.Label1)
        Me.TabPageConnection.Controls.Add(Me.CtrlConnection1)
        Me.TabPageConnection.Location = New System.Drawing.Point(4, 22)
        Me.TabPageConnection.Name = "TabPageConnection"
        Me.TabPageConnection.Padding = New System.Windows.Forms.Padding(3)
        Me.TabPageConnection.Size = New System.Drawing.Size(752, 545)
        Me.TabPageConnection.TabIndex = 1
        Me.TabPageConnection.Text = "Connection"
        Me.TabPageConnection.UseVisualStyleBackColor = True
        '
        'NumericUpDownMaxRecords
        '
        Me.NumericUpDownMaxRecords.Location = New System.Drawing.Point(134, 113)
        Me.NumericUpDownMaxRecords.Name = "NumericUpDownMaxRecords"
        Me.NumericUpDownMaxRecords.Size = New System.Drawing.Size(172, 20)
        Me.NumericUpDownMaxRecords.TabIndex = 24
        '
        'Label1
        '
        Me.Label1.AutoSize = True
        Me.Label1.Location = New System.Drawing.Point(24, 115)
        Me.Label1.Name = "Label1"
        Me.Label1.Size = New System.Drawing.Size(89, 13)
        Me.Label1.TabIndex = 23
        Me.Label1.Text = "Maximum records"
        '
        'CtrlConnection1
        '
        Me.CtrlConnection1.Location = New System.Drawing.Point(17, 3)
        Me.CtrlConnection1.Name = "CtrlConnection1"
        Me.CtrlConnection1.Size = New System.Drawing.Size(330, 103)
        Me.CtrlConnection1.TabIndex = 22
        '
        'TabPageExecution
        '
        Me.TabPageExecution.Controls.Add(Me.SplitContainer1)
        Me.TabPageExecution.Location = New System.Drawing.Point(4, 22)
        Me.TabPageExecution.Name = "TabPageExecution"
        Me.TabPageExecution.Padding = New System.Windows.Forms.Padding(3)
        Me.TabPageExecution.Size = New System.Drawing.Size(752, 545)
        Me.TabPageExecution.TabIndex = 0
        Me.TabPageExecution.Text = "Execution"
        Me.TabPageExecution.UseVisualStyleBackColor = True
        '
        'SplitContainer1
        '
        Me.SplitContainer1.Dock = System.Windows.Forms.DockStyle.Fill
        Me.SplitContainer1.Location = New System.Drawing.Point(3, 3)
        Me.SplitContainer1.Name = "SplitContainer1"
        '
        'SplitContainer1.Panel1
        '
        Me.SplitContainer1.Panel1.Controls.Add(Me.SplitContainer2)
        '
        'SplitContainer1.Panel2
        '
        Me.SplitContainer1.Panel2.Controls.Add(Me.PanelScriptText)
        Me.SplitContainer1.Panel2.Controls.Add(Me.PanelScriptLabel)
        Me.SplitContainer1.Size = New System.Drawing.Size(746, 539)
        Me.SplitContainer1.SplitterDistance = 393
        Me.SplitContainer1.TabIndex = 50
        '
        'SplitContainer2
        '
        Me.SplitContainer2.Dock = System.Windows.Forms.DockStyle.Fill
        Me.SplitContainer2.Location = New System.Drawing.Point(0, 0)
        Me.SplitContainer2.Name = "SplitContainer2"
        Me.SplitContainer2.Orientation = System.Windows.Forms.Orientation.Horizontal
        '
        'SplitContainer2.Panel1
        '
        Me.SplitContainer2.Panel1.Controls.Add(Me.TextBoxSQLStatement)
        Me.SplitContainer2.Panel1.Controls.Add(Me.PanelSQLStatementLabel)
        '
        'SplitContainer2.Panel2
        '
        Me.SplitContainer2.Panel2.Controls.Add(Me.SplitContainer3)
        Me.SplitContainer2.Size = New System.Drawing.Size(393, 539)
        Me.SplitContainer2.SplitterDistance = 91
        Me.SplitContainer2.TabIndex = 64
        '
        'TextBoxSQLStatement
        '
        Me.TextBoxSQLStatement.Dock = System.Windows.Forms.DockStyle.Fill
        Me.TextBoxSQLStatement.Location = New System.Drawing.Point(0, 23)
        Me.TextBoxSQLStatement.Multiline = True
        Me.TextBoxSQLStatement.Name = "TextBoxSQLStatement"
        Me.TextBoxSQLStatement.ScrollBars = System.Windows.Forms.ScrollBars.Both
        Me.TextBoxSQLStatement.Size = New System.Drawing.Size(393, 68)
        Me.TextBoxSQLStatement.TabIndex = 2
        '
        'PanelSQLStatementLabel
        '
        Me.PanelSQLStatementLabel.Controls.Add(Me.LabelSQLStatement)
        Me.PanelSQLStatementLabel.Dock = System.Windows.Forms.DockStyle.Top
        Me.PanelSQLStatementLabel.Location = New System.Drawing.Point(0, 0)
        Me.PanelSQLStatementLabel.Name = "PanelSQLStatementLabel"
        Me.PanelSQLStatementLabel.Size = New System.Drawing.Size(393, 23)
        Me.PanelSQLStatementLabel.TabIndex = 1
        '
        'LabelSQLStatement
        '
        Me.LabelSQLStatement.AutoSize = True
        Me.LabelSQLStatement.Location = New System.Drawing.Point(5, 3)
        Me.LabelSQLStatement.Name = "LabelSQLStatement"
        Me.LabelSQLStatement.Size = New System.Drawing.Size(119, 13)
        Me.LabelSQLStatement.TabIndex = 0
        Me.LabelSQLStatement.Text = "Optional SQL statement"
        '
        'SplitContainer3
        '
        Me.SplitContainer3.Dock = System.Windows.Forms.DockStyle.Fill
        Me.SplitContainer3.Location = New System.Drawing.Point(0, 0)
        Me.SplitContainer3.Name = "SplitContainer3"
        Me.SplitContainer3.Orientation = System.Windows.Forms.Orientation.Horizontal
        '
        'SplitContainer3.Panel1
        '
        Me.SplitContainer3.Panel1.Controls.Add(Me.PanelTablesList)
        Me.SplitContainer3.Panel1.Controls.Add(Me.PanelTablesLabel)
        '
        'SplitContainer3.Panel2
        '
        Me.SplitContainer3.Panel2.Controls.Add(Me.SplitContainer4)
        Me.SplitContainer3.Size = New System.Drawing.Size(393, 444)
        Me.SplitContainer3.SplitterDistance = 99
        Me.SplitContainer3.TabIndex = 44
        '
        'PanelTablesList
        '
        Me.PanelTablesList.Controls.Add(Me.ListBox1)
        Me.PanelTablesList.Dock = System.Windows.Forms.DockStyle.Fill
        Me.PanelTablesList.Location = New System.Drawing.Point(0, 20)
        Me.PanelTablesList.Name = "PanelTablesList"
        Me.PanelTablesList.Size = New System.Drawing.Size(393, 79)
        Me.PanelTablesList.TabIndex = 65
        '
        'ListBox1
        '
        Me.ListBox1.Dock = System.Windows.Forms.DockStyle.Fill
        Me.ListBox1.FormattingEnabled = True
        Me.ListBox1.Location = New System.Drawing.Point(0, 0)
        Me.ListBox1.Name = "ListBox1"
        Me.ListBox1.SelectionMode = System.Windows.Forms.SelectionMode.MultiExtended
        Me.ListBox1.Size = New System.Drawing.Size(393, 79)
        Me.ListBox1.TabIndex = 63
        '
        'PanelTablesLabel
        '
        Me.PanelTablesLabel.Controls.Add(Me.LabelTables)
        Me.PanelTablesLabel.Dock = System.Windows.Forms.DockStyle.Top
        Me.PanelTablesLabel.Location = New System.Drawing.Point(0, 0)
        Me.PanelTablesLabel.Name = "PanelTablesLabel"
        Me.PanelTablesLabel.Size = New System.Drawing.Size(393, 20)
        Me.PanelTablesLabel.TabIndex = 64
        '
        'LabelTables
        '
        Me.LabelTables.AutoSize = True
        Me.LabelTables.Location = New System.Drawing.Point(3, 3)
        Me.LabelTables.Name = "LabelTables"
        Me.LabelTables.Size = New System.Drawing.Size(83, 13)
        Me.LabelTables.TabIndex = 0
        Me.LabelTables.Text = "Tables to export"
        '
        'SplitContainer4
        '
        Me.SplitContainer4.Dock = System.Windows.Forms.DockStyle.Fill
        Me.SplitContainer4.Location = New System.Drawing.Point(0, 0)
        Me.SplitContainer4.Name = "SplitContainer4"
        Me.SplitContainer4.Orientation = System.Windows.Forms.Orientation.Horizontal
        '
        'SplitContainer4.Panel1
        '
        Me.SplitContainer4.Panel1.Controls.Add(Me.DataGridView1)
        Me.SplitContainer4.Panel1.Controls.Add(Me.PanelForeignKeysGridLabel)
        '
        'SplitContainer4.Panel2
        '
        Me.SplitContainer4.Panel2.Controls.Add(Me.TreeView1)
        Me.SplitContainer4.Panel2.Controls.Add(Me.PanelForeignKeysTreeLabel)
        Me.SplitContainer4.Size = New System.Drawing.Size(393, 341)
        Me.SplitContainer4.SplitterDistance = 185
        Me.SplitContainer4.TabIndex = 70
        '
        'DataGridView1
        '
        Me.DataGridView1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D
        Me.DataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize
        Me.DataGridView1.Columns.AddRange(New System.Windows.Forms.DataGridViewColumn() {Me.ColumnParentTable, Me.ColumnParentColumn, Me.ColumnChildTable, Me.ColumnChildColumn, Me.ColumnUnique})
        Me.DataGridView1.ContextMenuStrip = Me.ContextMenuStrip1
        Me.DataGridView1.Dock = System.Windows.Forms.DockStyle.Fill
        Me.DataGridView1.Location = New System.Drawing.Point(0, 20)
        Me.DataGridView1.Margin = New System.Windows.Forms.Padding(0)
        Me.DataGridView1.Name = "DataGridView1"
        Me.DataGridView1.RowHeadersWidth = 15
        Me.DataGridView1.Size = New System.Drawing.Size(393, 165)
        Me.DataGridView1.TabIndex = 67
        '
        'ColumnParentTable
        '
        Me.ColumnParentTable.DataPropertyName = "ParentTable"
        Me.ColumnParentTable.HeaderText = "Parent table"
        Me.ColumnParentTable.Name = "ColumnParentTable"
        Me.ColumnParentTable.ReadOnly = True
        Me.ColumnParentTable.Resizable = System.Windows.Forms.DataGridViewTriState.[True]
        '
        'ColumnParentColumn
        '
        Me.ColumnParentColumn.DataPropertyName = "ParentColumn"
        Me.ColumnParentColumn.HeaderText = "Parent column"
        Me.ColumnParentColumn.Name = "ColumnParentColumn"
        Me.ColumnParentColumn.ReadOnly = True
        '
        'ColumnChildTable
        '
        Me.ColumnChildTable.DataPropertyName = "ChildTable"
        Me.ColumnChildTable.HeaderText = "Child table"
        Me.ColumnChildTable.Name = "ColumnChildTable"
        Me.ColumnChildTable.ReadOnly = True
        '
        'ColumnChildColumn
        '
        Me.ColumnChildColumn.DataPropertyName = "ChildColumn"
        Me.ColumnChildColumn.HeaderText = "Child column"
        Me.ColumnChildColumn.Name = "ColumnChildColumn"
        Me.ColumnChildColumn.ReadOnly = True
        '
        'ColumnUnique
        '
        Me.ColumnUnique.DataPropertyName = "UniqueColumn"
        Me.ColumnUnique.HeaderText = "Unique column"
        Me.ColumnUnique.Name = "ColumnUnique"
        '
        'ContextMenuStrip1
        '
        Me.ContextMenuStrip1.Items.AddRange(New System.Windows.Forms.ToolStripItem() {Me.ToolStripMenuItemDelete})
        Me.ContextMenuStrip1.Name = "ContextMenuStrip1"
        Me.ContextMenuStrip1.Size = New System.Drawing.Size(106, 26)
        '
        'ToolStripMenuItemDelete
        '
        Me.ToolStripMenuItemDelete.Name = "ToolStripMenuItemDelete"
        Me.ToolStripMenuItemDelete.Size = New System.Drawing.Size(105, 22)
        Me.ToolStripMenuItemDelete.Text = "Delete"
        '
        'PanelForeignKeysGridLabel
        '
        Me.PanelForeignKeysGridLabel.Controls.Add(Me.LabelForeignKeysGrid)
        Me.PanelForeignKeysGridLabel.Dock = System.Windows.Forms.DockStyle.Top
        Me.PanelForeignKeysGridLabel.Location = New System.Drawing.Point(0, 0)
        Me.PanelForeignKeysGridLabel.Name = "PanelForeignKeysGridLabel"
        Me.PanelForeignKeysGridLabel.Size = New System.Drawing.Size(393, 20)
        Me.PanelForeignKeysGridLabel.TabIndex = 69
        '
        'LabelForeignKeysGrid
        '
        Me.LabelForeignKeysGrid.AutoSize = True
        Me.LabelForeignKeysGrid.Location = New System.Drawing.Point(3, 3)
        Me.LabelForeignKeysGrid.Name = "LabelForeignKeysGrid"
        Me.LabelForeignKeysGrid.Size = New System.Drawing.Size(87, 13)
        Me.LabelForeignKeysGrid.TabIndex = 65
        Me.LabelForeignKeysGrid.Text = "Foreign keys grid"
        '
        'TreeView1
        '
        Me.TreeView1.Dock = System.Windows.Forms.DockStyle.Fill
        Me.TreeView1.Location = New System.Drawing.Point(0, 20)
        Me.TreeView1.Name = "TreeView1"
        Me.TreeView1.Size = New System.Drawing.Size(393, 132)
        Me.TreeView1.TabIndex = 71
        '
        'PanelForeignKeysTreeLabel
        '
        Me.PanelForeignKeysTreeLabel.Controls.Add(Me.LabelForeignKeysTree)
        Me.PanelForeignKeysTreeLabel.Dock = System.Windows.Forms.DockStyle.Top
        Me.PanelForeignKeysTreeLabel.Location = New System.Drawing.Point(0, 0)
        Me.PanelForeignKeysTreeLabel.Name = "PanelForeignKeysTreeLabel"
        Me.PanelForeignKeysTreeLabel.Size = New System.Drawing.Size(393, 20)
        Me.PanelForeignKeysTreeLabel.TabIndex = 70
        '
        'LabelForeignKeysTree
        '
        Me.LabelForeignKeysTree.AutoSize = True
        Me.LabelForeignKeysTree.Location = New System.Drawing.Point(3, 3)
        Me.LabelForeignKeysTree.Name = "LabelForeignKeysTree"
        Me.LabelForeignKeysTree.Size = New System.Drawing.Size(88, 13)
        Me.LabelForeignKeysTree.TabIndex = 65
        Me.LabelForeignKeysTree.Text = "Foreign keys tree"
        '
        'PanelScriptText
        '
        Me.PanelScriptText.Controls.Add(Me.PanelTablesProcessingListView)
        Me.PanelScriptText.Controls.Add(Me.PanelTablesProcessingLabel)
        Me.PanelScriptText.Dock = System.Windows.Forms.DockStyle.Fill
        Me.PanelScriptText.Location = New System.Drawing.Point(0, 20)
        Me.PanelScriptText.Name = "PanelScriptText"
        Me.PanelScriptText.Size = New System.Drawing.Size(349, 519)
        Me.PanelScriptText.TabIndex = 67
        '
        'PanelTablesProcessingListView
        '
        Me.PanelTablesProcessingListView.AllowDrop = True
        Me.PanelTablesProcessingListView.Controls.Add(Me.ListView1)
        Me.PanelTablesProcessingListView.Dock = System.Windows.Forms.DockStyle.Fill
        Me.PanelTablesProcessingListView.Location = New System.Drawing.Point(0, 20)
        Me.PanelTablesProcessingListView.Name = "PanelTablesProcessingListView"
        Me.PanelTablesProcessingListView.Size = New System.Drawing.Size(349, 499)
        Me.PanelTablesProcessingListView.TabIndex = 2
        '
        'ListView1
        '
        Me.ListView1.Columns.AddRange(New System.Windows.Forms.ColumnHeader() {Me.ColumnHeaderName, Me.ColumnHeaderOrder})
        Me.ListView1.ContextMenuStrip = Me.ContextMenuStrip1
        Me.ListView1.Dock = System.Windows.Forms.DockStyle.Fill
        Me.ListView1.FullRowSelect = True
        Me.ListView1.Location = New System.Drawing.Point(0, 0)
        Me.ListView1.Name = "ListView1"
        Me.ListView1.Size = New System.Drawing.Size(349, 499)
        Me.ListView1.SmallImageList = Me.ImageList1
        Me.ListView1.TabIndex = 0
        Me.ListView1.UseCompatibleStateImageBehavior = False
        Me.ListView1.View = System.Windows.Forms.View.Details
        '
        'ColumnHeaderName
        '
        Me.ColumnHeaderName.Text = "Table"
        Me.ColumnHeaderName.Width = 300
        '
        'ColumnHeaderOrder
        '
        Me.ColumnHeaderOrder.Text = "Order"
        '
        'ImageList1
        '
        Me.ImageList1.ImageStream = CType(resources.GetObject("ImageList1.ImageStream"), System.Windows.Forms.ImageListStreamer)
        Me.ImageList1.TransparentColor = System.Drawing.Color.Transparent
        Me.ImageList1.Images.SetKeyName(0, "Initial.ico")
        Me.ImageList1.Images.SetKeyName(1, "InProgress.ico")
        Me.ImageList1.Images.SetKeyName(2, "Error.ico")
        Me.ImageList1.Images.SetKeyName(3, "Ok.ico")
        '
        'PanelTablesProcessingLabel
        '
        Me.PanelTablesProcessingLabel.Controls.Add(Me.LabelTablesProcessing)
        Me.PanelTablesProcessingLabel.Dock = System.Windows.Forms.DockStyle.Top
        Me.PanelTablesProcessingLabel.Location = New System.Drawing.Point(0, 0)
        Me.PanelTablesProcessingLabel.Name = "PanelTablesProcessingLabel"
        Me.PanelTablesProcessingLabel.Size = New System.Drawing.Size(349, 20)
        Me.PanelTablesProcessingLabel.TabIndex = 1
        '
        'LabelTablesProcessing
        '
        Me.LabelTablesProcessing.AutoSize = True
        Me.LabelTablesProcessing.Location = New System.Drawing.Point(3, 3)
        Me.LabelTablesProcessing.Name = "LabelTablesProcessing"
        Me.LabelTablesProcessing.Size = New System.Drawing.Size(93, 13)
        Me.LabelTablesProcessing.TabIndex = 66
        Me.LabelTablesProcessing.Text = "Tables processing"
        '
        'PanelScriptLabel
        '
        Me.PanelScriptLabel.Controls.Add(Me.ButtonScriptFile)
        Me.PanelScriptLabel.Controls.Add(Me.TextBoxScriptFile)
        Me.PanelScriptLabel.Controls.Add(Me.LabelScript)
        Me.PanelScriptLabel.Dock = System.Windows.Forms.DockStyle.Top
        Me.PanelScriptLabel.Location = New System.Drawing.Point(0, 0)
        Me.PanelScriptLabel.Name = "PanelScriptLabel"
        Me.PanelScriptLabel.Size = New System.Drawing.Size(349, 20)
        Me.PanelScriptLabel.TabIndex = 66
        '
        'ButtonScriptFile
        '
        Me.ButtonScriptFile.Anchor = CType((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
        Me.ButtonScriptFile.Location = New System.Drawing.Point(324, 0)
        Me.ButtonScriptFile.Name = "ButtonScriptFile"
        Me.ButtonScriptFile.Size = New System.Drawing.Size(22, 20)
        Me.ButtonScriptFile.TabIndex = 2
        Me.ButtonScriptFile.Text = "..."
        Me.ButtonScriptFile.UseVisualStyleBackColor = True
        '
        'TextBoxScriptFile
        '
        Me.TextBoxScriptFile.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) _
            Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
        Me.TextBoxScriptFile.Location = New System.Drawing.Point(65, 0)
        Me.TextBoxScriptFile.Name = "TextBoxScriptFile"
        Me.TextBoxScriptFile.Size = New System.Drawing.Size(253, 20)
        Me.TextBoxScriptFile.TabIndex = 1
        '
        'LabelScript
        '
        Me.LabelScript.AutoSize = True
        Me.LabelScript.Location = New System.Drawing.Point(3, 3)
        Me.LabelScript.Name = "LabelScript"
        Me.LabelScript.Size = New System.Drawing.Size(56, 13)
        Me.LabelScript.TabIndex = 0
        Me.LabelScript.Text = "SQL script"
        '
        'TabControl1
        '
        Me.TabControl1.Controls.Add(Me.TabPageExecution)
        Me.TabControl1.Controls.Add(Me.TabPageConnection)
        Me.TabControl1.Dock = System.Windows.Forms.DockStyle.Fill
        Me.TabControl1.Location = New System.Drawing.Point(0, 0)
        Me.TabControl1.Multiline = True
        Me.TabControl1.Name = "TabControl1"
        Me.TabControl1.SelectedIndex = 0
        Me.TabControl1.Size = New System.Drawing.Size(760, 571)
        Me.TabControl1.TabIndex = 47
        '
        'ToolStripButtonRun
        '
        Me.ToolStripButtonRun.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image
        Me.ToolStripButtonRun.Image = CType(resources.GetObject("ToolStripButtonRun.Image"), System.Drawing.Image)
        Me.ToolStripButtonRun.ImageTransparentColor = System.Drawing.Color.Magenta
        Me.ToolStripButtonRun.MergeAction = System.Windows.Forms.MergeAction.Replace
        Me.ToolStripButtonRun.Name = "ToolStripButtonRun"
        Me.ToolStripButtonRun.Size = New System.Drawing.Size(23, 22)
        Me.ToolStripButtonRun.Text = "Run"
        '
        'ToolStripExecution
        '
        Me.ToolStripExecution.Dock = System.Windows.Forms.DockStyle.None
        Me.ToolStripExecution.Items.AddRange(New System.Windows.Forms.ToolStripItem() {Me.ToolStripButtonPrepare, Me.ToolStripButtonRun, Me.ToolStripButtonPause, Me.ToolStripButtonCancel})
        Me.ToolStripExecution.Location = New System.Drawing.Point(200, 0)
        Me.ToolStripExecution.Name = "ToolStripExecution"
        Me.ToolStripExecution.Size = New System.Drawing.Size(133, 25)
        Me.ToolStripExecution.TabIndex = 48
        Me.ToolStripExecution.Text = "Execution toolbar"
        '
        'ToolStripButtonPrepare
        '
        Me.ToolStripButtonPrepare.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image
        Me.ToolStripButtonPrepare.Image = CType(resources.GetObject("ToolStripButtonPrepare.Image"), System.Drawing.Image)
        Me.ToolStripButtonPrepare.ImageTransparentColor = System.Drawing.Color.Magenta
        Me.ToolStripButtonPrepare.MergeAction = System.Windows.Forms.MergeAction.Replace
        Me.ToolStripButtonPrepare.Name = "ToolStripButtonPrepare"
        Me.ToolStripButtonPrepare.Size = New System.Drawing.Size(23, 22)
        Me.ToolStripButtonPrepare.Text = "Prepare"
        '
        'ToolStripButtonPause
        '
        Me.ToolStripButtonPause.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image
        Me.ToolStripButtonPause.Image = CType(resources.GetObject("ToolStripButtonPause.Image"), System.Drawing.Image)
        Me.ToolStripButtonPause.ImageTransparentColor = System.Drawing.Color.Magenta
        Me.ToolStripButtonPause.MergeAction = System.Windows.Forms.MergeAction.Replace
        Me.ToolStripButtonPause.Name = "ToolStripButtonPause"
        Me.ToolStripButtonPause.Size = New System.Drawing.Size(23, 22)
        Me.ToolStripButtonPause.Text = "Pause"
        '
        'ToolStripButtonCancel
        '
        Me.ToolStripButtonCancel.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image
        Me.ToolStripButtonCancel.Image = CType(resources.GetObject("ToolStripButtonCancel.Image"), System.Drawing.Image)
        Me.ToolStripButtonCancel.ImageTransparentColor = System.Drawing.Color.Magenta
        Me.ToolStripButtonCancel.MergeAction = System.Windows.Forms.MergeAction.Replace
        Me.ToolStripButtonCancel.Name = "ToolStripButtonCancel"
        Me.ToolStripButtonCancel.Size = New System.Drawing.Size(23, 22)
        Me.ToolStripButtonCancel.Text = "Cancel"
        '
        'ToolStripStatusLabel
        '
        Me.ToolStripStatusLabel.Name = "ToolStripStatusLabel"
        Me.ToolStripStatusLabel.Size = New System.Drawing.Size(0, 17)
        '
        'StatusStrip1
        '
        Me.StatusStrip1.Dock = System.Windows.Forms.DockStyle.None
        Me.StatusStrip1.Items.AddRange(New System.Windows.Forms.ToolStripItem() {Me.ToolStripStatusLabel, Me.ToolStripProgressBar1})
        Me.StatusStrip1.Location = New System.Drawing.Point(400, 0)
        Me.StatusStrip1.Name = "StatusStrip1"
        Me.StatusStrip1.Size = New System.Drawing.Size(319, 22)
        Me.StatusStrip1.TabIndex = 49
        Me.StatusStrip1.Text = "Status toolbar"
        '
        'ToolStripProgressBar1
        '
        Me.ToolStripProgressBar1.MergeAction = System.Windows.Forms.MergeAction.Replace
        Me.ToolStripProgressBar1.Name = "ToolStripProgressBar1"
        Me.ToolStripProgressBar1.Size = New System.Drawing.Size(300, 16)
        '
        'Timer1
        '
        '
        'MenuStrip1
        '
        Me.MenuStrip1.Items.AddRange(New System.Windows.Forms.ToolStripItem() {Me.FileMenu})
        Me.MenuStrip1.Location = New System.Drawing.Point(0, 0)
        Me.MenuStrip1.Name = "MenuStrip1"
        Me.MenuStrip1.Size = New System.Drawing.Size(760, 24)
        Me.MenuStrip1.TabIndex = 51
        Me.MenuStrip1.Text = "MenuStrip"
        '
        'FileMenu
        '
        Me.FileMenu.DropDownItems.AddRange(New System.Windows.Forms.ToolStripItem() {Me.ToolStripMenuItemExit})
        Me.FileMenu.ImageTransparentColor = System.Drawing.SystemColors.ActiveBorder
        Me.FileMenu.MergeAction = System.Windows.Forms.MergeAction.Replace
        Me.FileMenu.Name = "FileMenu"
        Me.FileMenu.Size = New System.Drawing.Size(35, 20)
        Me.FileMenu.Text = "&File"
        '
        'ToolStripMenuItemExit
        '
        Me.ToolStripMenuItemExit.MergeAction = System.Windows.Forms.MergeAction.Remove
        Me.ToolStripMenuItemExit.Name = "ToolStripMenuItemExit"
        Me.ToolStripMenuItemExit.Size = New System.Drawing.Size(92, 22)
        Me.ToolStripMenuItemExit.Text = "E&xit"
        '
        'ErrorProvider1
        '
        Me.ErrorProvider1.ContainerControl = Me
        '
        'Panel1
        '
        Me.Panel1.Controls.Add(Me.TabControl1)
        Me.Panel1.Dock = System.Windows.Forms.DockStyle.Fill
        Me.Panel1.Location = New System.Drawing.Point(0, 24)
        Me.Panel1.Name = "Panel1"
        Me.Panel1.Size = New System.Drawing.Size(760, 571)
        Me.Panel1.TabIndex = 64
        '
        'FormExportToScript
        '
        Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!)
        Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
        Me.ClientSize = New System.Drawing.Size(760, 595)
        Me.Controls.Add(Me.Panel1)
        Me.Controls.Add(Me.ToolStripExecution)
        Me.Controls.Add(Me.StatusStrip1)
        Me.Controls.Add(Me.MenuStrip1)
        Me.Icon = CType(resources.GetObject("$this.Icon"), System.Drawing.Icon)
        Me.Name = "FormExportToScript"
        Me.Text = "Export to script"
        Me.TabPageConnection.ResumeLayout(False)
        Me.TabPageConnection.PerformLayout()
        CType(Me.NumericUpDownMaxRecords, System.ComponentModel.ISupportInitialize).EndInit()
        Me.TabPageExecution.ResumeLayout(False)
        Me.SplitContainer1.Panel1.ResumeLayout(False)
        Me.SplitContainer1.Panel2.ResumeLayout(False)
        CType(Me.SplitContainer1, System.ComponentModel.ISupportInitialize).EndInit()
        Me.SplitContainer1.ResumeLayout(False)
        Me.SplitContainer2.Panel1.ResumeLayout(False)
        Me.SplitContainer2.Panel1.PerformLayout()
        Me.SplitContainer2.Panel2.ResumeLayout(False)
        CType(Me.SplitContainer2, System.ComponentModel.ISupportInitialize).EndInit()
        Me.SplitContainer2.ResumeLayout(False)
        Me.PanelSQLStatementLabel.ResumeLayout(False)
        Me.PanelSQLStatementLabel.PerformLayout()
        Me.SplitContainer3.Panel1.ResumeLayout(False)
        Me.SplitContainer3.Panel2.ResumeLayout(False)
        CType(Me.SplitContainer3, System.ComponentModel.ISupportInitialize).EndInit()
        Me.SplitContainer3.ResumeLayout(False)
        Me.PanelTablesList.ResumeLayout(False)
        Me.PanelTablesLabel.ResumeLayout(False)
        Me.PanelTablesLabel.PerformLayout()
        Me.SplitContainer4.Panel1.ResumeLayout(False)
        Me.SplitContainer4.Panel2.ResumeLayout(False)
        CType(Me.SplitContainer4, System.ComponentModel.ISupportInitialize).EndInit()
        Me.SplitContainer4.ResumeLayout(False)
        CType(Me.DataGridView1, System.ComponentModel.ISupportInitialize).EndInit()
        Me.ContextMenuStrip1.ResumeLayout(False)
        Me.PanelForeignKeysGridLabel.ResumeLayout(False)
        Me.PanelForeignKeysGridLabel.PerformLayout()
        Me.PanelForeignKeysTreeLabel.ResumeLayout(False)
        Me.PanelForeignKeysTreeLabel.PerformLayout()
        Me.PanelScriptText.ResumeLayout(False)
        Me.PanelTablesProcessingListView.ResumeLayout(False)
        Me.PanelTablesProcessingLabel.ResumeLayout(False)
        Me.PanelTablesProcessingLabel.PerformLayout()
        Me.PanelScriptLabel.ResumeLayout(False)
        Me.PanelScriptLabel.PerformLayout()
        Me.TabControl1.ResumeLayout(False)
        Me.ToolStripExecution.ResumeLayout(False)
        Me.ToolStripExecution.PerformLayout()
        Me.StatusStrip1.ResumeLayout(False)
        Me.StatusStrip1.PerformLayout()
        Me.MenuStrip1.ResumeLayout(False)
        Me.MenuStrip1.PerformLayout()
        CType(Me.ErrorProvider1, System.ComponentModel.ISupportInitialize).EndInit()
        Me.Panel1.ResumeLayout(False)
        Me.ResumeLayout(False)
        Me.PerformLayout()

    End Sub
    Friend WithEvents TabPageConnection As System.Windows.Forms.TabPage
    Friend WithEvents CtrlConnection1 As SqlSimpleUtilities.ctrlConnection
    Friend WithEvents TabPageExecution As System.Windows.Forms.TabPage
    Friend WithEvents SplitContainer3 As System.Windows.Forms.SplitContainer
    Friend WithEvents StatusStrip1 As System.Windows.Forms.StatusStrip
    Friend WithEvents ToolStripStatusLabel As System.Windows.Forms.ToolStripStatusLabel
    Friend WithEvents ToolStripExecution As System.Windows.Forms.ToolStrip
    Friend WithEvents ToolStripButtonRun As System.Windows.Forms.ToolStripButton
    Friend WithEvents TabControl1 As System.Windows.Forms.TabControl
    Friend WithEvents ToolStripButtonPrepare As System.Windows.Forms.ToolStripButton
    Friend WithEvents SplitContainer1 As System.Windows.Forms.SplitContainer
    Friend WithEvents ListBox1 As System.Windows.Forms.ListBox
    Friend WithEvents PanelTablesLabel As System.Windows.Forms.Panel
    Friend WithEvents LabelTables As System.Windows.Forms.Label
    Friend WithEvents DataGridView1 As System.Windows.Forms.DataGridView
    Friend WithEvents PanelScriptText As System.Windows.Forms.Panel
    Friend WithEvents PanelScriptLabel As System.Windows.Forms.Panel
    Friend WithEvents LabelScript As System.Windows.Forms.Label
    Friend WithEvents PanelTablesList As System.Windows.Forms.Panel
    Friend WithEvents PanelForeignKeysGridLabel As System.Windows.Forms.Panel
    Friend WithEvents LabelForeignKeysGrid As System.Windows.Forms.Label
    Friend WithEvents TextBoxScriptFile As System.Windows.Forms.TextBox
    Friend WithEvents ToolStripProgressBar1 As System.Windows.Forms.ToolStripProgressBar
    Friend WithEvents ContextMenuStrip1 As System.Windows.Forms.ContextMenuStrip
    Friend WithEvents ToolStripMenuItemDelete As System.Windows.Forms.ToolStripMenuItem
    Friend WithEvents ColumnParentTable As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents ColumnParentColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents ColumnChildTable As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents ColumnChildColumn As System.Windows.Forms.DataGridViewTextBoxColumn
    Friend WithEvents ColumnUnique As System.Windows.Forms.DataGridViewComboBoxColumn
    Friend WithEvents PanelTablesProcessingLabel As System.Windows.Forms.Panel
    Friend WithEvents LabelTablesProcessing As System.Windows.Forms.Label
    Friend WithEvents ListView1 As System.Windows.Forms.ListView
    Friend WithEvents ImageList1 As System.Windows.Forms.ImageList
    Friend WithEvents PanelTablesProcessingListView As System.Windows.Forms.Panel
    Friend WithEvents ColumnHeaderName As System.Windows.Forms.ColumnHeader
    Friend WithEvents ColumnHeaderOrder As System.Windows.Forms.ColumnHeader
    Friend WithEvents ToolStripButtonPause As System.Windows.Forms.ToolStripButton
    Friend WithEvents ToolStripButtonCancel As System.Windows.Forms.ToolStripButton
    Friend WithEvents Timer1 As System.Windows.Forms.Timer
    Friend WithEvents ButtonScriptFile As System.Windows.Forms.Button
    Friend WithEvents MenuStrip1 As System.Windows.Forms.MenuStrip
    Friend WithEvents FileMenu As System.Windows.Forms.ToolStripMenuItem
    Friend WithEvents ToolStripMenuItemExit As System.Windows.Forms.ToolStripMenuItem
    Friend WithEvents ErrorProvider1 As System.Windows.Forms.ErrorProvider
    Friend WithEvents Panel1 As System.Windows.Forms.Panel
    Friend WithEvents SplitContainer2 As System.Windows.Forms.SplitContainer
    Friend WithEvents TextBoxSQLStatement As System.Windows.Forms.TextBox
    Friend WithEvents PanelSQLStatementLabel As System.Windows.Forms.Panel
    Friend WithEvents LabelSQLStatement As System.Windows.Forms.Label
    Friend WithEvents SplitContainer4 As System.Windows.Forms.SplitContainer
    Friend WithEvents PanelForeignKeysTreeLabel As System.Windows.Forms.Panel
    Friend WithEvents LabelForeignKeysTree As System.Windows.Forms.Label
    Friend WithEvents TreeView1 As System.Windows.Forms.TreeView
    Friend WithEvents NumericUpDownMaxRecords As System.Windows.Forms.NumericUpDown
    Friend WithEvents Label1 As System.Windows.Forms.Label
End Class

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Software Developer (Senior) Unisystems
Greece Greece
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions