mkb21 2014-10-12 05:11
浏览 1509

关于如何向Report1.rdlc传值的问题,请高手指点,万分感谢!

Imports System
Imports System.Data
Imports System.Data.OleDb

Public Class Code

Private Sub Code_Load(sender As Object, e As EventArgs) Handles MyBase.Load
    Me.ReportViewer1.RefreshReport()  ' ​初始化报表

    Dim strSQL As String = "Select * From BookView"  '数据库查询语句(使用Access数据库)

    With Me.DataGridView1   '设置DataGridView的一系列属性
        .DataSource = GetDat(strSQL).Tables(0)
        .ReadOnly = True  '只读
        .RowHeadersWidth = 8
        .Columns(0).Width = 96
        .Columns(1).Width = 96
        .AllowUserToResizeColumns = False '禁止调整列宽
        .SelectionMode = DataGridViewSelectionMode.FullRowSelect    '选择模式为整行
    End With
End Sub

Private Shared Function GetDat(ByVal strSql As String) As DataSet

    '数据库连接,建立一个DataSet,返回一个DataSet
    Dim StrConn As String = "Provider= Microsoft.Jet.OLEDB.4.0;Data Source=" &  Application.StartupPath & "\myTry.mdb"

    Dim cn As OleDbConnection = New OleDbConnection(StrConn)
    Dim da As OleDbDataAdapter = New OleDbDataAdapter(strSql, cn)
    Dim ds As DataSet = New DataSet

    Try
        cn.Open()
        da.Fill(ds)
        cn.Close()
    Catch ex As Exception
        MsgBox(ex.ToString)
    End Try

    Return ds
End Function

Private Sub DataGridView1_CellClick(sender As Object, e As DataGridViewCellEventArgs) Handles DataGridView1.CellClick
    Dim IntNum As Integer = e.RowIndex
    Dim myNum As String = Me.DataGridView1.SelectedRows(IntNum).Cells(0).ToString
    Dim strSql As String = "Select * From BookCode Where Num = " & myNum
    Dim myTab As Data.DataTable = GetDat(strSql).Tables(0)

    '......下面的代码准备将表中的记录传给报表Report1.rdlc,该如何写?谢谢!

End Sub

End Class
CSDN移动问答

  • 写回答

0条回答

    报告相同问题?

    悬赏问题

    • ¥15 运筹学排序问题中的在线排序
    • ¥15 关于docker部署flink集成hadoop的yarn,请教个问题 flink启动yarn-session.sh连不上hadoop,这个整了好几天一直不行,求帮忙看一下怎么解决
    • ¥30 求一段fortran代码用IVF编译运行的结果
    • ¥15 深度学习根据CNN网络模型,搭建BP模型并训练MNIST数据集
    • ¥15 C++ 头文件/宏冲突问题解决
    • ¥15 用comsol模拟大气湍流通过底部加热(温度不同)的腔体
    • ¥50 安卓adb backup备份子用户应用数据失败
    • ¥20 有人能用聚类分析帮我分析一下文本内容嘛
    • ¥30 python代码,帮调试,帮帮忙吧
    • ¥15 #MATLAB仿真#车辆换道路径规划