C#

SELECT name, OBJECT_NAME(referenced_object_id) As ForeignTable
FROM sys.foreign_keys
WHERE parent_object_id = OBJECT_ID('TableName')

public class StringAndInt
    {
    public string myString;
    public int myInt;
    public StringAndInt(string myString, int myInt)
        {
        this.myString = myString;
        this.myInt = myInt;
        }
    public static StringAndInt[] MakeArray(params object[] data)
        {
        if (data.Length % 1 == 1) throw new ArgumentException("Initialization data must be provided in pairs");
        int elements = data.Length / 2;
        StringAndInt[] arr = new StringAndInt[elements];
        for (int index = 0; index < elements; index++)
            {
            object a1 = data[index * 2];
            object a2 = data[index * 2 + 1];
            if (!(a1 is string s && a2 is int i)) throw new ArgumentException($"Invalid argument pair ({a1},{a2}");
            arr[i] = new StringAndInt(s, i);
            }
        return arr;
        }
    }

StringAndInt[] myArray = StringAndInt.MakeArray("String", 0, "String", 1, "String", 2);

public static class StringAndIntExtensions
{
    public static void Add(this ICollection<StringAndInt> list, string myString, int myInt)
    {
        list.Add(new StringAndInt(myString, myInt));
    }
}

var myList = new List<StringAndInt>
{
    { "String", 0 }, 
    { "String", 1 }, 
    { "String", 2 }
};

Richard Deeming wrote:

Tricky with an array, but for a List<T> you can use an extension method:

Dictionary<string, int> dic = new Dictionary<string, int>() { { "AAA", 1 }, { "BBB", 2 }, { "CCC", 3 } };
KeyValuePair<string, int>[] array = dic.ToArray();

private List<(string str, int i)> TPLs = new List<(string , int)>
{
    ("hello", 0), ("goodbye", 1)
};

// use cases:

var item0 = TPLs[0];

string str = item0.str;

int igr = item0.i;

var index1 = TPLs.IndexOf(("goodbye", 1));

TPLs.Add((str: "whatever", i: 6));

public partial class Form1 : Form
    { 

        public Form1()
        {
            InitializeComponent();

        }

 ConnectionDB d = new ConnectionDB();

    using (OleDbCommand cmbox = d.sql_con.CreateCommand())
                {
                    cmbox.CommandText = "SELECT Code_article FROM Catalogue";
                    d.CONNECTER();// i have an error here
                    d.DR = cmbox.ExecuteReader();

                    try
                    {
                        while (d.DR.Read())
                        {
                            CmbRef_Produit.Items.Add(d.DR["Code_article"]).ToString();
                        }

                        //si le textbox est vide
                        if (string.IsNullOrWhiteSpace(CmbRef_Produit.Text ))
                        {
                            // Message box

                            Lbl_affich_TxtQteStock.Text = "";
                            Lbl_Affich_Designation.Text = "";
                            Lbl_Affich_PrixUnitaire.Text = "";
                        }

                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.ToString());

                        d.DECONNECTER();

                    }
                }

            }

}

using (ConnectionDB d = new ConnectionDB())
{
    d.CONNECTER();
    
    using (OleDbCommand cmbox = d.sql_con.CreateCommand())
    {
        cmbox.CommandText = "SELECT Code_article FROM Catalogue";

        // remaining code
    }
    d.DECONNECTER();
}

Thanks i will try it and you will get back

I try and the error comes from me thank you very much mmister it works.

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand cmd = new SqlCommand("SELECT Age, Description FROM myTable WHERE ID = @ID", con))
        {
        cmd.Parameters.AddWithValue("@ID", myTextBox.Text);
        using (SqlDataReader reader = cmd.ExecuteReader())
            {
            while (reader.Read())
                {
                int age = (int) reader["Age"];
                string desc = (string) reader["Description"];
                Console.WriteLine($"{age}\n{desc}");
                }
            }
        }
    }

thank you sir message well received. I haven't tried the configuration file side for the connection to the database yet, but I will study it and see if I can manage it.