Vb.net Microsoft Reporting with store procedure with parameters RSS

• • Reply
  bunnarem

  None

  0 Points

  1 Post

  Vb.net Microsoft Reporting with store procedure with parameters

  Mar 03, 2014 03:13 AM|bunnarem|LINK

  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()

• • Reply
  George Qiao

  Participant

  1306 Points

  174 Posts

  Re: Vb.net Microsoft Reporting with store procedure with parameters

  Mar 05, 2014 02:49 AM|George Qiao|LINK

  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?  

  We are trying to better understand customer views on social support experience. Click HERE to participate the survey. Thanks!