title: VB.net increment in label through button click,
body: <p>Please help me for this code.</p>
  
  <pre><code>Private Sub Button_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button.Click
  
  Dim cmd as New oleDbCommand
  cmd.CommandType = CommandType.text
  cmd.Connection = cnn
  cmd.Command.text ="Select max (Receipt_No) from [Cash_Register]"
  cnn.Open()
  Dim A As String = Convert.ToString(cmd.ExecuteScalar())
  cnn.Close()
  Label.text = A + 1
  End Sub
  </code></pre>
  
  <p>I'm Using MS Access Database, If the last Receipt_No is "ABC00004" in particular table ("ABC00001,ABC00002,ABC00003,ABC00004"). If I click button then next Receipt_No "ABC00005" only show in the Label.text.     </p>