one report calling multiple stored procedure in another page

Last Reply 14 days ago By dharmendr

Posted 14 days ago

Hello,

If I want to use the same code, but need to open another page calling multiple stored procedure on one report. Please check out the example:

  1. Have multiple command or link button. (name as A, B, C etc…) on one page
  2. Click on A then it’s will open the report with the A data in different page.
  3. Click on B then it’s will open the SAME report with the B data.

Hope you understand what I meant. Basically there are two pages. One page will contain command button and one page will contain all the report that calling from multiple stored procedure.

This is the code that you have me last time.

   Private Sub GetFieldwork(ByVal procedure As String)
       Using con As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("DBHUSRConnectionString").ConnectionString)
           Using cmd As SqlCommand = New SqlCommand(procedure, con)
               cmd.CommandType = CommandType.StoredProcedure
               Using sda As SqlDataAdapter = New SqlDataAdapter()
                   sda.SelectCommand = cmd
                   Dim dt As DataTable = New DataTable()
                   sda.Fill(dt)
                   GridView1.DataSource = dt
                   GridView1.DataBind()
               End Using
           End Using
       End Using
   End Sub 

   Protected Sub ChildYouth(ByVal sender As Object, ByVal e As EventArgs)
       GetFieldwork("QChildYouthService_sp")
   End Sub 

   Protected Sub ElderlyServices(ByVal sender As Object, ByVal e As EventArgs)
       GetFieldwork("QElderlyService_sp")
   End Sub

 

You are viewing reply posted by: dharmendr 14 days ago.