RowCount in VB.NET

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ayakamacy
    New Member
    • May 2015
    • 14

    #1

    RowCount in VB.NET

    Can someone help me out.
    im facing a problem regarding in rowcount @ vb.net

    -- Updating

    All i want to do is If JobStart.Text Change date then
    rowcount + 1
    elseif JobStart.text didn't change date then
    rowcount (but no +1)


    Code:
    COn.Open()
    SQL = "Select [JobStart] from tblJOL where [JobStart] = '" & txtJobStart.Text & "'"
    DA = New OleDbDataAdapter(SQL, COn)
    RS = New DataSet("tblJOL")
    DA.Fill(RS, "tblJOL")
    Dim JobCount As Integer
    Dim HD As String
    JobCount = Val(RS.Tables("tblJOL").Rows.Count)
    HD = Val(JobCount)
    txtTotalJO.Text = Val(HD) + 1
    COn.Close()
Working...