Codings help?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sreekandan
    New Member
    • Nov 2006
    • 98

    #1

    Codings help?

    Hi everybody,
    I have used the following code to retrieve and display the details from the database table.
    Code:
    rs3.Open "select * from tbl where empid = '" & Text1.Text & "' AND dat Between #" & Text2.Text & "# AND #" & Text3.Text & "#", con, adOpenForwardOnly, adLockReadOnly
    rs3.MoveFirst
    Do Until rs3.EOF
    j = j + 1
    lv.ListItems.Add j, , j
    lv.ListItems(j).SubItems(1) = rs!empid
    lv.ListItems(j).SubItems(2) = rs1!firstname & rs1!lastname
    lv.ListItems(j).SubItems(3) = rs3!dat
    lv.ListItems(j).SubItems(4) = rs3!intime
    lv.ListItems(j).SubItems(5) = rs3!outtime
    rs3.MoveNext
    Loop
    For that, I want the codings to take printout of the details what are all contained in the listview contol.So kindly anyone reply me as soon as possible.
  • willakawill
    Top Contributor
    • Oct 2006
    • 1646

    #2
    Then you might just enjoy reading this article

    Comment

    Working...