请教高人，我将dbgrid1的数据复制到了dbgrid2，怎么将dbgrid2的内容保存到mssql数据库中？dbgrid1和dbgrid2分别是oracle和mssql

Question

请教高人，我将dbgrid1的数据复制到了dbgrid2，怎么将dbgrid2的内容保存到mssql数据库中？dbgrid1和dbgrid2分别是oracle和mssql

Answer 1

with adoquery1.eof do
  begin
  ....
  adoquery1.next;
end;
大概思路应该是这样的

Answer 2

procedure   TForm1.Button1Click(Sender:   TObject);   
  var   
      i,   j:   Integer;   
      s:   string;   
  begin   
      if   DBGrid1.SelectedRows.Count>0   then   
          with   DBGrid1.DataSource.DataSet   do   
              for   i:=0   to   DBGrid1.SelectedRows.Count-1   do   
              begin   
                  GotoBook(pointer(DBGrid1.SelectedRows.Items[i]));   
                  DBGrid2.DataSource.DataSet.Append;   
                  DBGrid2.DataSource.DataSet.Fieldbyname('F1').value:=Fieldbyname('F1').value;   
                  ...   
                  DBGrid2.DataSource.DataSet.Fieldbyname('Fn').value:=Fieldbyname('Fn').value;   
              end;
我已经找到了这个解决办法了.