stored procedure i crystal report

[ dado49 @ 22.09.2005. 20:41 ] @

Imam jedno pitanje u vezi stored procedure, data set i crystal report.

Napravio sam stored procedure i uzmem neke podatke iz DB i uabcim u data set i onda pokazem u datagrid na crystal report.

Kada imam stored procedure bez 'input para.' sve ok radi, ali
kada stavim 'input para.' dobijem gresku 'Failed to open a rowset.'

Code:

        Dim scmCustomersSP As New SqlClient.SqlCommand("faktura", SqlCon)
        scmCustomersSP.CommandType = CommandType.StoredProcedure

        scmCustomersSP.Parameters.Add("@invoiceID", SqlDbType.Int)
        scmCustomersSP.Parameters("@invoiceID").Value = 1

        Dim sdaCustomersSP As New SqlClient.SqlDataAdapter(scmCustomersSP)
        Dim dsReport As New DataSet
        sdaCustomersSP.Fill(dsReport, "Faktura")

        Dim datView As New DataView(dsReport.Tables("Faktura"))
        DataGrid1.DataSource = datView
        DataGrid1.DataBind()
        CrystalReportViewer1.ReportSource = rapDoc

_{[Ovu poruku je menjao dado49 dana 23.09.2005. u 12:12 GMT+1]}