unit1.cpp

调用存储过程

//---------------------------------------------------------------------------

#include <vcl.h>
#pragma hdrstop

#include "Unit1.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TForm1 *Form1;
//---------------------------------------------------------------------------
__fastcall TForm1::TForm1(TComponent* Owner)
        : TForm(Owner)
{
}
//---------------------------------------------------------------------------

void __fastcall TForm1::Button1Click(TObject *Sender)
{
String t1,t2,t3,t4;
TDateTime t5;
t1=Edit1->Text ;
t2=Edit2->Text ;
t3=Edit3->Text ;
t4=Edit4->Text ;
t5=DateTimePicker1->Date;
if(ComboBox1->Text!="")
{
 try
 {
       ADOStoredProc1->Parameters->Clear();
       ADOStoredProc1->ProcedureName= ComboBox1->Text;
      if(CheckBox1->Checked==true)
       {
       ADOStoredProc1->Parameters->CreateParameter("pl1",ftString,pdInput,11,t1); //pl1字符串
       ADOStoredProc1->Parameters->CreateParameter("pl1",ftString,pdInput,11,t2);
       ADOStoredProc1->Parameters->CreateParameter("pl1",ftString,pdInput,11,t3);
       ADOStoredProc1->Parameters->CreateParameter("pl1",ftString,pdInput,11,t4);
       ADOStoredProc1->Parameters->CreateParameter("pl1",ftDateTime,pdInput,11,t5);
        }

       ADOStoredProc1->ExecProc();
       
       Memo1->Lines->Add(" "+DateTimeToStr(Now())+" "+" 调用过程成功!");
      }
    catch(...)
     {
       Memo1->Lines->Add(" "+DateTimeToStr(Now())+" "+"  调用过程失败!");
     }
}
}
//---------------------------------------------------------------------------

void __fastcall TForm1::FormCreate(TObject *Sender)
{
ADOStoredProc1->ConnectionString="FILE NAME="+ ExtractFilePath(Application->ExeName)+"\\test1.udl" ;
}
//---------------------------------------------------------------------------