ASP.net crystalreportviewer数据源 [英] ASP.net crystalreportviewer datasource

问题描述

先生，关于水晶报告，我是新来的，先生，我在哪里可以获取crystalreportviewer的数据源?

sir i am new here regarding crystal reports, sir where could i get the datasource of the crystalreportviewer?

Dim cn As New SqlConnection
       cn.ConnectionString = ("Data Source=ML0003135586;Initial Catalog=TestSQL;Integrated Security=True")
       cn.Open()
       Try
           Dim ds As New DataSet
           Dim da As New SqlDataAdapter(mReportDataSource, cn)
           da.Fill(ds)

plss help

plss help

推荐答案

// Connection Class Code 

Imports Microsoft.VisualBasic
Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration
Public Class Connection
    Public con As New SqlConnection(ConfigurationManager.ConnectionStrings("constr").ToString())
    Public cmd As New SqlCommand
    Public adp As New SqlDataAdapter
    Public ds As New DataSet
    Public dr As SqlDataReader
End Class

//Main Form Code 

Imports System.Data
Imports System.Data.OleDb
Imports System.Web.UI.HtmlControls
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Enterprise
Imports CrystalDecisions.Shared
Imports System.IO
Imports System.Data.SqlClient

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
       
        Dim rpt As New ReportDocument()
        rpt.Load(Server.MapPath("studentReport.rpt"))
        cn.con.Open()
        cn.cmd.Connection = cn.con
        cn.cmd.CommandText = "select * from Student_Master "
        cn.adp.SelectCommand = cn.cmd
        cn.adp.Fill(cn.ds)
        rpt.SetDataSource(cn.ds.Tables(0))
        CrystalReportViewer1.ReportSource = rpt
        cn.con.Close()
End Sub

[e-mail]
-

vs中有一个摘录，用于获取Crystal Report Viewer的数据源.

There is a snippet in vs to get the data source of of crystal report viewer.

Dim report As New ReportDocument()
Dim server as String 'to get Server Name
Dim DBName as String 'to get Database Name
report.Load("rptPatient.rpt")
server=report.DataSourceConnections(0).ServerName
DBName=report.DataSourceConnections(0).DatabaseName

服务器在此处提供报告中服务器的名称(第一个连接).然后DBName给出数据库的名称.

谢谢.

Here Server give the name of server in the report (first connection). And DBName gives the name of Data Base.

Thanks.

本文介绍了所有详细信息

ASP.NET中的晶体报告 [

This article explains all the details

Crystal Reports in ASP.NET[^]

这篇关于ASP.net crystalreportviewer数据源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！