not getting data in vs2005 using asp.net 2.0 and i am using stored procedure
the data from dataset does not get loaded into crystal report as there is no error message
as my code is below
Dim con As New SqlConnection(ConfigurationManager.ConnectionStrings("satinconnectionstring").ConnectionString)
        con.Open()
        Dim cmd As New SqlCommand
        cmd.Connection = con
               Dim W As String = Today.DayOfWeek.ToString
         cmd.CommandText = "EXEC MYSP_DEMAND_SHEET '20983','" & M & "','" & W & "','" & dat & "'"
             Dim da As New SqlDataAdapter(cmd.CommandText, con)
        Dim ds As New DataSet
        da.Fill(ds)
       
        Dim myReportDocument As CrystalDecisions.CrystalReports.Engine.ReportDocument
        myReportDocument = New CrystalDecisions.CrystalReports.Engine.ReportDocument()
        myReportDocument.Load(Server.MapPath("employee.rpt"))
            myReportDocument.Database.Tables("employee").SetDataSource(ds)
                CrystalReportViewer1.ReportSource = myReportDocument
        CrystalReportViewer1.DataBind()
     please help me in this regard
      




Edited by asmasm - 07 Sep 2009 at 2:31am