Click here to Skip to main content
15,919,749 members
Home / Discussions / C#
   

C#

 
GeneralRe: mouse simulation code c# Pin
Omarkkk24-Feb-15 22:11
Omarkkk24-Feb-15 22:11 
GeneralRe: mouse simulation code c# Pin
OriginalGriff24-Feb-15 22:13
mveOriginalGriff24-Feb-15 22:13 
GeneralRe: mouse simulation code c# Pin
Omarkkk24-Feb-15 22:16
Omarkkk24-Feb-15 22:16 
GeneralRe: mouse simulation code c# Pin
Omarkkk24-Feb-15 22:18
Omarkkk24-Feb-15 22:18 
GeneralRe: mouse simulation code c# Pin
OriginalGriff24-Feb-15 22:44
mveOriginalGriff24-Feb-15 22:44 
GeneralRe: mouse simulation code c# Pin
Omarkkk26-Feb-15 0:52
Omarkkk26-Feb-15 0:52 
GeneralRe: mouse simulation code c# Pin
OriginalGriff26-Feb-15 1:05
mveOriginalGriff26-Feb-15 1:05 
GeneralRe: mouse simulation code c# Pin
Omarkkk26-Feb-15 1:23
Omarkkk26-Feb-15 1:23 
GeneralRe: mouse simulation code c# Pin
OriginalGriff26-Feb-15 1:59
mveOriginalGriff26-Feb-15 1:59 
AnswerRe: mouse simulation code c# Pin
Manfred Rudolf Bihy24-Feb-15 22:40
professionalManfred Rudolf Bihy24-Feb-15 22:40 
QuestionConvert code C# 2008 to code C# 2005 ? Pin
Member 245846724-Feb-15 21:39
Member 245846724-Feb-15 21:39 
AnswerRe: Convert code C# 2008 to code C# 2005 ? Pin
Simon_Whale24-Feb-15 21:56
Simon_Whale24-Feb-15 21:56 
AnswerRe: Convert code C# 2008 to code C# 2005 ? Pin
OriginalGriff24-Feb-15 22:05
mveOriginalGriff24-Feb-15 22:05 
GeneralRe: Convert code C# 2008 to code C# 2005 ? Pin
Member 245846725-Feb-15 16:22
Member 245846725-Feb-15 16:22 
GeneralRe: Convert code C# 2008 to code C# 2005 ? Pin
OriginalGriff25-Feb-15 21:51
mveOriginalGriff25-Feb-15 21:51 
GeneralRe: Convert code C# 2008 to code C# 2005 ? Pin
Member 24584673-Mar-15 15:42
Member 24584673-Mar-15 15:42 
QuestionInsert the data of datagridview in a database. Pin
Ibrahim.elh24-Feb-15 20:45
Ibrahim.elh24-Feb-15 20:45 
QuestionRe: Insert the data of datagridview in a database. Pin
Eddy Vluggen25-Feb-15 0:31
professionalEddy Vluggen25-Feb-15 0:31 
AnswerRe: Insert the data of datagridview in a database. Pin
Ibrahim.elh25-Feb-15 1:55
Ibrahim.elh25-Feb-15 1:55 
GeneralRe: Insert the data of datagridview in a database. Pin
Richard Deeming25-Feb-15 2:09
mveRichard Deeming25-Feb-15 2:09 
Your code is vulnerable to SQL Injection[^].

NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query.

The ArgumentOutOfRangeException suggests that your rows don't contain 12 cells. (You're ignoring the first cell.) Did you actually mean to take the values from 11 cells, starting at index 0?

You're creating a new OdbcDataAdapter for each row in the grid, and then throwing away all but the last one.

You're specifying an INSERT command as the SelectCommand property of the data adapter.

Assuming you just want to insert the rows into the table, try something like this:
C#
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();
    }
}




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer



modified 25-Feb-15 10:54am.

GeneralRe: Insert the data of datagridview in a database. Pin
Ibrahim.elh25-Feb-15 2:58
Ibrahim.elh25-Feb-15 2:58 
GeneralRe: Insert the data of datagridview in a database. Pin
Richard Deeming25-Feb-15 3:02
mveRichard Deeming25-Feb-15 3:02 
GeneralRe: Insert the data of datagridview in a database. Pin
Ibrahim.elh25-Feb-15 3:06
Ibrahim.elh25-Feb-15 3:06 
GeneralRe: Insert the data of datagridview in a database. Pin
Richard Deeming25-Feb-15 3:10
mveRichard Deeming25-Feb-15 3:10 
GeneralRe: Insert the data of datagridview in a database. Pin
Ibrahim.elh25-Feb-15 3:12
Ibrahim.elh25-Feb-15 3:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.