#requires -Version 3 #------------------------------------------------------------------------ # Source File Information (DO NOT MODIFY) # Source ID: 5286cb37-dda1-463b-8642-289125c81d61 # Source File: Demo-DGVDataTableEditExport.psf #------------------------------------------------------------------------ #region File Recovery Data (DO NOT MODIFY) <#RecoveryData: bwgAAB+LCAAAAAAABAC9VlmL88oRfTf4Pwz3VV9Gu2TBzIB2S5a12dr8pn1Xa7Esyb8+nrnhJiQP gRC+bhq6GqpOVXP6dH3YaQwe6bgJ4T18e22mEnSff+Dv6B9f+93b24cxlnnZhY1UNqketumXkLbg b4Lsfjtcw6hJxaS8i2sPxvt7P2Uf8H94/MSRwNh+0aQWotySW4XIsrwh8Oyfg2MF15PRB1axFlyR PbwdT+tSu049FE4tDsiJdLHV4cAK2ReLXqjpqiRlcYZgkd7vVurYmCmBDTWVl/wVx1X80VVzZviH AGa5bEvG7kqQz6glYv3GsGiKn/tAWyhVklkf8mw0iQsjDGM6ZPa7raoZUdW24dhvrs5nnW4obQAk lzeU5sJOJH0t2dCEtHijYbYtqYGL1dKDE2NIJAfKHaF5dkEphsdW2e+g6ukf4tThLK3BX26NwZ1n 0EaUXGgHtlZ058BJNGGKqGc2qWZbedi8bkFczdkqc+SSB0mEHuqHZDj+ftd2t74q/Aek2FxNBBaV eoVIejFB+neQxQdWS7DCeyirYAWFU6CUeBA71dOMMHEOlcoZjxXVcsU6Xt1uv8OKS2IlfF2Ykq0W 5RWxlaXPhAkdQVnUT9a0xapsxBn4Zhsu8g2xBd814meiEEvoyZLdQlJ2NkYPmYn9rt66yHEuQOoT x4mxgHulDqBYy/n8ihHeDZlrhwgjQNoW2vsq3rG2rHVdiMJZB6VX3Ko2Gs+3TkDJdb/rKyXszk4h dqtJephMEDS9ipfVKUElIwQGxlNkbTGpwmiYiyvkPjfUUpvwkIOgkzXOGkmNqxKbPZfUfgcAiiy5 S0ffBDRfBMzF6KwLuT6wqxWadjWP0TCox5uzBs68okQFFemFxAgyJssMlzIUaEHFkPM5Ou93j9Ox 5TZ/IL0nX3ijQrmMjV7vjEANEHTsrakgo5rxCYLJSeZ0JKBCU7ODGajNsR4ojhPgFMrhM2bJ52q/ 008Bjo1Y9QwIkgWt3QzzTe1751qUN4th2bVdqAqRMvZwRDZvzgEubreiuPPr2UsbcqS0YoM4NeRv k7TfDROWIZuDBU6+uE9woNwLsvDCoPanEyE9A86oNaOR4lGBTkVOMw1LM8Vr3eLwcDJIeoTMugHS 1hGQ+cpNEqrnZUUgy62GoEweJSVubIjOU46eb/rzqj88SnogassFjlqRibrpsmNq5FDr2Xm7tkeH vKEIVUdzu9/NDapPrrbUQiU9I4n20Sy+9F0DA2Vc+Ma6W6WOcmMETY8HPDwSx2YW/G7nSgdNMn5K lLU3EwzVJWV68a1ddVnebIpigjS6w44Zb4un5weTW3Oevm10DON++ehvBoTG8zVhmMU1Bji9CQZt UbfFznzSU82CYLfXywplSiGBJnZaNgqEjEAoPIAzwzcdJvb5YuZCpSb4YPgAPzCpr+BkaTXt6Qnx zfhYZN9zQfujauzn5wf8I3Y/ssdOU9pGTZlOP/Y/T7avdorB2JTRrzf3H7JLvCPf89cbPzf3eUw/ u3S+j2Hz682cXzHiU7pdQZ12nxFNhy9qUiiDEylyYD7gv6L+O8plm+5p+zsw3r2yS8AyvX9XP/0W xO8/6PcAjeFSdvn/goXgGZnRGYomJBLi4X/H8tvmt9TEgzH9/wP9Zf5J+Q/4XxuMr78DGIz3iG8I AAA=#> #endregion <# .NOTES -------------------------------------------------------------------------------- Code generated by: SAPIEN Technologies, Inc., PowerShell Studio 2019 v5.6.161 Generated on: 4/11/2019 3:33 PM Generated by: jvier -------------------------------------------------------------------------------- .DESCRIPTION GUI script generated by PowerShell Studio 2019 #> #---------------------------------------------- #region Application Functions #---------------------------------------------- #endregion Application Functions #---------------------------------------------- # Generated Form Function #---------------------------------------------- function Show-Demo-DGVDataTableEditExport_psf { #---------------------------------------------- #region Import the Assemblies #---------------------------------------------- [void][reflection.assembly]::Load('System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089') [void][reflection.assembly]::Load('System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089') [void][reflection.assembly]::Load('System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a') #endregion Import Assemblies #---------------------------------------------- #region Generated Form Objects #---------------------------------------------- [System.Windows.Forms.Application]::EnableVisualStyles() $form1 = New-Object 'System.Windows.Forms.Form' $buttonColumns = New-Object 'System.Windows.Forms.Button' $buttonExportCsv = New-Object 'System.Windows.Forms.Button' $datagridview1 = New-Object 'System.Windows.Forms.DataGridView' $buttonOK = New-Object 'System.Windows.Forms.Button' $savefiledialog1 = New-Object 'System.Windows.Forms.SaveFileDialog' $InitialFormWindowState = New-Object 'System.Windows.Forms.FormWindowState' #endregion Generated Form Objects #---------------------------------------------- # User Generated Script #---------------------------------------------- $FormEvent_Load={ $dt = [System.Data.DataTable]::New() [void]$dt.Columns.Add('Firstname', [string]) [void]$dt.Columns.Add('LastName', [string]) [void]$dt.Columns.Add('Age', [int]) $datagridview1.DataSource = $dt } $buttonExportCsv_Click = { $savefiledialog1.AddExtension='csv' if ('Ok' -eq $savefiledialog1.ShowDialog()) { $datagridview1.SelectedRows | Select-Object -expand DataBoundItem | Export-csv $savefiledialog1.FileName -notype } } $datagridview1_RowPostPaint=[System.Windows.Forms.DataGridViewRowPostPaintEventHandler]{ if($datagridview1.Rows[0].HeaderCell.Value){ if([int]($datagridview1.Rows[$_.RowIndex].HeaderCell.Value - 1) -ne [int]($_.RowIndex)){ $datagridview1.Rows[$_.RowIndex].HeaderCell.Value = ($_.RowIndex + 1).ToString() } }else{ # this is to accommodate the first row issue $datagridview1.Rows[0].HeaderCell.Value = '1' } } $buttonColumns_Click={ $datagridview1.SelectedRows | ForEach-Object{ Write-Host ('{0}|{1}|{2}' -f ($_.Cells['Firstname'].Value),($_.Cells['Lastname'].Value), ($_.Cells['Age'].Value)) } } # --End User Generated Script-- #---------------------------------------------- #region Generated Events #---------------------------------------------- $Form_StateCorrection_Load= { #Correct the initial state of the form to prevent the .Net maximized form issue $form1.WindowState = $InitialFormWindowState } $Form_Cleanup_FormClosed= { #Remove all event handlers from the controls try { $buttonColumns.remove_Click($buttonColumns_Click) $buttonExportCsv.remove_Click($buttonExportCsv_Click) $datagridview1.remove_RowPostPaint($datagridview1_RowPostPaint) $form1.remove_Load($FormEvent_Load) $form1.remove_Load($Form_StateCorrection_Load) $form1.remove_FormClosed($Form_Cleanup_FormClosed) } catch { Out-Null <# Prevent PSScriptAnalyzer warning #> } } #endregion Generated Events #---------------------------------------------- #region Generated Form Code #---------------------------------------------- $form1.SuspendLayout() $datagridview1.BeginInit() # # form1 # $form1.Controls.Add($buttonColumns) $form1.Controls.Add($buttonExportCsv) $form1.Controls.Add($datagridview1) $form1.Controls.Add($buttonOK) $form1.AcceptButton = $buttonOK $form1.AutoScaleDimensions = '8, 17' $form1.AutoScaleMode = 'Font' $form1.ClientSize = '973, 551' $form1.FormBorderStyle = 'FixedDialog' $form1.KeyPreview = $True $form1.Margin = '5, 5, 5, 5' $form1.MaximizeBox = $False $form1.MinimizeBox = $False $form1.Name = 'form1' $form1.StartPosition = 'CenterScreen' $form1.Text = 'Form' $form1.add_Load($FormEvent_Load) # # buttonColumns # $buttonColumns.Location = '857, 54' $buttonColumns.Margin = '4, 4, 4, 4' $buttonColumns.Name = 'buttonColumns' $buttonColumns.Size = '100, 30' $buttonColumns.TabIndex = 3 $buttonColumns.Text = 'Columns' $buttonColumns.UseCompatibleTextRendering = $True $buttonColumns.UseVisualStyleBackColor = $True $buttonColumns.add_Click($buttonColumns_Click) # # buttonExportCsv # $buttonExportCsv.Location = '857, 16' $buttonExportCsv.Margin = '4, 4, 4, 4' $buttonExportCsv.Name = 'buttonExportCsv' $buttonExportCsv.Size = '100, 30' $buttonExportCsv.TabIndex = 2 $buttonExportCsv.Text = 'Export Csv' $buttonExportCsv.UseCompatibleTextRendering = $True $buttonExportCsv.UseVisualStyleBackColor = $True $buttonExportCsv.add_Click($buttonExportCsv_Click) # # datagridview1 # $datagridview1.AutoSizeColumnsMode = 'DisplayedCells' $datagridview1.ColumnHeadersHeightSizeMode = 'AutoSize' $datagridview1.Location = '28, 16' $datagridview1.Margin = '4, 4, 4, 4' $datagridview1.Name = 'datagridview1' $System_Windows_Forms_DataGridViewCellStyle_1 = New-Object 'System.Windows.Forms.DataGridViewCellStyle' $System_Windows_Forms_DataGridViewCellStyle_1.Alignment = 'MiddleRight' $System_Windows_Forms_DataGridViewCellStyle_1.BackColor = 'Control' $System_Windows_Forms_DataGridViewCellStyle_1.Font = 'Microsoft Sans Serif, 8.25pt' $System_Windows_Forms_DataGridViewCellStyle_1.ForeColor = 'WindowText' $System_Windows_Forms_DataGridViewCellStyle_1.Format = 'N0' $System_Windows_Forms_DataGridViewCellStyle_1.NullValue = '0' $System_Windows_Forms_DataGridViewCellStyle_1.SelectionBackColor = 'LightSteelBlue' $System_Windows_Forms_DataGridViewCellStyle_1.SelectionForeColor = 'HighlightText' $System_Windows_Forms_DataGridViewCellStyle_1.WrapMode = 'False' $datagridview1.RowHeadersDefaultCellStyle = $System_Windows_Forms_DataGridViewCellStyle_1 $datagridview1.RowHeadersWidthSizeMode = 'AutoSizeToAllHeaders' $datagridview1.RowTemplate.Height = 24 $datagridview1.SelectionMode = 'FullRowSelect' $datagridview1.ShowCellToolTips = $False $datagridview1.Size = '801, 437' $datagridview1.TabIndex = 1 $datagridview1.add_RowPostPaint($datagridview1_RowPostPaint) # # buttonOK # $buttonOK.Anchor = 'Bottom, Right' $buttonOK.DialogResult = 'OK' $buttonOK.Location = '857, 505' $buttonOK.Margin = '4, 4, 4, 4' $buttonOK.Name = 'buttonOK' $buttonOK.Size = '100, 30' $buttonOK.TabIndex = 0 $buttonOK.Text = 'OK' $buttonOK.UseCompatibleTextRendering = $True $buttonOK.UseVisualStyleBackColor = $True # # savefiledialog1 # $savefiledialog1.DefaultExt = 'xml' $savefiledialog1.Filter = 'CSV Files|*.csv' $datagridview1.EndInit() $form1.ResumeLayout() #endregion Generated Form Code #---------------------------------------------- #Save the initial state of the form $InitialFormWindowState = $form1.WindowState #Init the OnLoad event to correct the initial state of the form $form1.add_Load($Form_StateCorrection_Load) #Clean up the control events $form1.add_FormClosed($Form_Cleanup_FormClosed) #Show the Form return $form1.ShowDialog() } #End Function #Call the form Show-Demo-DGVDataTableEditExport_psf | Out-Null