Click here to Skip to main content
15,915,839 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Pausing Code Pin
Christian Graus23-May-05 11:51
protectorChristian Graus23-May-05 11:51 
GeneralRe: Pausing Code Pin
Reedmon2923-May-05 16:09
Reedmon2923-May-05 16:09 
GeneralRe: Pausing Code Pin
rudy.net23-May-05 18:47
rudy.net23-May-05 18:47 
GeneralRe: Pausing Code Pin
Reedmon2924-May-05 3:16
Reedmon2924-May-05 3:16 
GeneralRe: Pausing Code Pin
rudy.net24-May-05 3:39
rudy.net24-May-05 3:39 
GeneralRe: Pausing Code Pin
Reedmon2924-May-05 3:51
Reedmon2924-May-05 3:51 
GeneralRe: Pausing Code Pin
Dave Kreskowiak24-May-05 3:51
mveDave Kreskowiak24-May-05 3:51 
GeneralAutomatic Numbering Pin
macca2423-May-05 10:33
macca2423-May-05 10:33 
I have an ASP.net Form with a record number field in it. I want to create the number automatically in sequence each time a user creates a new record, the user does not want to have to add the number manually.
The record number is of the format 2005/001 and the next record will be 2005/002 and so on, 2005 is the year so next year this must change to 2006. The records are held in a Sqlserver 2000 database table. I want to ensure that if the last record inserted to the database was 2005/004 then when the user opens the form to create a new record the Record number field will be populated with 2005/005 which is the next Record number in sequence.

I am using VB.net to code the ASP.net.

Anyone any ideas on this?

Thanks.

GeneralRe: Automatic Numbering Pin
Christian Graus23-May-05 11:56
protectorChristian Graus23-May-05 11:56 
GeneralVB.Net Language Statement Pin
Fernando Soto23-May-05 10:18
Fernando Soto23-May-05 10:18 
GeneralRe: VB.Net Language Statement Pin
Dave Kreskowiak23-May-05 10:41
mveDave Kreskowiak23-May-05 10:41 
GeneralRe: VB.Net Language Statement Pin
Fernando Soto23-May-05 13:13
Fernando Soto23-May-05 13:13 
GeneralADODC Control Pin
ems18p23-May-05 8:40
ems18p23-May-05 8:40 
GeneralSaving in VB Pin
siskomike23-May-05 6:51
siskomike23-May-05 6:51 
GeneralRe: Saving in VB Pin
Brian Van Beek23-May-05 7:24
Brian Van Beek23-May-05 7:24 
GeneralRe: Saving in VB Pin
siskomike23-May-05 7:50
siskomike23-May-05 7:50 
GeneralRe: Saving in VB Pin
Brian Van Beek23-May-05 7:58
Brian Van Beek23-May-05 7:58 
GeneralRe: Saving in VB Pin
siskomike23-May-05 8:19
siskomike23-May-05 8:19 
GeneralRe: Saving in VB Pin
Brian Van Beek23-May-05 8:50
Brian Van Beek23-May-05 8:50 
GeneralRe: Saving in VB Pin
siskomike23-May-05 9:05
siskomike23-May-05 9:05 
GeneralStartposition of a form Pin
KreativeKai23-May-05 6:44
professionalKreativeKai23-May-05 6:44 
GeneralRe: Startposition of a form Pin
Fernando Soto23-May-05 7:47
Fernando Soto23-May-05 7:47 
GeneralRe: Startposition of a form Pin
KreativeKai24-May-05 8:59
professionalKreativeKai24-May-05 8:59 
GeneralEnd User Form Customization Pin
mtone23-May-05 5:31
mtone23-May-05 5:31 
GeneralApplication TimeOut Pin
mtone23-May-05 5:23
mtone23-May-05 5:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.