i need code for vb.net 2008.
That is invoice system i have number in each invoice. my database invoice number is null. when i click tab automatically invoice number increased number 1 ( EC000 to EC001). I used tab control .
please reply...
siva28
-2
Newbie Poster
Recommended Answers
Jump to PostYou mean you want to generate serial invoice numbers?
Jump to PostPrivate Sub AutoNumberNo() Dim myReader As SqlDataReader conn = GetConnect() conn.Open() Dim temp As String Try Dim sql As String = "SELECT MAX(NO) 'IDNumber' FROM Invoice " Dim comm As SqlCommand = New SqlCommand(sql, conn) myReader = comm.ExecuteReader If myReader.HasRows Then While myReader.Read() temp = myReader.Item("IDNumber") + …
Jump to Postthis is not work properly ...please send clear code with database connection include
Simply call the subprocedure from the Button used for generating the sequence numbers like this:
Private Sub SerialButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SerialButton.Click 'Note: It is assumed that the button …
All 10 Replies
Netcode
33
Veteran Poster
siva28
-2
Newbie Poster
Netcode
33
Veteran Poster
siva28
-2
Newbie Poster
siva28
-2
Newbie Poster
Netcode
33
Veteran Poster
siva28
-2
Newbie Poster
siva28
-2
Newbie Poster
Netcode
33
Veteran Poster
siva28
-2
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.