C#

Member 2458467 wrote:

this.gridControl1.DataSource = this.lstCustomData.Where<customdata>(expr.Compile()).ToList();

Member 2458467 wrote:

do not know how to write without LINKQ

Ibrahim.elh wrote:

Is what you have ideas to insert data into datagridview my new base.

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

con_local = new OdbcConnection();
                con_local.ConnectionString = lc.Connexion_locale;
                con_local.Open();
                for(int i=0; i< dataGridView1.Rows.Count-1;i++)
                {
                    
                    adap_local = new OdbcDataAdapter("insert into thisdet2 values(" + dataGridView1.Rows[i].Cells[1].Value + "," + dataGridView1.Rows[i].Cells[2].Value + "," + dataGridView1.Rows[i].Cells[3].Value + "," + dataGridView1.Rows[i].Cells[4].Value + "," + dataGridView1.Rows[i].Cells[5].Value + "," + dataGridView1.Rows[i].Cells[6].Value + "," + dataGridView1.Rows[i].Cells[7].Value + "," + dataGridView1.Rows[i].Cells[8].Value + "," + dataGridView1.Rows[i].Cells[9].Value + "," + dataGridView1.Rows[i].Cells[10].Value + "," + dataGridView1.Rows[i].Cells[11].Value + "," +  +")"+",", con_local);
                }
                ds_local = new System.Data.DataSet();
                adap_local.Fill(ds_local);

using (var connection = new OdbcConnection(lc.Connexion_locale))
using (var command = new OdbcCommand("insert into thisdet2 values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", connection))
{
    // ODBC doesn't use named parameters, so the names don't matter:
    var p0 = command.Parameters.Add("@p0", OdbcType.NVarChar);
    var p1 = command.Parameters.Add("@p1", OdbcType.NVarChar);
    var p2 = command.Parameters.Add("@p2", OdbcType.NVarChar);
    var p3 = command.Parameters.Add("@p3", OdbcType.NVarChar);
    var p4 = command.Parameters.Add("@p4", OdbcType.NVarChar);
    var p5 = command.Parameters.Add("@p5", OdbcType.NVarChar);
    var p6 = command.Parameters.Add("@p6", OdbcType.NVarChar);
    var p7 = command.Parameters.Add("@p7", OdbcType.NVarChar);
    var p8 = command.Parameters.Add("@p8", OdbcType.NVarChar);
    var p9 = command.Parameters.Add("@p9", OdbcType.NVarChar);
    var p10 = command.Parameters.Add("@p10", OdbcType.NVarChar);
    var p11 = command.Parameters.Add("@p11", OdbcType.NVarChar);
    
    connection.Open();
    
    for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
    {
        var row = dataGridView1.Rows[i];
        
        p0.Value = row.Cells[0].Value;
        p1.Value = row.Cells[1].Value;
        p2.Value = row.Cells[2].Value;
        p3.Value = row.Cells[3].Value;
        p4.Value = row.Cells[4].Value;
        p5.Value = row.Cells[5].Value;
        p6.Value = row.Cells[6].Value;
        p7.Value = row.Cells[7].Value;
        p8.Value = row.Cells[8].Value;
        p9.Value = row.Cells[9].Value;
        p10.Value = row.Cells[10].Value;
        p11.Value = row.Cells[11].Value;
        
        command.ExecuteNonQuery();
    }
}

Ibrahim.elh wrote:

does not include visual studio .cells []

row.Cells[0].Value

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