VS2008 report using values from a parametized Stored procedure

[szoora]

I want to generate a report showing payslips for a single employee using values from a SP with parameter values that have been passed from a datagrid row. However the report that is generated is blank. What am I missing. Below is what I have.

First I populate the datagrid view using values returned by a function called "sqlselect"

    Dim dbcall As New dbcalls
        dtgPayslip_Old.DataSource = dbcall.sqlselect("empno AS Employee_Number,empname AS Employee_Name, date AS Date", "payrollarchiveview")
 

Secondly i select empno from datagrid view as the parameter value which I pass to the SP

 
    Private Sub dtgPayslip_Old_CellDoubleClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dtgPayslip_Old.CellDoubleClick
        Dim dbcall As New dbcalls
        Dim empno As String = dtgPayslip_Old.Item(0, dtgPayslip_Old.CurrentRow.Index).Value.ToString()
 
        dbcall.CallparametizedSP("payrollarchivedataview", "@e", empno)
 
 

The sub that makes a db call

 
    Public Sub CallparametizedSP(ByVal procedureName As String, ByVal parameter As String, ByVal value As String)
 
        conn.Open()
        cmd.Parameters.AddWithValue(parameter, value)
        cmd.Connection = conn
        cmd.CommandType = CommandType.StoredProcedure
        cmd.CommandText = procedureName
        cmd.CommandTimeout = 6000
        cmd.ExecuteReader()
        cmd.Dispose()
        conn.Close()
 
 

After all this I would expect details of the employee into the report But all I get are the column headings. How can I resolve this. Thank you community

[Frinavale]

Calling the ExecuteReader method alone does not actually retrieve the data. You have to read the data from the reader in order to load the data.

Please see the MSDN documentation for SqlCommand.ExecuteReader Method for more information about this method and how to use it (if you aren't connecting to a MS SQL Server database you will need to check out the documentation for the OleDbCommand.ExecuteReader Method )

-Frinny

[szoora]

The other method was not to run the db call the sp at all. I passed the parameter value directly to the form that has the report viewer control, And I had my reports as expected. Thanks