{"id":50913,"date":"2010-03-22T00:01:00","date_gmt":"2010-03-22T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2010\/03\/22\/hey-scripting-guy-how-can-i-use-the-datagrid-control-in-windows-powershell\/"},"modified":"2010-03-22T00:01:00","modified_gmt":"2010-03-22T00:01:00","slug":"hey-scripting-guy-how-can-i-use-the-datagrid-control-in-windows-powershell","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/hey-scripting-guy-how-can-i-use-the-datagrid-control-in-windows-powershell\/","title":{"rendered":"Hey, Scripting Guy! How Can I Use the DataGrid Control in Windows PowerShell?"},"content":{"rendered":"

\"Bookmark<\/a>
 <\/b><\/font><\/font><\/p>\n

About the author:<\/b> Ravikanth works at Dell, Inc., as a lead engineer in the Microsoft SharePoint solutions team. He loves automation and is a Windows PowerShell fanatic. He writes regularly on his blog<\/a> <\/font><\/font>about topics related to Windows PowerShell, SharePoint, and Microsoft server virtualization. He is also a moderator on the <\/font>Hey, Scripting Guy! forum<\/font><\/a> and a regular speaker at <\/font>Bangalore IT Pro<\/font><\/a> user group meetings.<\/p>\n

<\/font><\/font><\/p>\n

\n

 <\/font><\/p>\n<\/p>\n

In an earlier blog post, Ed Wilson showed us how to <\/font>create GUI using Windows PowerShell<\/font><\/a> and SAPIEN PrimalForms. Using PrimalForms is a very powerful and easy way to create GUI for your Windows PowerShell scripts. You can export the code required to script a GUI to a Windows PowerShell script and then customize it to make it more useful. Behind the scenes, we use the System.Windows.Forms<\/b> namespace to generate a GUI. There are <\/font>many GUI controls<\/font><\/a> supported by this namespace. In today’s post, we will see an example that shows how to use the DataGrid<\/b> control to display the information in a tabular form.  <\/span><\/p>\n

<\/font><\/font><\/p>\n

First, we design a GUI form using SAPIEN’s PrimalForms Community Edition. Let us call this Process Manager. The design is quite simple. We place a DataGrid<\/b> control and three buttons, each with some custom text representing the action. When loaded, this form will list the running processes and let us stop a selected process or refresh the process information displayed in the grid. <\/p>\n

<\/font><\/font><\/p>\n

\"Image<\/p>\n

<\/font><\/font><\/p>\n


After the design is complete, we export the form to a Windows PowerShell script using the “Export PowerShell” option. This generates the necessary code to create the GUI form in Windows PowerShell. Now, we need to edit this script to add the custom code we need to create our process manager.<\/p>\n

<\/font><\/font><\/p>\n

We need to perform the following script changes to make our process manager functional. <\/p>\n

<\/font><\/font><\/p>\n

1.<\/font>       <\/span><\/span><\/span>Capture a list of processes and display all of that in the data grid when we open the form.<\/p>\n

<\/font><\/font><\/p>\n

2.<\/font>       <\/span><\/span><\/span>Enable all three buttons to function as expected.<\/p>\n

<\/font><\/font><\/p>\n

Before we go further into the details of this script, let us quickly look at how the DataGrid<\/b> control is created. The following code shows the code generated by PrimalForms to add the DataGrid<\/b> control to the main form:<\/p>\n

<\/font><\/font><\/p>\n\n\n\n
\n

$dataGrid1 = New-Object System.Windows.Forms.DataGrid<\/p>\n

<\/span><\/p>\n

$System_Drawing_Size = New-Object System.Drawing.Size<\/p>\n

<\/span><\/p>\n

$System_Drawing_Size.Width = 492<\/p>\n

<\/span><\/p>\n

$System_Drawing_Size.Height = 308<\/p>\n

<\/span><\/p>\n

$dataGrid1.Size = $System_Drawing_Size<\/p>\n

<\/span><\/p>\n

$dataGrid1.DataBindings.DefaultDataSourceUpdateMode = 0<\/p>\n

<\/span><\/p>\n

$dataGrid1.HeaderForeColor = [System.Drawing.Color]::FromArgb(255,0,0,0)<\/p>\n

<\/span><\/p>\n

$dataGrid1.Name = “dataGrid1”<\/p>\n

<\/span><\/p>\n

$dataGrid1.DataMember = “”<\/p>\n

<\/span><\/p>\n

$dataGrid1.TabIndex = 0<\/p>\n

<\/span><\/p>\n

$System_Drawing_Point = New-Object System.Drawing.Point<\/p>\n

<\/span><\/p>\n

$System_Drawing_Point.X = 13<\/p>\n

<\/span><\/p>\n

$System_Drawing_Point.Y = 48<\/p>\n

<\/span><\/p>\n

$dataGrid1.Location = $System_Drawing_Point<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

$form1.Controls.Add($dataGrid1)<\/p>\n

<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n

 <\/font><\/p>\n<\/p>\n

We use System.Windows.Forms.DataGrid<\/b> namespace to create an instance as $datagrid1<\/b>. After this instance is created, we assign values to properties such as size of the grid, name, and various other properties. We are not done yet. We need to assign a data source to display the process information in the grid. <\/p>\n

<\/font><\/font><\/p>\n

To display process information in the data grid at script startup, we need to add the necessary code to the form load event—$form1.Add_Load()<\/b>. Because a Refresh<\/b> button would also display process information in the grid, we will create a function so that we can reuse the code for both the form load and refresh button click events.<\/p>\n

<\/font><\/font><\/p>\n

The following code shows the function we created to display process information in the data grid:<\/p>\n

<\/font><\/font><\/p>\n\n\n\n
\n

function Get-ProcessInfo {<\/p>\n

<\/span><\/p>\n

      <\/span>$array = New-Object System.Collections.ArrayList<\/p>\n

<\/span><\/p>\n

      <\/span>$Script:procInfo = Get-Process | Select Id,Name,Path,Description,VM,WS,CPU,Company | sort -Property Name<\/p>\n

<\/span><\/p>\n

      <\/span>$array.AddRange($procInfo)<\/p>\n

<\/span><\/p>\n

      <\/span>$dataGrid1.DataSource = $array<\/p>\n

<\/span><\/p>\n

      <\/span>$form1.refresh()<\/p>\n

<\/span><\/p>\n

}<\/p>\n

<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n

 <\/font><\/p>\n<\/p>\n

Within the Get-ProcessInfo<\/b> function, we are creating an instance of the System.Collections.ArrayList<\/b> object and the $procInfo<\/b> object, and putting them in the <\/font>script scope<\/font><\/a> so that they are available to other functions as required. After we retrieve the process information using the Get-Process<\/b> cmdlet, we add $procInfo<\/b> to $array<\/b>, and assign $array<\/b> as the data source to the $dataGrid1<\/b> object. After the DataSource<\/b> property is assigned, we make sure we display data in the grid by refreshing the form using $form1.refresh()<\/b>.<\/p>\n

<\/font><\/font><\/p>\n

To make sure process information is displayed in the grid at script startup, we add the following code to $OnLoadForm_UpdateGrid<\/b>:<\/p>\n

<\/font><\/font><\/p>\n

\n

 <\/font><\/p>\n<\/p>\n\n\n\n
\n

$OnLoadForm_UpdateGrid=<\/p>\n

<\/span><\/p>\n

{<\/p>\n

<\/span><\/p>\n

      <\/span>Get-ProcessInfo<\/p>\n

<\/span><\/p>\n

}<\/p>\n

<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n

 <\/font><\/p>\n<\/p>\n

We then call it using the $form1.add_load()<\/b> event:<\/p>\n

<\/font><\/font><\/p>\n

\n

 <\/font><\/p>\n<\/p>\n\n\n\n
\n

#Add Form event<\/p>\n

<\/span><\/p>\n

$form1.add_Load($OnLoadForm_UpdateGrid)<\/p>\n

<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n

 <\/font><\/p>\n<\/p>\n

This will result in process information being displayed in the data grid, as shown here:<\/p>\n

<\/font><\/font><\/p>\n

\"Image<\/p>\n

<\/font><\/font><\/p>\n

Now, let us move on to the second part of this process manager GUI. We need to enable “refresh”, “Kill process” and “Close” buttons on this form. The refresh button will refresh the process information displayed in the data grid, Kill process will terminate the selected process and close button will close the main form. For adding the code required to perform what is required, we use the button click events and assign code to Add_click() events of each button.<\/p>\n

<\/font><\/font><\/p>\n

Because we already have the code required to refresh the form as the Get-ProcessInfo<\/b> function, we just call this function within the $button1.Add_click()<\/b> event:<\/p>\n

<\/font><\/font><\/p>\n\n\n\n
\n

$button1_OnClick= <\/p>\n

<\/span><\/p>\n

{<\/p>\n

<\/span><\/p>\n

      <\/span>Get-ProcessInfo<\/p>\n

<\/span><\/p>\n

}<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

#Add the event<\/p>\n

<\/span><\/p>\n

$button1.add_Click($button1_OnClick)<\/p>\n

<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n

 <\/font><\/p>\n<\/p>\n

To stop a selected process, we add the following code to $button2_OnClick<\/b> and add it to $button2.Add_click()<\/b> event:<\/p>\n

<\/font><\/font><\/p>\n\n\n\n
\n

$button2_OnClick= <\/p>\n

<\/span><\/p>\n

{<\/p>\n

<\/span><\/p>\n

      <\/span>$selectedRow = $dataGrid1.CurrentRowIndex<\/p>\n

<\/span><\/p>\n

      <\/span>if (($procid=$Script:procInfo[$selectedRow].Id)) {<\/p>\n

<\/span><\/p>\n

                  <\/span>Stop-Process -Id $procid -Confirm<\/p>\n

<\/span><\/p>\n

            <\/span>}<\/p>\n

<\/span><\/p>\n

}<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

#add the event<\/p>\n

<\/span><\/p>\n

$button2.add_Click($button2_OnClick)<\/p>\n

<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n

 <\/font><\/p>\n<\/p>\n

In the above code, we get the selected row’s index into the $selectedRow<\/b> variable and then use $selectedRow<\/b> to retrieve the process ID of the selected process. You can select a process by either clicking the row header or anywhere within the row. When a row is selected, you can see a marker on the row header as shown in the following image. <\/p>\n

<\/font><\/font><\/p>\n

\"Image<\/p>\n

<\/font><\/font><\/p>\n

\n

 <\/font><\/p>\n<\/p>\n

After the process ID is captured in $procid<\/b>, we use the Stop-Process<\/b> cmdlet to terminate the process. We also use the -Confirm<\/b> parameter with the Stop-Process<\/b> cmdlet. <\/p>\n

<\/font><\/font><\/p>\n

\n

 <\/font><\/p>\n<\/p>\n

So, when you run this script using the Windows PowerShell ISE and attempt to stop a process, you will see something similar to what is shown in the following image.<\/p>\n

<\/font><\/font><\/p>\n

\"Image<\/p>\n

<\/font><\/font><\/p>\n

Finally, we assign $form1.Close()<\/b> to $button3_OnClick<\/b>, and add it to $button3.add_click()<\/b> event to enable the Close button. <\/p>\n

<\/font><\/font><\/p>\n


The complete code for this article is on the <\/font>Script Center Script Repository<\/font><\/a>. <\/p>\n

<\/font><\/font><\/p>\n

What we have seen so far is a basic implementation of data grid. We can automate the data grid refresh using the <\/font>timer<\/font><\/a> class. You can also a see a bit more advanced example of data grid control along with the TreeView<\/b> control in the Windows PowerShell Remote File Explorer script at <\/font>http:\/\/psremoteexplorer.codeplex.com\/<\/font><\/a>.<\/font><\/font><\/p>\n

<\/p>\n

<\/font><\/font> <\/p>\n","protected":false},"excerpt":{"rendered":"

  About the author: Ravikanth works at Dell, Inc., as a lead engineer in the Microsoft SharePoint solutions team. He loves automation and is a Windows PowerShell fanatic. He writes regularly on his blog about topics related to Windows PowerShell, SharePoint, and Microsoft server virtualization. He is also a moderator on the Hey, Scripting Guy! […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[81,71,56,82,3,45],"class_list":["post-50913","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-datagrid","tag-graphical","tag-guest-blogger","tag-ravikanth","tag-scripting-guy","tag-windows-powershell"],"acf":[],"blog_post_summary":"

  About the author: Ravikanth works at Dell, Inc., as a lead engineer in the Microsoft SharePoint solutions team. He loves automation and is a Windows PowerShell fanatic. He writes regularly on his blog about topics related to Windows PowerShell, SharePoint, and Microsoft server virtualization. He is also a moderator on the Hey, Scripting Guy! […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/50913","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=50913"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/50913\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=50913"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=50913"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=50913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}