Click here to Skip to main content
15,899,679 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Getting Parser error when running Web Application on Internet Pin
SeMartens8-Sep-09 3:49
SeMartens8-Sep-09 3:49 
Questionsession variable Pin
Abbas_here8-Sep-09 2:49
Abbas_here8-Sep-09 2:49 
Answer[Message Deleted] Pin
GauravKP8-Sep-09 2:59
professionalGauravKP8-Sep-09 2:59 
GeneralRe: session variable Pin
Abhijit Jana8-Sep-09 3:02
professionalAbhijit Jana8-Sep-09 3:02 
GeneralRe: session variable Pin
Abbas_here8-Sep-09 3:02
Abbas_here8-Sep-09 3:02 
GeneralASP.NET page generation Pin
ankit_sam8-Sep-09 2:48
ankit_sam8-Sep-09 2:48 
GeneralRe: ASP.NET page generation Pin
Abhishek Sur8-Sep-09 13:08
professionalAbhishek Sur8-Sep-09 13:08 
Questionproblem with primary key Pin
shankbond8-Sep-09 2:01
shankbond8-Sep-09 2:01 
Hi,

I am developing a database(in SQL SERVER 2005) for a website, as you know that there can be a unknown amount of users surfing a website.

I am putting some registration related values in a table and my table is having a unique primary key with IDENTITY(1,1).

now the problem is I need that primary key value as soon as it is created in the table.

so that I may use that value to add( insert) some other values in other tables.

can it be done?

I have thought of using timestamp values as they are always unique to every row.

I have read somewhere that whenever a query is executed a value is returned such as 1 row affected or something like that,

is it possible to return the timestamp value in place of the above message, I really have no idea.

If it can then may be I can use some query like SELECT id FROM table WHERE timestamp=....;

please reply

YOUR help shall be appreciated

thank YOU

shankbond
AnswerRe: problem with primary key Pin
Manas Bhardwaj8-Sep-09 2:13
professionalManas Bhardwaj8-Sep-09 2:13 
AnswerRe: problem with primary key Pin
Aman Bhullar8-Sep-09 2:17
Aman Bhullar8-Sep-09 2:17 
GeneralAgree scope_identity() is the way to go. Read this article Pin
David Mujica8-Sep-09 2:51
David Mujica8-Sep-09 2:51 
AnswerRe: problem with primary key Pin
Zoki Manas8-Sep-09 22:38
Zoki Manas8-Sep-09 22:38 
GeneralRe: problem with primary key Pin
shankbond8-Sep-09 23:43
shankbond8-Sep-09 23:43 
GeneralRe: problem with primary key Pin
Aman Bhullar9-Sep-09 5:14
Aman Bhullar9-Sep-09 5:14 
Questiontreeview with context menu Pin
rinku soni 238-Sep-09 1:56
rinku soni 238-Sep-09 1:56 
AnswerRe: treeview with context menu Pin
GauravKP8-Sep-09 3:24
professionalGauravKP8-Sep-09 3:24 
QuestionASP.net web administrator tool error Pin
Hum Dum8-Sep-09 1:48
Hum Dum8-Sep-09 1:48 
AnswerRe: ASP.net web administrator tool error Pin
janani138-Sep-09 2:38
janani138-Sep-09 2:38 
GeneralRe: ASP.net web administrator tool error Pin
Hum Dum8-Sep-09 19:30
Hum Dum8-Sep-09 19:30 
AnswerRe: ASP.net web administrator tool error Pin
sashidhar8-Sep-09 23:46
sashidhar8-Sep-09 23:46 
Questiondynamic control Pin
mylogics8-Sep-09 1:44
professionalmylogics8-Sep-09 1:44 
AnswerRe: dynamic control Pin
Manas Bhardwaj8-Sep-09 1:56
professionalManas Bhardwaj8-Sep-09 1:56 
AnswerRe: dynamic control Pin
Abhishek Sur8-Sep-09 2:04
professionalAbhishek Sur8-Sep-09 2:04 
AnswerRe: dynamic control Pin
Abhijit Jana8-Sep-09 2:17
professionalAbhijit Jana8-Sep-09 2:17 
GeneralRe: dynamic control Pin
Abhishek Sur8-Sep-09 10:06
professionalAbhishek Sur8-Sep-09 10:06 

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.