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.
http://i56.tinypic.com/259wop0.png
Anyone have an idea or link for samples to I can rely or study? Thanks...
Re: Need Ideas or Sample Dataset and populating RDLC
Up....
I am still searching over the internet and still can't find...
All I found are have own dataset for report design....