简单ADO问题,答了就的分 ADOCONNECTION连接数据源,ADOTABLE取表,EDIT输入要添加或修改的数据,怎么写到数据库里,具体的语句是什么,谢谢~ 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 ADO的连接SQLSERVER:ADO.connectionstring:="Provider=SQLOLEDB.1;Password=pwd;Persist Security Info=True;User ID=uid;Initial Catalog=banen;Data Source=remoteserver;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SLIENCE;Use Encryption for Data=False;Tag with column collation when possible=False"Ado.mode:=cmReadWrite;取表ADOtable1.tablename="table1";Adotable1.ACTIVE:=TRUE修改ADOTABLE1。EDITADOTABLE1。...AODTABLE1。POST添加ADOTABLE1。APPENDADOTABLE1。...AODTABLE1。POST 双击 ADOConnection 组件配置连接字符串ADOTable1.Connection:=ADOConnection1;ADOTable1.TableName:='ATable';ADOTable1.Open;ADOTable1.Append;ADOTable1.FieldValues['...']:=....;ADOTable1.Post;ADOTable1.Edit;ADOTable1.FieldValues['...']:=....;ADOTable1.Post; 取表ADOtable1.tablename="table1";Adotable1.ACTIVE:=TRUE修改ADOTABLE1.EDIT;ADOTABLE1.fieldbyname('11').asstring := edit1.text;ADOTABLE1.fieldbyname('22').asstring := edit2.text;...AODTABLE1.POST添加ADOTABLE1.insert;ADOTABLE1.fieldbyname('11').asstring := edit1.text;ADOTABLE1.fieldbyname('22').asstring := edit2.text;... with AdoTable1 dobegin tablename := '你要的表名';//取得表名 active := true;//连接 Edit;//修改状态未可修改状态 Fieldbyname('表中的字段').Asstring := Edit1.text;//把表中要修改的字段得值改为Edit1中的值 …………//以此类推 Post;//提交 append(or insert);修改状态未可添加状态 Fieldbyname('表中的字段').Asstring := Edit1.text;//把表中要插入的字段得值改为Edit1中的值 post;//提交end; 取表ADOtable1.tablename="table1";Adotable1.ACTIVE:=TRUE修改ADOTABLE1.EDIT;ADOTABLE1.fieldbyname('11').asstring := edit1.text;ADOTABLE1.fieldbyname('22').asstring := edit2.text;...AODTABLE1.POST添加ADOTABLE1.insert;ADOTABLE1.fieldbyname('11').asstring := edit1.text;ADOTABLE1.fieldbyname('22').asstring := edit2.text; 我认为在开发中还是用ADOQUERY比较好,数据库的增删改还是通过QUERY调用SQL好一些。我在实际开发中遇到的用EDIT,然后修改数据对长的字符支持的不好,到40个字以上的就有奇怪的截断,并且你如果发现数据库的字段长度不够改了的时候用EDIT的不能及时的感知! ADO的连接SQLSERVER:ADO.connectionstring:="Provider=SQLOLEDB.1;Password=pwd;Persist Security Info=True;User ID=uid;Initial Catalog=banen;Data Source=remoteserver;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SLIENCE;Use Encryption for Data=False;Tag with column collation when possible=False"Ado.mode:=cmReadWrite;取表ADOquery.sql='insert into table1 values('+"'"+edit1.text+"'"+')'tryADOquery.exec;exceptshowmessage('error')end;ADOquery.sql='update table set ziduan ='+edit1.text;exceptshowmessage('error')end; 比bitblt和stretchblt效率更高的函数,200分! Query用DatabaseName后的查询 请教Arj命令路径过长的问题! 上帝为我们安排的规则 如何将EXCEL的数据导入ACCESS数据库 pchar的用法?100分 谁能帮我看看这个问题出在那里呀为什么只能调用一次过程? 请大家说说自己常用的API函数 还是ShellExecute,12:00前揭帖. 大家平时工作中都用什么工具??? 怎么让TDBComboBox把设置好的纪录全部显示, 有没有这样的控件,立即揭帖〉〉〉
ADO.connectionstring:="Provider=SQLOLEDB.1;Password=pwd;Persist Security Info=True;User ID=uid;Initial Catalog=banen;Data Source=remoteserver;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SLIENCE;Use Encryption for Data=False;Tag with column collation when possible=False"
Ado.mode:=cmReadWrite;取表
ADOtable1.tablename="table1";
Adotable1.ACTIVE:=TRUE
修改
ADOTABLE1。EDIT
ADOTABLE1。...
AODTABLE1。POST
添加
ADOTABLE1。APPEND
ADOTABLE1。...
AODTABLE1。POST
ADOTable1.Connection:=ADOConnection1;
ADOTable1.TableName:='ATable';
ADOTable1.Open;
ADOTable1.Append;
ADOTable1.FieldValues['...']:=....;
ADOTable1.Post;
ADOTable1.Edit;
ADOTable1.FieldValues['...']:=....;
ADOTable1.Post;
ADOtable1.tablename="table1";
Adotable1.ACTIVE:=TRUE
修改
ADOTABLE1.EDIT;
ADOTABLE1.fieldbyname('11').asstring := edit1.text;
ADOTABLE1.fieldbyname('22').asstring := edit2.text;
...
AODTABLE1.POST
添加
ADOTABLE1.insert;
ADOTABLE1.fieldbyname('11').asstring := edit1.text;
ADOTABLE1.fieldbyname('22').asstring := edit2.text;
...
begin
tablename := '你要的表名';//取得表名
active := true;//连接
Edit;//修改状态未可修改状态
Fieldbyname('表中的字段').Asstring := Edit1.text;//把表中要修改的字段得值改为Edit1中的值
…………//以此类推
Post;//提交
append(or insert);修改状态未可添加状态
Fieldbyname('表中的字段').Asstring := Edit1.text;//把表中要插入的字段得值改为Edit1中的值
post;//提交
end;
ADOtable1.tablename="table1";
Adotable1.ACTIVE:=TRUE
修改
ADOTABLE1.EDIT;
ADOTABLE1.fieldbyname('11').asstring := edit1.text;
ADOTABLE1.fieldbyname('22').asstring := edit2.text;
...
AODTABLE1.POST
添加
ADOTABLE1.insert;
ADOTABLE1.fieldbyname('11').asstring := edit1.text;
ADOTABLE1.fieldbyname('22').asstring := edit2.text;
ADO.connectionstring:="Provider=SQLOLEDB.1;Password=pwd;Persist Security Info=True;User ID=uid;Initial Catalog=banen;Data Source=remoteserver;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SLIENCE;Use Encryption for Data=False;Tag with column collation when possible=False"
Ado.mode:=cmReadWrite;取表
ADOquery.sql='insert into table1 values('+"'"+edit1.text+"'"+')'
try
ADOquery.exec;
except
showmessage('error')
end;
ADOquery.sql='update table set ziduan ='+edit1.text;
except
showmessage('error')
end;