📄 tclientdataset的使用技巧.mht
字号:
From: <由 Microsoft Internet Explorer 5 保存>
Subject: =?gb2312?B?1tC7qrXnxNTK6b/iLS1UQ2xpZW50RGF0YVNldLXEyrnTw7y8x8ktLQ==?=
=?gb2312?B?1NrP373Ms8wstefE1L3Ms8wstefE1M7E1aqhow==?=
Date: Sat, 28 Jul 2007 16:04:21 +0800
MIME-Version: 1.0
Content-Type: multipart/related;
type="text/html";
boundary="----=_NextPart_000_0033_01C7D130.F5DBB300"
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
This is a multi-part message in MIME format.
------=_NextPart_000_0033_01C7D130.F5DBB300
Content-Type: text/html;
charset="gb2312"
Content-Transfer-Encoding: quoted-printable
Content-Location: http://www.pcbookcn.com/article/3679.htm
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- =
=D6=D0=BB=AA=B5=E7=C4=D4=CA=E9=BF=E2-=B5=E7=D7=D3=CD=BC=CA=E9,=B5=E7=C4=D4=
=CA=E9=BC=AE,=B5=E7=C4=D4=BD=CC=D1=A7, =
=B5=E7=C4=D4=BD=CC=B3=CC,=B5=E7=C4=D4=CE=C4=D5=AA,=D4=C4=B6=C1TClientData=
Set=B5=C4=CA=B9=D3=C3=BC=BC=C7=C9,=B1=A3=B4=E6TClientDataSet=B5=C4=CA=B9=D3=
=C3=BC=BC=C7=C9,=CA=D5=B2=D8TClientDataSet=B5=C4=CA=B9=D3=C3=BC=BC=C7=C9-=
-><HTML><HEAD><TITLE>=D6=D0=BB=AA=B5=E7=C4=D4=CA=E9=BF=E2--TClientDataSet=
=B5=C4=CA=B9=D3=C3=BC=BC=C7=C9--=D4=DA=CF=DF=BD=CC=B3=CC,=B5=E7=C4=D4=BD=CC=
=B3=CC,=B5=E7=C4=D4=CE=C4=D5=AA=A1=A3</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dgb2312">
<META http-equiv=3DContent-Language content=3Dzh-cn>
<META name=3Dkeywords=20
contect=3D"=D4=C4=B6=C1TClientDataSet=B5=C4=CA=B9=D3=C3=BC=BC=C7=C9,=B1=A3=
=B4=E6TClientDataSet=B5=C4=CA=B9=D3=C3=BC=BC=C7=C9,=CA=D5=B2=D8TClientDat=
aSet=B5=C4=CA=B9=D3=C3=BC=BC=C7=C9">
<META=20
content=3D=D6=D0=BB=AA=B5=E7=C4=D4=CA=E9=BF=E2,=CE=AA=C4=FA=CC=E1=B9=A9=D7=
=EE=BA=C3=B5=C4=B5=E7=C4=D4=CE=C4=D5=AA=A3=A1=D4=DA=B1=BE=D2=B3=C4=FA=BF=C9=
=D2=D4=D4=C4=B6=C1TClientDataSet=B5=C4=CA=B9=D3=C3=BC=BC=C7=C9,=B1=A3=B4=E6=
TClientDataSet=B5=C4=CA=B9=D3=C3=BC=BC=C7=C9,=CA=D5=B2=D8TClientDataSet=B5=
=C4=CA=B9=D3=C3=BC=BC=C7=C9=20
name=3Ddescription>
<META name=3DRobots contect=3D"all"><LINK=20
href=3D"http://www.pcbookcn.com/images/style.css" type=3Dtext/css =
rel=3Dstylesheet>
<STYLE type=3Dtext/css>.STYLE3 {
FONT-WEIGHT: bold; COLOR: #000000
}
</STYLE>
<META content=3D"MSHTML 6.00.3790.1830" name=3DGENERATOR></HEAD>
<BODY text=3D#000000 leftMargin=3D0 =
background=3Dhttp://www.pcbookcn.com/images/bj.jpg=20
topMargin=3D0>
<SCRIPT language=3DJavaScript src=3D"http://www.pcbookcn.com/js/top.js">
</SCRIPT>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D760 align=3Dcenter =
border=3D0>
<TBODY>
<TR>
<TD bgColor=3D#ffffff>
<TABLE height=3D33 cellSpacing=3D0 cellPadding=3D0 width=3D752 =
align=3Dcenter=20
background=3Dhttp://www.pcbookcn.com/images/search_bg.gif =
border=3D0>
<TBODY>
<TR>
<FORM action=3D../search.asp method=3Dpost target=3D_blank>
<TD align=3Dmiddle width=3D9 height=3D24><A=20
=
href=3D"http://www.pcbookcn.com/article/new/n0.htm"></A></TD>
<TD align=3Dmiddle width=3D300 height=3D24>
<DIV align=3Dleft><A =
href=3D"http://www.pcbookcn.com/new/n0.htm"=20
target=3D_blank>=D7=EE=BD=FC=B8=FC=D0=C2</A> <A=20
href=3D"http://www.pcbookcn.com/sort/index.htm"=20
target=3D_blank>=CA=E9=BC=AE=B7=D6=C0=E0</A><SPAN =
lang=3Den-us> <A=20
href=3D"http://www.pcbookcn.com/article/index.htm"=20
target=3D_blank>=CE=C4=D5=C2=B7=D6=C0=E0</A></SPAN> <A=20
=
href=3D"http://www.pcbookcn.com/search.asp?type=3Dsoft&pl=3Dhits"=20
target=3D_blank>=CF=C2=D4=D8=C5=C5=D0=D0</A><FONT =
color=3D#ff00ff> </FONT></DIV></TD>
<TD vAlign=3Dcenter align=3Dmiddle width=3D300 =
height=3D24>=A1=A1 <INPUT size=3D15=20
name=3Dk> <SELECT name=3Dtype> <OPTION value=3Dsoft=20
selected>=CA=E9=BC=AE=CF=C2=D4=D8</OPTION> <OPTION =
value=3Dinfo>=B5=E7=C4=D4=CE=C4=D5=AA</OPTION></SELECT> <INPUT =
type=3Dsubmit value=3D=CB=D1=CB=F7 name=3DSubmit> </TD>
<TD align=3Dmiddle width=3D149 height=3D24>
<DIV align=3Dcenter><FONT color=3D#ffffff><SPAN =
class=3Dstandard><FONT=20
color=3D#0066ff><B><FONT color=3D#333333>
<SCRIPT src=3D"http://www.pcbookcn.com/online.asp"></SCRIPT>
=
</FONT></B></FONT></SPAN></FONT></DIV></TD></FORM></TR></TBODY></TABLE></=
TD></TR></TBODY></TABLE>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D760 align=3Dcenter =
border=3D0>
<TBODY>
<TR>
<TD align=3Dmiddle bgColor=3D#ffffff height=3D27>
<TABLE height=3D27 cellSpacing=3D0 cellPadding=3D0 width=3D752=20
background=3Dhttp://www.pcbookcn.com/images/weizhi_bg.gif =
border=3D0>
<TBODY>
<TR>
<TD align=3Dmiddle width=3D30><IMG height=3D14=20
src=3D"http://www.pcbookcn.com/images/home.gif" =
width=3D14></TD>
<TD>=C4=FA=B5=C4=CE=BB=D6=C3=A3=BA <A =
href=3D"http://www.pcbookcn.com/index.htm">=CA=D7=D2=B3</A>-> <A=20
=
href=3D"http://www.pcbookcn.com/article/index.htm">=B5=E7=C4=D4=CE=C4=D5=AA=
</A>-> <A=20
=
href=3D"http://www.pcbookcn.com/article/6_1.htm">=CA=FD=BE=DD=BF=E2=C0=E0=
</A>-> <A=20
=
href=3D"http://www.pcbookcn.com/article/56_1.htm">=C6=E4=CB=FC</A>-> =
=D5=FD=CE=C4=20
</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D760 align=3Dcenter =
border=3D0>
<TBODY>
<TR>
<TD vAlign=3Dtop width=3D580 bgColor=3D#ffffff>
<DIV align=3Dcenter><BR>
<TABLE style=3D"TABLE-LAYOUT: fixed; BORDER-COLLAPSE: collapse"=20
cellSpacing=3D0 cellPadding=3D0 width=3D"96%" align=3Dcenter =
border=3D0>
<TBODY>
<TR>
<TD align=3Dmiddle width=3D"100%" bgColor=3D#ffffff=20
height=3D20><STRONG><FONT color=3D#004fc6><FONT=20
face=3D"Arial, Helvetica, =
sans-serif">TClientDataSet=B5=C4=CA=B9=D3=C3=BC=BC=C7=C9</FONT></FONT></S=
TRONG></TD></TR>
<TR>
<TD align=3Dmiddle width=3D"100%"=20
background=3Dhttp://www.pcbookcn.com/images/line.gif =
height=3D3></TD></TR>
<TR>
<TD width=3D"100%" height=3D2></TD></TR>
<TR>
<TD width=3D"100%" height=3D38>
<DIV align=3Dcenter><B>=D7=F7=D5=DF</B>=A3=BA<SPAN =
lang=3Den-us>=D8=FD=C3=FB</SPAN>=20
<B>=C0=B4=D4=B4</B>=A3=BA<SPAN lang=3Den-us>InterNet</SPAN> =
<B>=BC=D3=C8=EB=CA=B1=BC=E4</B>=A3=BA2007-1-26=20
</DIV></TD></TR>
<TR>
<TD class=3Dmain vAlign=3Dtop width=3D"100%">
<SCRIPT language=3DJavaScript=20
src=3D"http://www.pcbookcn.com/js/ads_a3.js"></SCRIPT>
<SPAN=20
=
class=3Dmain>=D4=DA=C8=FD=B2=E3=BD=E1=B9=B9=D6=D0=A3=ACTClientDataSet=B5=C4=
=B5=D8=CE=BB=CA=C7=B2=BB=BF=C9=B9=C0=C1=BF=B5=C4=A3=AC=CB=FD=B5=C4=CA=B9=D3=
=C3=D5=FD=C8=B7=D3=EB=B7=F1=A3=AC=CA=C7=CA=AE=B7=D6=B9=D8=BC=FC=B5=C4=A3=AC=
<BR>=B1=BE=CE=C4=B4=D3=D2=D4=CF=C2=BC=B8=B8=F6=B7=BD=C3=E6=B2=FB=CA=F6=CB=
=FD=B5=C4=CA=B9=D3=C3=A3=AC=CF=A3=CD=FB=B6=D4=C4=E3=D3=D0=CB=F9=B0=EF=D6=FA=
.<BR>1.=B6=AF=CC=AC=CB=F7=D2=FD<BR>procedure=20
TForm1.DBGrid1TitleClick(Column: TColumn);<BR>begin<BR>if =
(not=20
column.Field is Tblobfield)=20
=
then//Tblobfield=B2=BB=C4=DC=CB=F7=D2=FD=A3=AC=B6=FE=BD=F8=D6=C6<BR>Clien=
tDataSet1.IndexFieldNames:=3Dcolumn.Field.FieldName;<BR>end;<BR>2.=B6=E0=B2=
=E3=BD=E1=B9=B9=D6=D0=D6=F7=B4=D3=B1=ED=B5=C4=CA=B5=CF=D6<BR>=C9=E8=D6=F7=
=B1=EDClientDataSet1.packetrecord=CE=AA-1=A3=AC=CB=F9=D3=D0=BC=C7=C2=BC<B=
R>=C9=E8=B4=D3=B1=EDClientDataSet1.packetrecord=CE=AA0=A3=AC=B5=B1=C7=B0=BC=
=C7=C2=BC<BR>3.Taggregates=CA=B9=D3=C3<BR>=A3=A81=A3=A9=D4=DA=D7=D6=B6=CE=
=B1=E0=BC=AD=D6=D0add=20
new field=C0=E0=D0=CD=CE=AAaggregates<BR> =20
=
=BA=F3=C9=E8=D6=C3expression=A3=A8=B1=ED=B4=EF=CA=D4)<BR> =
=20
=C9=E8=D6=C3active:=3Dtrue=BC=B4=BF=C9<BR> =
=20
=
=CA=B9=D3=C3dbedit=B5=C4field=CE=AA=C7=B0=D5=DF=BC=B4=BF=C9<BR>=A3=A8=
2=A3=A9=CA=B9=D3=C3Aggergates=CA=F4=D0=D4add=C9=E8=BC=C6=B1=ED=B4=EF=CA=D4=
<BR> =20
=20
=
=B5=F7=D3=C3<BR>=A1=A1=A1=A1showmessage(floattostr(ClientDataSet1.Aggrega=
tes.Count));<BR>=A1=A1=A1=A1showmessage(ClientDataSet1.Aggregates.Items[0=
].Value);<BR>=A1=A1<BR>4.=D4=DA=B5=A5=B2=E3=CA=FD=BE=DD=BF=E2=D6=D0=B2=BB=
=D2=AABDE<BR> =20
=
=CA=B9=D3=C3ClientDataSet=B4=FA=CC=E6table,=CA=B9=D3=C3ClientDataSet=B5=C4=
loadfilename=D7=B0=C8=EBcds<BR> =20
=
=B4=FA=CC=E6table=B5=C4tablename=B5=C4db=BB=F2=D5=DFdbf<BR> =
=D4=AD=C0=B4=B5=C4=B3=CC=D0=F2=B8=C4=D4=EC=B7=BD=B7=A8:<BR> =20
=
=BC=D3=D2=BB=B8=F6ClientDataSet=A3=AC=CA=B9=D3=C3=D3=D2=BC=FCassign =
locate data<BR> =20
=
=BA=F3savetofile,=D4=D9loadfromfile,=BA=F3=C9=BE=B3=FDtable<BR> =20
=
=BD=AB=D4=AD=C1=ACtable=B5=C4datasource=C9=E8=CE=AAClientDataSet<BR> =
;=20
=
=CE=A8=D2=BB=D7=A2=D2=E2=B5=C4=CA=C7=A3=BA=D2=AA=BD=ABmidas.dll=BF=BD=B5=BD=
system=BB=F2=D5=DF=B5=B1=C7=B0=C4=BF=C2=BC<BR>5.=C8=FD=B2=E3=BD=E1=B9=B9=B5=
=C4=B9=AB=CE=C4=B0=FC=B5=C4=CA=B5=CF=D6=B7=BD=B7=A8<BR> =CD=AC=CA=B1=
=C9=E8=B6=A81:filename(*.cds)2.remote=20
=
server<BR>6.=BF=C9=D2=D4=B6=D4data=B8=B3=D6=B5=A3=A8=B4=D3=C1=ED=D2=BB=B8=
=F6=CA=FD=BE=DD=BC=AF=C8=A1=D6=B5)<BR> ClientDataSet2.Data:=3DClient=
DataSet1.Data;<BR> ClientDataSet2.Open;<BR> =BB=F2=D5=DF<BR>&nb=
sp;ClientDataSet2.CloneCursor(ClientDataSet1,true);<BR> ClientDataSe=
t2.Open;<BR>7.=B8=BD=BC=D3=CA=FD=BE=DD=C8=A1=B5=C3<BR> =20
=
=BF=CD=BB=A7=B3=CC=D0=F2=CF=F2=D3=A6=D3=C3=B7=FE=CE=F1=C6=F7=C7=EB=C7=F3=CA=
=FD=BE=DD=A1=A3=C8=E7=B9=FBTClientDataSet =B5=C4<BR> FetchOnDemand =
=CA=F4=D0=D4=C9=E8=CE=AATrue=A3=AC<BR> =
=BF=CD=BB=A7=B3=CC=D0=F2=BB=E1=B8=F9=BE=DD=D0=E8=D2=AA=D7=D4=B6=AF=BC=EC=CB=
=F7=B8=BD=BC=D3=B5=C4=CA=FD=BE=DD=B0=FC=C8=E7BLOB=D7=D6=B6=CE=B5=C4=D6=B5=
=BB=F2=C7=B6=CC=D7=B1=ED=B5=C4=C4=DA=C8=DD=A1=A3<BR> =20
=B7=F1=D4=F2=A3=AC<BR> =
=BF=CD=BB=A7=B3=CC=D0=F2=D0=E8=D2=AA=CF=D4=CA=BD=B5=D8=B5=F7=D3=C3GetNext=
Packet =
=B2=C5=C4=DC=BB=F1=B5=C3=D5=E2=D0=A9=B8=BD=BC=D3=B5=C4=CA=FD=BE=DD=B0=FC=A1=
=A3<BR> =20
=
ClientDataSet=B5=C4packetrecords=C9=E8=D6=C3=D2=BB=B4=CE=C8=A1=B5=C3=B5=C4=
=BC=C7=C2=BC=B8=F6=CA=FD<BR>8.ClientDataSet=D3=EB=B7=FE=CE=F1=C6=F7=B6=CB=
query=C1=AC=BD=D3=B7=BD=B7=A8<BR> =20
=A3=A81=A3=A9sql=C4=DA=C8=DD=CE=AA=BF=D5<BR> =
ClientDataSet1.Close;<BR> =20
=20
=
ClientDataSet1.CommandText:=3Dedit1.Text;//=BC=B4sql=C4=DA=C8=DD<BR=
> =20
ClientDataSet1.Open;<BR> =
=B6=D4=D3=DA=C3=BB=D3=D0=D3=A6=D3=C3=B7=FE=CE=F1=C6=F7=C9=E8=D6=C3f=
ilter=20
=C8=E7=A3=BAcountry like 'A%'<BR> =
filtered=3Dtrue=BF=C9=CA=B5=CF=D6sql=B9=A6=C4=DC<BR> =20
(2)=D3=D0=B2=CE=CA=FD<BR> =
=C8=E7=B7=FE=CE=F1=B6=CBquery=B5=C4sql=CE=AA<BR> =
select * from=20
animals <BR> where name like :dd<BR> =20
=D4=F2:=BF=CD=BB=A7=B6=CBClientDataSet<BR> =
var<BR> =20
pm:Tparam;<BR> begin<BR> =20
ClientDataSet1.Close;<BR> =20
=
ClientDataSet1.ProviderName:=3D'DataSetProvider1';<BR> =20
pm:=3DTparam.Create(nil);<BR> =20
pm.Name:=3D'dd';<BR> =20
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -