SAPIEN Technologies

Hi I am using jvierra's excellent earlier post to copy data from Excel to a Datagridview from here: https://www.sapien.com/forums/viewtopic.php?t=9885 I have created a datagridview in the Designer. I have not added or defined any columns. My excel data has no headers. The first column in spreadsheet...

Hi I change my ColumnHeadersDefaultCellStyle / DefaultCellStyle in the Designer from MS Sans Serif 12pt (the default) to Segui 8pt from the font dropdowns for my DataGridViews in PowerShell Studio 2019. Before I click OK, I see it has changed 8 pt to 7.8 pt but no worries. I run the project and it s...

Hi JV thanks for your reply. It's opening one database connection. There's about 4000 lines of code that do various queries to machines and web services when buttons are clicked. On load there is also a set control theme to 'dark' which takes a couple of seconds even on the most basic form. As I sai...

It takes about 6/7 seconds for my Windows Form GUI to load after double click. I've had some of my users comment that when they double click on the .exe they think nothing has happened and they double click it again etc. I tried Show-SplashScreen in the form load event and it looks great but the spl...

This is excellent, thanks very much

Hi I am running a powershell query against SQL database to pull back computer name and model for about 6,000 computers $adapter = new-object system.data.sqlclient.sqldataadapter ($query, $conn) $table = new-object system.data.datatable $adapter.Fill($table) | out-null $compArray = @($table) --------...

Thanks for your suggestion but this is dynamic behavior.

The Groupbox is fine when it is enabled.

When the radial button sets $Groupbox1.enabled = $false so as to grey out its checkboxes etc, this is when the Groupbox title becomes unreadable.

Hi I have a GUI with radial buttons which enable / disable Groupbox depending on which option is chosen. I have attached a JPG with a portion of the GUI displayed. You will see the Groupbox text circled is displaying almost black on black when the groupbox has been disabled by the choice of radio bu...

Ah OK, gotcha sorry I misread your email.

Yes, test-connection isn't really an option as other services work fine on server when this one is not responding.

Thanks for taking the time to look at it

Many thanks for the reply Test-Connection doesn't help me if it times out after two mins. My powershell job times out after 15 seconds when the server is unresponsive. The job takes about 8 seconds when the server is its normal responsive self. Note, the server works fine most days, maybe once every...