I need to get the results of the first DROPDOWN box stored as a variable, and used in place of INSTANCE_NAME in the second DROPDOWN box.
Essentially, the SELECT query from the second box needs to be run against the MASTER database in the SLQ_INSTANCE that the first DROPDOWN box results in once a choice has been made.
I’ve tried a few variations and can’t seem to get it right. Any suggestions?
Thanks in advance!
#first DROPDOWN Box $label = New-Object System.Windows.Forms.Label $label.Location = New-Object System.Drawing.Point(10,20) $label.Size = New-Object System.Drawing.Size(280,20) $label.Text = 'SQL Server Name' $form.Controls.Add($label) $DropDownBox = New-Object System.Windows.Forms.ComboBox $DropDownBox.Location = New-Object System.Drawing.Size(10,40) $DropDownBox.Size = New-Object System.Drawing.Size(260,20) $DropDownBox.DropDownHeight = 200 $Form.Controls.Add($DropDownBox) $wksList= invoke-sqlcmd -query "select * from VIEW_NAME order by instance_name" -database DATABASE_NAME -serverinstance INSTANCE_NAME foreach ($wks in $wksList) { $DropDownBox.Items.Add($wks.Instance_Name) } #end foreach #end first DROPDOWN box #second DROPDOWN Box $label2 = New-Object System.Windows.Forms.Label $label2.Location = New-Object System.Drawing.Point(10,90) $label2.Size = New-Object System.Drawing.Size(280,20) $label2.Text = 'Database Name' $form.Controls.Add($label2) $DropDownBox2 = New-Object System.Windows.Forms.ComboBox $DropDownBox2.Location = New-Object System.Drawing.Size(10,110) $DropDownBox2.Size = New-Object System.Drawing.Size(260,20) $DropDownBox2.DropDownHeight = 200 $Form.Controls.Add($DropDownBox2) $wksList2= invoke-sqlcmd -query "select name from sys.databases where database_id>4 order by name" -database MASTER -serverinstance INSTANCE_NAME foreach ($wks in $wksList2) { $DropDownBox2.Items.Add($wks.name) } #end foreach #end second DROPDOWN box