G gmwing Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-29 #1 如何将用ADOQuery1的SQL语句在SQL SERVER2000中创建的临时表与某控件(如:DBGrid)联系起来?
H hryyx Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-29 #2 var s: string; s:='select * into #tmp from Table1' //根据实际需要改写该语句 + 'select * from #tmp' AdoQuery1.Sql.Clear; AdoQuery1.Sql.Add(s); AdoQuery.Sql.Open;
var s: string; s:='select * into #tmp from Table1' //根据实际需要改写该语句 + 'select * from #tmp' AdoQuery1.Sql.Clear; AdoQuery1.Sql.Add(s); AdoQuery.Sql.Open;
D daniel007 Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-29 #3 设置一DataSource(DataSet属性)链接adoQuery,然后将Dbgrid(DataSource属性) 链接到该DataSource上,设置adoQuery的数据集为该临时表,然后active=true即可
设置一DataSource(DataSet属性)链接adoQuery,然后将Dbgrid(DataSource属性) 链接到该DataSource上,设置adoQuery的数据集为该临时表,然后active=true即可
L lglglglg2427 Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-30 #4 同意以上两位仁兄的意见,但active=true一般不在属性里设置,最好在程序里写。