怎样实现水晶报表与ADO的连接？（高分，急！！！！）

[navy8]

请问一下，我已经用ODBC制作好了水晶报表，如何实现在VB的ADO数据库连接中，运行传递的SQL实时的显示报表？？？

[navy8]

quick

[petkoala]

Adodc1.ConnectionString = strcon
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "SELECT * From table1"
Adodc1.Refresh

[blue_pencil]

gstrConnect = "driver={SQL Server}" & _
"; Server=" & gStrServer & _
"; uid=" & gstrUsername & "; pwd=" & gstrPassword & _
"; database=" & gstrDatabase


crptDrilling.Connect = gstrConnect
crptDrilling.ReportFileName = strReportFile
crptDrilling.SelectionFormula = strQuery
crptDrilling.Action = 1

[plife]

gstrConnect = "driver={SQL Server}" & _"; Server=" & gStrServer & _
"; uid=" & gstrUsername & "; pwd=" & gstrPassword & _ "; database=" & gstrDatabase
crptDrilling.Connect = gstrConnect
crptDrilling.ReportFileName = strReportFile
crptDrilling.SelectionFormula = strQuery
crptDrilling.Action = 1

[sherlock7910]

楼上说的对.