2,497
社区成员
发帖
与我相关
我的任务
分享
procedure TForm1.Button1Click(Sender: TObject);
var s:string; s1:string;
begin
Adoconnection1.Connected:=False;
label3.Caption:=GetcurrentDir();
XMLDocument1.LoadFromFile(GetcurrentDir()+'\tmp.xml');
dbip:=XMLDocument1.DocumentElement.ChildNodes[0].ChildNodes['dbip'].Text;
db:=XMLDocument1.DocumentElement.ChildNodes[0].ChildNodes['db'].Text;
ps:=XMLDocument1.DocumentElement.ChildNodes[0].ChildNodes['ps'].Text;
usr:=XMLDocument1.DocumentElement.ChildNodes[0].ChildNodes['usr'].Text;
s:= format('Provider=SQLOLEDB.1;Password=%s;Persist Security Info=True;User ID=%s;Initial Catalog=%s;Data Source=%s',[ps,usr,db,dbip]) ;
Adoconnection1.ConnectionString := s;
Adoconnection1.Connected:=True;
with Form1.ADOQuery1 do
begin
ADOQuery1.Close;
ADOQuery1.SQL.Add('select * from SYS_Users where code =:Code and Password = :Password');
ADOQuery1.Parameters.ParamByName('Code').Value:= edtAccount.Text;
ADOQuery1.Parameters.ParamByName('Password').Value := trim(edtPassword.Text);
ADOQuery1.Open;
end;
end;
ADOCon.Connected:=False;
ADOCon.ConnectionString:='Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=数据管理;Data Source=LYHOO2';
ADOCon.ConnectionString:=ConnectionString;
ADOCon.Connected:=True;
Adoconnection.Connected:=True; 执行此句,控件原连接数据库。
在窗体上直接EditConnectString连接数据库的方式却能读出来数据,是因为窗体上点击时,窗体中运行了此句。直接连接上了。