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
My Dataset hold only 1 record from my database.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
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...





Reply With Quote