C#

private void FrmMain_Shown(object sender, EventArgs epp)
    {
    string strConnect = SMDBSupport.SMInstanceStorage.GetInstanceConnectionString("Testing");
    using (SqlConnection con = new SqlConnection(strConnect))
        {
        try
            {
            con.Open();
            using (SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM myTable", con))
                {
                DataTable dt = new DataTable();
                da.Fill(dt);
                myDataGridView.DataSource = dt;
                }
            }
        catch (Exception ex)
            {
            Debug.WriteLine(ex.ToString());
            }
        }
    }

private void MyButton_Click(object sender, EventArgs e)
    {
    foreach (DataGridViewRow row in myDataGridView.Rows)
        {
        row.HeaderCell.Value = (row.Index + 1).ToString();
        }
    }

row.HeaderCell.Value = (row.Index + 1).ToString();

int i = row.Index;
i++;
string s = i.Tostring();   // Can't see this failing! :laugh:
var hc = row.HeaderCell;
hc.Value = s;

var document = XDocument.Load(@".\cwec_v4.4.xml");
var ns = document.Root.Name.Namespace;
int idToFind = 1004;

string detail = doc.Descendants(ns + "Weakness")
    .Where(el => (int)el.Attribute("ID") == idToFind)
    .Elements(ns + "Background_Details")
    .Elements(ns + "Background_Detail")
    .Select(el => el.Value)
    .FirstOrDefault();

XElement weakness = document.Descendants(ns + "Weakness")
    .FirstOrDefault(el => (int)el.Attribute("ID") == idToFind);

if (weakness != null)
{
    string description = (string)weakness.Elements(ns + "Description");
    string detail = (string)weakness.Element(ns + "Background_Details").Element(ns + "Background_Detail");
    ...
}

myString = myString.Replace("%", "%%");

using System;

namespace OneOffConsole
    {
    class Program
        {
        static void Main(string[] args)
            {
            foreach (string s in args)
                {
                Console.WriteLine(s);
                }
            }
        }
    }

Microsoft Windows [Version 10.0.19043.985]
(c) Microsoft Corporation. All rights reserved.

C:\Users\PaulG>cd "D:\Documents\AA Backed Up\My Projects\OneOffJobs\OneOffConsole\bin\Debug"

C:\Users\PaulG>D:

D:\Documents\AA Backed Up\My Projects\OneOffJobs\OneOffConsole\bin\Debug>oneoffconsole -variables -outputname "I am a filename 100%.mkv"
-variables
-outputname
I am a filename 100%.mkv

D:\Documents\AA Backed Up\My Projects\OneOffJobs\OneOffConsole\bin\Debug>dir >"x 100%.txt"

D:\Documents\AA Backed Up\My Projects\OneOffJobs\OneOffConsole\bin\Debug>type "x 100%.txt"
 Volume in drive D is GriffData
 Volume Serial Number is 4CA5-2F85

 Directory of D:\Documents\AA Backed Up\My Projects\OneOffJobs\OneOffConsole\bin\Debug

08/06/2021  06:39    <DIR>          .
08/06/2021  06:39    <DIR>          ..
20/06/2019  17:39         4,079,616 itextsharp.dll
20/06/2019  17:39         3,180,097 itextsharp.xml
20/06/2019  17:39           169,984 itextsharp.xmlworker.dll
08/06/2021  06:35             4,608 OneOffConsole.exe
25/06/2019  06:47               189 OneOffConsole.exe.config
08/06/2021  06:35            19,968 OneOffConsole.pdb
08/06/2021  06:39                 0 x 100%.txt
               7 File(s)      7,454,462 bytes
               2 Dir(s)  805,619,617,792 bytes free

D:\Documents\AA Backed Up\My Projects\OneOffJobs\OneOffConsole\bin\Debug>

SELECT * FROM MyTable WHERE StreetAddress = 'Baker's Wood'

SELECT * FROM MyTable WHERE StreetAddress = 'x';DROP TABLE MyTable;--'

SELECT * FROM MyTable WHERE StreetAddress = 'x';

DROP TABLE MyTable;

--'

Joseline Riker wrote:

The % in the above path when passed to the application errors.

I am a filename/Am I? .sav

Bastard Programmer from Hell
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

BillWoodruff wrote:

Do you use these mechanisms more frequently in WPF ?

BillWoodruff wrote:

1) INotifyPropertyChanging has no cancel mechanism ... unless you consider throwing an error in some context you have no control over sweet-smelling code According to PostSharp docs: "INotifyPropertyChanging interface is not portable (in Xamarin, it is even a part of a different namespace)."

BillWoodruff wrote:

2) INotifyPropertyChanged is just post-facto notification. There does appear to be a special benefit in using it with SQL and Linq: [^] ... i've never played with that.

Of course, you could trigger update of a binding connection. And, using Caller Information Attributes is easy in a Notify* changed handler ... imho, those attributes are of very limited value.

BillWoodruff wrote:

3) through "heroic" programming, you can create custom EventArgs that inherit from the INotify* versions and extend them to implement cancellation. however, in your subscribing objects' handlers you will have to cast the incoming args to their extended form.

Bastard Programmer from Hell
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Eddy Vluggen wrote:

Cancelling an update would be exceptional,

Eddy Vluggen wrote:

Exceptions aren't that expensive.

BillWoodruff wrote:

Every time you use some validation method, potentially, cancelling an update can occur.

BillWoodruff wrote:

When you allow external clients to inject executable code, potentially any of those clients could crash their code by throwing an error:

Bastard Programmer from Hell
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.