IOT Virtual Conference - Register now to book your ticket and get updates
x
WIN Surface Laptop 4, i7 Processor, 16GB RAM, 512GB SSD
x
CONGRATULATIONS! C# Corner Q1, 2021 MVPs Announced
Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
Monthly Leaders
ASK A QUESTION
Forumguidelines
Andy Roque
2k
1
588
Primary Key Custom Format
Feb 20 2016 8:45 AM
Good Day to all,
Please help me with my project, I would like to create a Custom Primary Key in my database design,
the format is [current year][current month][3 digit counter].
This goes something like this ==> 201602001. Next id should be 201602002 and so on, but here is the catch, the following month it should display ==> 201603001 then next id should be 201603002 and so on. The three digit counter should reset to 001 every month.
Is this possible?
Thank you in advance....
Reply
Answers (
1
)
Use Parameteri in OracleDataReader with StringBuilder in VB.
Retrieve hardcoded value from dropdownlist on specific gridv