Create your own SQL Tools with PowerShell and Windows Forms

,

Steve:

Check out a new blogger who is sharing secrets of the DBA world. In his first post, James shows us how to create your very own SQL tool using PowerShell and Windows Form.

Originally posted on JamesDataTechQ:

By combining PowerShell and Windows Forms you can create your own SQL Tools. From the Windows Form you can execute your SQL and PowerShell scripts with just a couple clicks of a mouse. The added bonus is now your scripts are in a central location that is tailored to your needs.   I have created a base form below so you can get started adding you own scripts. If you’re new to PowerShell save the code below as a ps1 file and then run it from the PowerShell.

Untitled

####################### PowerShell Code ###############################

function CreateForm {

Add-Type -AssemblyName System.Windows.Forms

Add-Type -AssemblyName System.drawing

$form1 = New-Object System.Windows.Forms.Form

$button1 = New-Object System.Windows.Forms.Button

$button2 = New-Object System.Windows.Forms.Button

$checkBox1 = New-Object System.Windows.Forms.CheckBox

$checkBox2 = New-Object System.Windows.Forms.CheckBox

$InitialFormWindowState = New-Object System.Windows.Forms.FormWindowState

#Form Parameter

$form1.Text = “My PowerShell Form”

$form1.Name = “form1?
$form1.DataBindings.DefaultDataSourceUpdateMode =…

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Width = 550

$System_Drawing_Size.Height = 150

$form1.ClientSize = $System_Drawing_Size

#Add…

View original 369 more words

Rate

Share

Share

Rate