Click here to Skip to main content
15,357,682 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionHelp needed Pin
07navneet5-Dec-11 23:31
Member07navneet5-Dec-11 23:31 
AnswerRe: Help needed Pin
Richard MacCutchan5-Dec-11 23:52
mveRichard MacCutchan5-Dec-11 23:52 
QuestionBlock Concurrent user Pin
yesu prakash5-Dec-11 21:40
Memberyesu prakash5-Dec-11 21:40 
AnswerRe: Block Concurrent user Pin
R. Giskard Reventlov5-Dec-11 22:12
MemberR. Giskard Reventlov5-Dec-11 22:12 
Questionhow to dynamically add textboxes Pin
MalarGayu5-Dec-11 17:23
MemberMalarGayu5-Dec-11 17:23 
AnswerRe: how to dynamically add textboxes Pin
uspatel5-Dec-11 19:19
professionaluspatel5-Dec-11 19:19 
AnswerRe: how to dynamically add textboxes Pin
Morgs Morgan6-Dec-11 20:09
MemberMorgs Morgan6-Dec-11 20:09 
Questiongenerating specific format Pin
sk_ko5-Dec-11 15:11
Membersk_ko5-Dec-11 15:11 
now I need to request one thing,
in my database table, there is date column as datatime value.
I want to generate using the year of this 'date' column.
for example , I want to do like below:

id | name | date | caseID

1 | Peter | 12/1/2011 12:00:00 AM | 201100001
2 | Willam | 12/2/2011 12:00:00 AM | 201100002
3 | Willam | 12/3/2011 12:00:00 AM | 201100003
4 | Alex | 1/1/2012 12:00:00 AM | 201200001
5 | Willam | 2/2/2013 12:00:00 AM | 201300001

in this table,
in 'caseID' column, I want to generate like above..

for year 2011,
201100001 // (2011(year) + 00001)
201100002 //(2011(year) + 00002)
....
201100010 //(2011(year) + 00010)

When reached year 2012, I want to auto start from 00001 like that:
201200001
201200002
...and so on.

please help me how I have to do for caseID column in my example table.

thanks all.

how I have to pass year parameter value & how I have to create user defined function. please
AnswerRe: generating specific format Pin
Andy_L_J5-Dec-11 21:56
MemberAndy_L_J5-Dec-11 21:56 
QuestionUnzip, Zip file in asp.net Pin
Mugdha_Aditya5-Dec-11 3:02
MemberMugdha_Aditya5-Dec-11 3:02 
AnswerRe: Unzip, Zip file in asp.net Pin
DigiOz Multimedia5-Dec-11 4:48
MemberDigiOz Multimedia5-Dec-11 4:48 
AnswerRe: Unzip, Zip file in asp.net Pin
Jon Myers5-Dec-11 11:01
MemberJon Myers5-Dec-11 11:01 
QuestionOn Displaying the Records Retrieved Through Data Reader Pin
FerdinandDLDR2-Dec-11 7:33
MemberFerdinandDLDR2-Dec-11 7:33 
AnswerRe: On Displaying the Records Retrieved Through Data Reader Pin
jkirkerx2-Dec-11 11:42
professionaljkirkerx2-Dec-11 11:42 
GeneralRe: On Displaying the Records Retrieved Through Data Reader Pin
FerdinandDLDR6-Dec-11 15:58
MemberFerdinandDLDR6-Dec-11 15:58 
AnswerRe: On Displaying the Records Retrieved Through Data Reader Pin
syed muneem5-Dec-11 1:56
Membersyed muneem5-Dec-11 1:56 
GeneralRe: On Displaying the Records Retrieved Through Data Reader Pin
FerdinandDLDR6-Dec-11 15:54
MemberFerdinandDLDR6-Dec-11 15:54 
GeneralRe: On Displaying the Records Retrieved Through Data Reader Pin
jkirkerx6-Dec-11 16:18
professionaljkirkerx6-Dec-11 16:18 
QuestionShow compound field in gridview Pin
Elham M2-Dec-11 2:40
MemberElham M2-Dec-11 2:40 
AnswerRe: Show compound field in gridview Pin
thatraja2-Dec-11 3:06
professionalthatraja2-Dec-11 3:06 
GeneralRe: Show compound field in gridview Pin
Elham M2-Dec-11 18:48
MemberElham M2-Dec-11 18:48 
Questionhow to load another page in asp.net page(C#)? Pin
Far sh1-Dec-11 15:47
MemberFar sh1-Dec-11 15:47 
AnswerRe: how to load another page in asp.net page(C#)? Pin
Not Active1-Dec-11 17:05
mentorNot Active1-Dec-11 17:05 
Questionhow to make a web page? Pin
nik_utm1-Dec-11 14:46
Membernik_utm1-Dec-11 14:46 
Answercross post Pin
Not Active1-Dec-11 17:00
mentorNot Active1-Dec-11 17:00 

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.