adoq1.SQL.Clear;
adoq1.SQL.Add('select sum(BenyuejiesuanHejia) as Jin from DuiXiaJiesuan where XMB='+quotedstr(trim(form23.edit1.Text))+'and FbID='+quotedstr(trim(combobox1.Text))+'and FbJiesuanID='+quotedstr(trim(combobox2.Text))+'and convert(varchar(7),JiesuanDate,120)='+quotedstr(formatdatetime('yyyy-MM',datetimepicker1.Date))+'order by FbJiesuanID asc ');
adoq1.Prepared;
adoq1.Open;
adoq1.first;请问如何把adoq1.Fieldbyname('Jin').Asstring的值显示在DBGrid中的第一行第四列?
adoq1.SQL.Add('select sum(BenyuejiesuanHejia) as Jin from DuiXiaJiesuan where XMB='+quotedstr(trim(form23.edit1.Text))+'and FbID='+quotedstr(trim(combobox1.Text))+'and FbJiesuanID='+quotedstr(trim(combobox2.Text))+'and convert(varchar(7),JiesuanDate,120)='+quotedstr(formatdatetime('yyyy-MM',datetimepicker1.Date))+'order by FbJiesuanID asc ');
adoq1.Prepared;
adoq1.Open;
adoq1.first;请问如何把adoq1.Fieldbyname('Jin').Asstring的值显示在DBGrid中的第一行第四列?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货