Click here to Skip to main content
15,891,777 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: C# Pin
Sandeep Akhare4-Sep-07 0:19
Sandeep Akhare4-Sep-07 0:19 
AnswerRe: C# Pin
Christian Graus4-Sep-07 3:07
protectorChristian Graus4-Sep-07 3:07 
GeneralRe: C# Pin
edwinlazer4-Sep-07 21:48
edwinlazer4-Sep-07 21:48 
AnswerRe: C# Pin
Lucky Sheikh5-Sep-07 1:20
Lucky Sheikh5-Sep-07 1:20 
QuestionHow to disable the back button and backspace key using Javascript..? Pin
Balagurunathan S3-Sep-07 23:43
Balagurunathan S3-Sep-07 23:43 
AnswerRe: How to disable the back button and backspace key using Javascript..? Pin
Sathesh Sakthivel3-Sep-07 23:48
Sathesh Sakthivel3-Sep-07 23:48 
AnswerRe: How to disable the back button and backspace key using Javascript..? Pin
Sandeep Akhare4-Sep-07 0:00
Sandeep Akhare4-Sep-07 0:00 
Questionproblem on genaration of unique number Pin
biswa473-Sep-07 23:43
biswa473-Sep-07 23:43 
have a table in sqlserver2005 named emp.

where the coloumns of the emp table are as follows.
empid char(3),
empname varchar(20),
empaddrs varchar(20),
empDOB dateandtime,
emp_no varchar(10)


i want to genertae emp_no as autogenertaed sequencitial number.
where the format of the auto genertaed number for emp_no will be - "id-yyyy-nnnn"


where 1st 2 places are the no of his emp_id i.e 01 or 02 like that
2nd four palces are the year of DOB i.e 2001,or 20005 like this
next four places are the numbers i.e 0001 ,0002 like this(it should be sequential number).

example of auto generated number are-0120010001,0219990002, 0320000003.and so on..

how will i generate this type of sequential no in asp .net (backend vb.net.)
when ever i save a record for a particular employee after giving the data in the front end of their corresponding textboxes, the emp_no should be generated in the database and stored in the emp_no coloumn of emp table.



(i know only how to generate auto num.by setting its identity to true.but dont know what to write in the formula filed so that i can genrate the above type of auto generated number)



ya i have taken emp_id as char(3) so that while i entry the value 01 in the front end it should be taken as 01 not1. if i will take emp_id as int then if i input 01 it wil take 1 only. thats why i have taken as char.

No emp_id is not a sequential no..it can be any number..
thanks in advance
AnswerRe: problem on genaration of unique number Pin
Fred_Smith4-Sep-07 1:21
Fred_Smith4-Sep-07 1:21 
AnswerRe: problem on genaration of unique number Pin
Pete O'Hanlon4-Sep-07 3:08
mvePete O'Hanlon4-Sep-07 3:08 
QuestionRe: problem on genaration of unique number Pin
biswa474-Sep-07 18:12
biswa474-Sep-07 18:12 
Questionassembly error Pin
saqib823-Sep-07 23:24
saqib823-Sep-07 23:24 
AnswerRe: assembly error Pin
Sathesh Sakthivel3-Sep-07 23:44
Sathesh Sakthivel3-Sep-07 23:44 
QuestionASP.Net with Sharepoint Pin
ScottM13-Sep-07 22:53
ScottM13-Sep-07 22:53 
QuestionError when compilation - Urgent Help Pin
morteza573-Sep-07 22:46
morteza573-Sep-07 22:46 
AnswerRe: Error when compilation - Urgent Help Pin
VenkataRamana.Gali4-Sep-07 0:46
VenkataRamana.Gali4-Sep-07 0:46 
AnswerRe: Error when compilation - Urgent Help Pin
nandhububbly4-Sep-07 2:01
nandhububbly4-Sep-07 2:01 
GeneralRe: Error when compilation - Urgent Help Pin
morteza574-Sep-07 3:44
morteza574-Sep-07 3:44 
QuestionDatalist inside datalist Pin
IamAmit3-Sep-07 22:42
IamAmit3-Sep-07 22:42 
AnswerRe: Datalist inside datalist Pin
Sandeep Akhare6-Sep-07 0:34
Sandeep Akhare6-Sep-07 0:34 
QuestionHow to find IP address of user machine in ASP. Pin
rahul.net113-Sep-07 22:36
rahul.net113-Sep-07 22:36 
AnswerRe: How to find IP address of user machine in ASP. Pin
Fred_Smith3-Sep-07 23:19
Fred_Smith3-Sep-07 23:19 
GeneralRe: How to find IP address of user machine in ASP. Pin
rahul.net114-Sep-07 0:02
rahul.net114-Sep-07 0:02 
GeneralRe: How to find IP address of user machine in ASP. Pin
Fred_Smith4-Sep-07 0:19
Fred_Smith4-Sep-07 0:19 
GeneralRe: How to find IP address of user machine in ASP. Pin
rahul.net114-Sep-07 1:07
rahul.net114-Sep-07 1:07 

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.