By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,994 Members | 2,036 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,994 IT Pros & Developers. It's quick & easy.

RowCount in VB.NET

ayakamacy
P: 14
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)


Expand|Select|Wrap|Line Numbers
  1. COn.Open()
  2. SQL = "Select [JobStart] from tblJOL where [JobStart] = '" & txtJobStart.Text & "'"
  3. DA = New OleDbDataAdapter(SQL, COn)
  4. RS = New DataSet("tblJOL")
  5. DA.Fill(RS, "tblJOL")
  6. Dim JobCount As Integer
  7. Dim HD As String
  8. JobCount = Val(RS.Tables("tblJOL").Rows.Count)
  9. HD = Val(JobCount)
  10. txtTotalJO.Text = Val(HD) + 1
  11. COn.Close()
  12.  
Jul 10 '15 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.