locked
Vb.net Microsoft Reporting with store procedure with parameters RRS feed

  • Question

  • User-2127167624 posted

    I have below code to open MS report with storeprocedure that have parameters, but it doesn't work:

    cc.dbcmd = CDbconn.DbConn.CreateCommand
    cc.dbcmd.CommandType = CommandType.StoredProcedure
    cc.dbcmd.CommandText = "TestRpt"
    cc.dbcmd.Parameters.Clear()
    cc.dbcmd.Parameters.Add(New SqlParameter("@NoCOA", TxtNoCOA.Text))
    cc.dbcmd.ExecuteNonQuery()

    Me.TestRptTableAdapter.Fill(Me.TestStoreDs.TestRpt)

    Me.Rpv.RefreshReport()

    Monday, March 3, 2014 3:13 AM

All replies

  • User-1925713106 posted

    Hi Bunnarem, 

    Thanks for your post.

    What’s the detailed error you received?

    Have you tried to debug your code? Which code line receive the exception?  

    Wednesday, March 5, 2014 2:49 AM