C#

var row = dataGridView1.Rows[i];

DataGridViewRow row = dataGridView1.Rows[i];

var pN = command.Parameters.Add(...);

OdbcParameter pN = command.Parameters.Add(...);

using (var connection = new OdbcConnection(lc.Connexion_locale))
                using (var command = new OdbcCommand("insert into thisdet2 values(cat,geo,etb,nobl,vend,fam,art,des,tare)", connection))
                {
                    // ODBC doesn't use named parameters, so the names don't matter:

                    OdbcParameter cat = command.Parameters.Add("@cat", OdbcType.NVarChar);
                    OdbcParameter geo = command.Parameters.Add("@geo", OdbcType.NVarChar);
                    OdbcParameter etb = command.Parameters.Add("@etb", OdbcType.NVarChar);
                    OdbcParameter nobl = command.Parameters.Add("@nobl", OdbcType.NVarChar);
                    OdbcParameter vend = command.Parameters.Add("@vend", OdbcType.NVarChar);
                    OdbcParameter fam = command.Parameters.Add("@fam", OdbcType.NVarChar);
                    OdbcParameter art = command.Parameters.Add("@art", OdbcType.NVarChar);
                    OdbcParameter des = command.Parameters.Add("@des", OdbcType.NVarChar);
                    OdbcParameter tare = command.Parameters.Add("@tare", OdbcType.NVarChar);
                    

                    connection.Open();

                    for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
                    {
                       // DataGridViewRow row = dataGridView1.Rows[i];
                        OdbcParameter row = dataGridView1.Rows[i];

                        cat = row.Cells[0].Value;
                        geo = row.Cells[1].Value;
                        etb = row.Cells[2].Value;
                        nobl = row.Cells[3].Value;
                        vend = row.Cells[4].Value;
                        fam = row.Cells[5].Value;
                        art = row.Cells[6].Value;
                        des = row.Cells[7].Value;
                        tare = row.Cells[8].Value;

                                command.ExecuteNonQuery();
                    }
                }

using (var command = new OdbcCommand("insert into thisdet2 values(?,?,?,?,?,?,?,?,?)", connection))

using (var command = new OdbcCommand("insert into thisdet2 (cat,geo,etb,nobl,vend,fam,art,des,tare) values(?,?,?,?,?,?,?,?,?)", connection))

using (OdbcConnection connection = new OdbcConnection(lc.Connexion_locale))
using (OdbcCommand command = new OdbcCommand("insert into thisdet2 (cat,geo,etb,nobl,vend,fam,art,des,tare) values (?,?,?,?,?,?,?,?,?)", connection))
{
    // ODBC doesn't use named parameters, so the names don't matter:

    OdbcParameter cat = command.Parameters.Add("@cat", OdbcType.NVarChar);
    OdbcParameter geo = command.Parameters.Add("@geo", OdbcType.NVarChar);
    OdbcParameter etb = command.Parameters.Add("@etb", OdbcType.NVarChar);
    OdbcParameter nobl = command.Parameters.Add("@nobl", OdbcType.NVarChar);
    OdbcParameter vend = command.Parameters.Add("@vend", OdbcType.NVarChar);
    OdbcParameter fam = command.Parameters.Add("@fam", OdbcType.NVarChar);
    OdbcParameter art = command.Parameters.Add("@art", OdbcType.NVarChar);
    OdbcParameter des = command.Parameters.Add("@des", OdbcType.NVarChar);
    OdbcParameter tare = command.Parameters.Add("@tare", OdbcType.NVarChar);
    
    connection.Open();
    
    for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
    {
        DataGridViewRow row = dataGridView1.Rows[i];
        
        cat.Value = row.Cells[0].Value;
        geo.Value = row.Cells[1].Value;
        etb.Value = row.Cells[2].Value;
        nobl.Value = row.Cells[3].Value;
        vend.Value = row.Cells[4].Value;
        fam.Value = row.Cells[5].Value;
        art.Value = row.Cells[6].Value;
        des.Value = row.Cells[7].Value;
        tare.Value = row.Cells[8].Value;
        
        command.ExecuteNonQuery();
    }
}

Linus Agren wrote:

How could I use the code for this?

Linus Agren wrote:

but I cannot figure out how to use the hook properly.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Error	1	The type or namespace name 'UserActivityHook' could not be found (are you missing a using directive or an assembly reference?)

using System;
using System.Windows.Forms;
using MouseKeyboardActivityMonitor;
using MouseKeyboardActivityMonitor.WinApi;

namespace Test_Mama_HotKey
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            m_KeyboardHookManager = new KeyboardHookListener(new AppHooker());
            m_KeyboardHookManager.Enabled = true;
            m_KeyboardHookManager.KeyDown += HookManager_KeyDown;
        }

        private readonly KeyboardHookListener m_KeyboardHookManager;

        private void HookManager_KeyDown(object sender, KeyEventArgs e)
        {
            Log(string.Format("{0} {1} {2}", ActiveForm.Text, ActiveForm.ActiveControl.Name, e.KeyData));
        }

        private void Log(string text)
        {
            textBox1.AppendText(string.Format("{0}{1}", text, Environment.NewLine));
        }

        // other code removed
    }
}

D.DateTime.ToString("yyyy") + "/" + D.DateTime.ToString("MM")

D.DateTime.ToString("yyyy/MM")