张志峰的博客

水滴石川,积少成多。

导航

Delphi 为TClientdataset定义结果集,并增加记录

Posted on 2013-08-16 17:26  ╰★张志峰★╮  阅读(1001)  评论(0)    收藏  举报

Delphi 为TClientdataset定义结果集,并增加记录 


procedure addDefsFieldsForCDS(aDataSet: TClientDataSet);
begin
  aDataSet.Data := null;
  aDataSet.FieldDefs.Clear;
  aDataSet.FieldDefs.Add('ID', ftString, 100);
  aDataSet.FieldDefs.Add('CODE', ftString, 100);
  aDataSet.FieldDefs.Add('NEW_L_CODE', ftString, 100);
  aDataSet.FieldDefs.Add('OLD_L_CODE', ftString, 100);
  aDataSet.CreateDataSet;
end;

procedure TForm1.Button1Click(Sender: TObject);
begin
 addDefsFieldsForCDS(ClientDataSet1);
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
  ClientDataSet1.Append;
  ClientDataSet1.FieldByName('ID').AsString := '100';
  ClientDataSet1.FieldByName('CODE').AsString := '100';
  ClientDataSet1.FieldByName('NEW_L_CODE').AsString := '100';
  ClientDataSet1.FieldByName('OLD_L_CODE').AsString := '100';
  ClientDataSet1.Post;
end;