stringgrid in mysql datenbank

[mkinzler]

Zitat von netscanner:

Insert über die Cols
Was meinst du damit??

Delphi-Quellcode:

query.SQL.Text := 'insert into <tabelle>(<feldliste>) values ( :p1, :p2, ...)';
for line := 0 to StringGrid.RowCount -1 do
begin
    for col := 0 to StrinGrid.ColCount -1 do
    begin
        query.Params[col].Value = StringGrid.Cells[line, col];
    end;
    query.ExecSQL;
end;