crystalreport with sql select

[shif]

Hi,
In asp.net I am trying to generate a crystal report by the method showing
below.But no data is showing in the report..for this what settings i have to
do in crystal report.
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
Dim con As New SqlConnection(c onnectionString )
Dim comd As New SqlCommand()
comd.Connection = con
comd.CommandTex t = "select suppid,invno,am t from spfile where
suppid ='"&textbox1.te xt&"'
con.Open()
Dim adp As New SqlDataAdapter( comd)
Dim dts As New DataSet()
adp.Fill(dts)
con.Close()
Dim cr3 As New CrystalReport1( )
cr3.SetDataSour ce(dts)
CrystalReportVi ewer1.ReportSou rce = cr3
CrystalReportVi ewer1.DataBind( )
CrystalReportVi ewer1.Visible = True
End sub
--
Thanks

[Spam Catcher]

Re: crystalreport with sql select

=?Utf-8?B?c2hpZg==?= <ns_0001@hotmai l.comwrote in
news:F1BF9DB2-F424-4C24-BCCB-CB9294E75564@mi crosoft.com:

In asp.net I am trying to generate a crystal report by the method
showing below.But no data is showing in the report..for this what
settings i have to do in crystal report.

did you design the template?