Search found 11056 matches

by jvierra
Wed Jul 19, 2017 12:13 pm
Forum: Customer Service
Topic: Code formatter gone!
Replies: 4
Views: 206

Re: Code formatter gone!

The new style looks much better. It is cleaner and easier to read. The "code" tag is now retaining formatting but the font is too faded however, it is way better than nothing. $splat = @{ From = 'someone@abc.com' To = $recipients Subject = 'MSMQ Issue' Body = $body BodyAsHtml = $true Priority = 'Hig...
by jvierra
Wed Jul 19, 2017 9:23 am
Forum: PowerShell GUIs
Topic: Combobox causes crash/freeze
Replies: 13
Views: 120

Re: Combobox causes crash/freeze

Your code would be cleaner and faster if you do it like this: $button_DL_generateList_Click = { $lbl_DL_loading.Visible = $true $button_DL_generateList.Visible = $false #put all active groups in array so group can be choosen from dropdown $filter = {name -notlike 'security-*' -and name -notlike 'sec...
by jvierra
Wed Jul 19, 2017 9:19 am
Forum: PowerShell GUIs
Topic: Combobox causes crash/freeze
Replies: 13
Views: 120

Re: Combobox causes crash/freeze

Have you tried to run under the debugger to see what is blocking?

What changes did you make after the last time it ran successfully?
by jvierra
Wed Jul 19, 2017 9:12 am
Forum: Windows PowerShell
Topic: Insert into DB
Replies: 2
Views: 95

Re: Insert into DB

The attached code file is closer to what you are looking for:
sqlsnip.ps1
(586 Bytes) Downloaded 3 times
by jvierra
Wed Jul 19, 2017 8:56 am
Forum: Windows PowerShell
Topic: Insert into DB
Replies: 2
Views: 95

Re: Insert into DB

You would use an Update query with the WHERE selecting the primary keys.

$sql = "UPDATE Table2 SET column = '$value' WHERE keycol1 = 1 AND keycol2 = 2 AND keycol3 = 3"
by jvierra
Wed Jul 19, 2017 7:56 am
Forum: Windows PowerShell
Topic: datagridview cell reading
Replies: 13
Views: 167

Re: datagridview cell reading

It works fine for me. Here is an example:
by jvierra
Tue Jul 18, 2017 4:18 pm
Forum: Windows PowerShell
Topic: Convert VB.net to powershell
Replies: 8
Views: 367

Re: Convert VB.net to powershell

Great. I looked at you code and it looks good. Now you know hoe to customize the rendering of all controls which can help extend and decorate forms in unique and interesting ways.

Happy PosHing.
by jvierra
Tue Jul 18, 2017 1:41 pm
Forum: Windows PowerShell
Topic: datagridview cell reading
Replies: 13
Views: 167

Re: datagridview cell reading

The column names are not what you are using. They are what you named them as when you created them.
by jvierra
Tue Jul 18, 2017 1:40 pm
Forum: Customer Service
Topic: Code formatter gone!
Replies: 4
Views: 206

Re: Code formatter gone!

Good luck. I have been trying to find a replacement for Geiji's (spelling) formatter for a couple of years. The source code may still be available.
by jvierra
Tue Jul 18, 2017 1:26 pm
Forum: Windows PowerShell
Topic: datagridview cell reading
Replies: 13
Views: 167

Re: datagridview cell reading

You must set both the header text AND the name. THe column names are in the right box. $row.Cells['DMS Name'].Value SelectedRows can be zero or more rows. It appears that you may not be loading the table correctly. THe table loads from a collection by "Data{PropertyName" when it matches the collecti...