ASP.NET

ASP.NET RSS

How to connect data base to reportviewer control

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Sep 2009

Posts: 21

Reputation: sudharani is an unknown quantity at this point

Solved Threads: 1

sudharani

Offline

Newbie Poster

How to connect data base to reportviewer control

Sep 18th, 2009

Hi friends,
in my website i want to display reports using reportViewer control.
I am not able to connect this report viewer to database.
Please help me in solving this.
Thank U

•

Join Date: Sep 2007

Posts: 66

Reputation: reach_yousuf is an unknown quantity at this point

Solved Threads: 12

reach_yousuf reach_yousuf is offline

Offline

Junior Poster in Training

Re: How to connect data base to reportviewer control

Sep 19th, 2009

Hi,

Use the following code...

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
 Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
         Dim dsTemp As New ProductGridDS
        obj = New InventoryBusiness.ProductBusiness
        dsTemp = obj.GetProductInfo() 'retrieve your data here in dataset
 
        Dim rds As ReportDataSource
        rds = New ReportDataSource("ProductGridDS_ProductGridInfo", dsTemp.Tables(0)) 'report name =ProductGridDS_ProductGridInfo 
 
        ReportViewer1.LocalReport.DataSources.Clear()
        ReportViewer1.LocalReport.DataSources.Add(rds)
        ReportViewer1.LocalReport.Refresh()
    End Sub
 Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
         Dim dsTemp As New ProductGridDS
        obj = New InventoryBusiness.ProductBusiness
        dsTemp = obj.GetProductInfo() 'retrieve your data here in dataset

        Dim rds As ReportDataSource
        rds = New ReportDataSource("ProductGridDS_ProductGridInfo", dsTemp.Tables(0)) 'report name =ProductGridDS_ProductGridInfo 

        ReportViewer1.LocalReport.DataSources.Clear()
        ReportViewer1.LocalReport.DataSources.Add(rds)
        ReportViewer1.LocalReport.Refresh()
    End Sub