Search found 31 matches

by ClipperXTP
Fri Dec 04, 2020 4:14 am
Forum: PowerShell GUIs
Topic: Datagridview - Pasting from Excel Help
Replies: 1
Views: 398

Datagridview - Pasting from Excel Help

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...
by ClipperXTP
Wed Aug 26, 2020 5:33 am
Forum: PowerShell GUIs
Topic: Designer and Datagridviews - Font Sizes Lost after reopening
Replies: 0
Views: 1103

Designer and Datagridviews - Font Sizes Lost after reopening

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...
by ClipperXTP
Thu Jul 23, 2020 11:03 pm
Forum: PowerShell GUIs
Topic: Show-SplashScreen and GUI Load Times
Replies: 3
Views: 1109

Re: Show-SplashScreen and GUI Load Times

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...
by ClipperXTP
Thu Jul 23, 2020 5:36 am
Forum: PowerShell GUIs
Topic: Show-SplashScreen and GUI Load Times
Replies: 3
Views: 1109

Show-SplashScreen and GUI Load Times

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...
by ClipperXTP
Mon Jun 22, 2020 4:19 am
Forum: PowerShell
Topic: Speed up array searches?
Replies: 3
Views: 1261

Re: Speed up array searches?

This is excellent, thanks very much
by ClipperXTP
Fri Jun 19, 2020 8:25 am
Forum: PowerShell
Topic: Speed up array searches?
Replies: 3
Views: 1261

Speed up array searches?

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) --------...
by ClipperXTP
Thu Jun 18, 2020 10:58 pm
Forum: PowerShell GUIs
Topic: Managing Fonts with Dark Theme Enabled
Replies: 3
Views: 1124

Re: Managing Fonts with Dark Theme Enabled

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.
by ClipperXTP
Thu Jun 18, 2020 1:49 am
Forum: PowerShell GUIs
Topic: Managing Fonts with Dark Theme Enabled
Replies: 3
Views: 1124

Managing Fonts with Dark Theme Enabled

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...
by ClipperXTP
Fri Jun 12, 2020 2:39 am
Forum: PowerShell
Topic: New-WebServiceProxy Not Responding and hanging my script
Replies: 4
Views: 1286

Re: New-WebServiceProxy Not Responding and hanging my script

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
by ClipperXTP
Thu Jun 11, 2020 10:42 pm
Forum: PowerShell
Topic: New-WebServiceProxy Not Responding and hanging my script
Replies: 4
Views: 1286

Re: New-WebServiceProxy Not Responding and hanging my script

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...