Powershell string array to datagridview

Question

I am trying to write the contents of a text file to a datagridview. If I iterate through the array lines, I see the strings. When I add the array to a datagridview, I see properties of the file, line numbers, and string lengths -- but not the strings, which is all I want.

$LogFileRaw = Get-Content($selected)

If I use .Net, I just see the string lengths

$LogFileRaw = [System.IO.File]::ReadAllLines($selected)

I think that I haven't correctly bound the string array to a DataGridView control. I've found examples of doing this in other languages, but not in Powershell. Can someone can point me to a Powershell example or explain what I'm doing wrong? Thank you for your patience.

xXhRQ8sD2L7Z · Accepted Answer · 2014-12-01 18:31:34Z

1

You can use Get-Content, but you need to give your log file content 'column' a name:

$LogFileRaw = Get-Content($selected) | % {
   New-Object PSObject -Property @{
      "Log Entry" = $_
   }
}

Then you can add this to the datagridview:

$array = New-Object System.Collections.ArrayList
$array.AddRange($LogFileRaw)

$dataGridView = New-Object System.Windows.Forms.DataGridView
$dataGridView.DataSource = $array

This is much simpler when importing a .csv file because you can use the -header parameter of ConvertFrom-Csv.

edited Dec 1, 2014 at 18:31

answered Dec 1, 2014 at 5:20

xXhRQ8sD2L7Z

1,7261 gold badge14 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ronald Montgomery Over a year ago

Thank you so much. What an elegant solution. I'm a newb at PS. This REALLY helped me out.

Collectives™ on Stack Overflow

Powershell string array to datagridview

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related