回 帖 发 新 帖 刷新版面

主题:请教:能帮我看一下,下面这个程序又错误吗?


#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)
{
       AnsiString sql;
       sql="insert into db1(ID,NAME,AGE)values('"+Edit1->Text+"','"+Edit2->Text+"',"+StrToInt(Edit3->Text)+")";
       ShowMessage(sql);
       ADOQuery1->SQL->Clear();
       ADOQuery1->SQL->Add(sql);
}

//---------------------------------------------------------------------------
void __fastcall TForm1::Button2Click(TObject *Sender)
{
        AnsiString sql;
        sql="select*from db1 where ID='"+Edit4->Text+"'";
        ADOQuery1->SQL->Clear();
        ADOQuery1->SQL->Add(sql);
        ADOQuery1->Open();
        Label1->Caption=ADOQuery1->FieldValues["NAME"];
}
//---------------------------------------------------------------------------

回复列表 (共1个回复)

沙发

Button1Click 中:
ADOQuery1->SQL->Add(sql);
sql->ExecSQL();

我来回复

您尚未登录,请登录后再回复。点此登录或注册