开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 电子书籍 > VC书籍 > 查看源码
Unit1.cpp
资源名称：C++Builder.rar　[点击查看]
上传用户：lhxd_sz
上传日期：2014-10-02
资源大小：38814k
文件大小：2k
源码类别：

VC书籍

开发平台：

C++ Builder

Unit1.cpp：源码内容
  1. //---------------------------------------------------------------------------
  2. #include <vcl.h>
  3. #pragma hdrstop
  5. #include "Unit1.h"
  6. //---------------------------------------------------------------------------
  7. #pragma package(smart_init)
  8. #pragma resource "*.dfm"
  9. TForm1 *Form1;
  10. //---------------------------------------------------------------------------
  11. __fastcall TForm1::TForm1(TComponent* Owner)
  12.         : TForm(Owner)
  13. {
  14. }
  15. //---------------------------------------------------------------------------
  17. void __fastcall TForm1::Button1Click(TObject *Sender)
  18. {
  19.   int ii;
  20.   AnsiString myfield,ass;
  21.   if(!OpenDialog1->Execute())return;
  22. //Query1初始化
  23.   Query1->Active=False;
  24.   Query1->SQL->Clear();
  25.   Query1->SQL->Add("select *");
  26.   ass="from ""+OpenDialog1->FileName+""";
  27.   Query1->SQL->Add(ass);
  28.   Query1->Active=True;
  29. //Table1初始化
  30.   Table1->Active=False;
  31.   Table1->TableName=OpenDialog1->FileName;
  32.   Table1->EmptyTable();
  33.   Table1->Active=True;
  34. //复制记录
  35.   while(!Query1->Eof)
  36.   {
  37.     Table1->Append();
  38.     for(ii=0;ii<Query1->FieldCount;ii++)
  39.     {
  40.       myfield=Table1->Fields->Fields[ii]->FieldName;
  41.       switch(Table1->Fields->Fields[ii]->DataType)
  42.       {
  43.         case ftString:
  44.           Table1->FieldByName(myfield)->AsString=Query1->FieldByName(myfield)->AsString;
  45.           break;
  46.         case ftSmallint:
  47.         case ftInteger:
  48.         case ftWord:
  49.           Table1->FieldByName(myfield)->AsInteger=Query1->FieldByName(myfield)->AsInteger;
  50.           break;
  51.         case ftBoolean:
  52.           Table1->FieldByName(myfield)->AsString=Query1->FieldByName(myfield)->AsString;
  53.           break;
  54.         case ftFloat:
  55.           Table1->FieldByName(myfield)->AsFloat=Query1->FieldByName(myfield)->AsFloat;
  56.           break;
  57.         case ftCurrency:
  58.           Table1->FieldByName(myfield)->AsCurrency=Query1->FieldByName(myfield)->AsCurrency;
  59.           break;
  60.         case ftDate:
  61.         case ftTime:
  62.         case ftDateTime:
  63.           Table1->FieldByName(myfield)->AsDateTime=Query1->FieldByName(myfield)->AsDateTime;
  64.           break;
  65.         default:
  66.           break;
  67.       }
  68.     }
  69.     Table1->Post();
  70.     Query1->Next();
  71.   }
  72. }
  73. //---------------------------------------------------------------------------