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条回答

    报告相同问题?

    悬赏问题

    • ¥30 这是哪个作者做的宝宝起名网站
    • ¥60 版本过低apk如何修改可以兼容新的安卓系统
    • ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
    • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
    • ¥50 有数据,怎么用matlab求全要素生产率
    • ¥15 TI的insta-spin例程
    • ¥15 完成下列问题完成下列问题
    • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
    • ¥15 YoloV5 第三方库的版本对照问题
    • ¥15 请完成下列相关问题!