Results 1 to 2 of 2

Thread: Need Ideas or Sample Dataset and populating RDLC

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 2005
    Posts
    310

    Need Ideas or Sample Dataset and populating RDLC

    I am creating a custom design for printing (RDLC)
    Is this possible to populate my rdlc from pre populated Dataset?

    I am populating my dataset like this
    Code:
    Private Sub populateExam()
            Dim daClients As New SqlDataAdapter
            Dim dsClients As New DataSet
            Dim conn As SqlConnection
            conn = New SqlConnection
            With conn
                If .State = ConnectionState.Open Then .Close()
                .ConnectionString = connSettings()
                .Open()
            End With
            Dim strSQL As String = "SELECT * from tbldiagnose WHERE FKey='" & IDtoSearch & "' and dateofExam='" & dateToSearch & "'"
            daClients.SelectCommand = New SqlCommand(strSQL, conn)
            Dim myCB As SqlCommandBuilder = New SqlCommandBuilder(daClients)
            daClients.Fill(dsClients, "exam")
    
            With dsClients.Tables(0).Rows(0)
                lblOD_SPH.Text = .Item("OD_SPH")
                lblOD_CYL.Text = .Item("OD_CYL")
                lblOD_AXI.Text = .Item("OD_AXI")
                lblOD_ADD.Text = .Item("OD_ADD")
                lblOS_SPH.Text = .Item("OS_SPH")
                lblOS_CYL.Text = .Item("OS_CYL")
                lblOS_AXI.Text = .Item("OS_AXI")
                lblOS_ADD.Text = .Item("OS_ADD")
                lblPD.Text = .Item("PD")
                txtPhD.Text = .Item("attendingOP")
    
            End With
        End Sub
    My Dataset hold only 1 record from my database.
    I need to pass that record into my cutomize page for printing.

    This is my layout. the red rectangle is the place for the values.

    Anyone have an idea or link for samples to I can rely or study? Thanks...
    Last edited by dr_aybyd; Nov 10th, 2010 at 11:26 PM.
    VB 6.0 = "Self-Study" Then
    vb.NET = "Self-Study" Then
    C# = 'on going study.....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width