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
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]