Click here to Skip to main content
15,912,400 members
Home / Discussions / ASP.NET
   

ASP.NET

 
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 
GeneralRe: dynamic control Pin
Abhijit Jana8-Sep-09 11:11
professionalAbhijit Jana8-Sep-09 11:11 
QuestionFailed to access IIS metabase. Pin
GauravKP8-Sep-09 1:12
professionalGauravKP8-Sep-09 1:12 
AnswerRe: Failed to access IIS metabase. Pin
Abhijit Jana8-Sep-09 1:26
professionalAbhijit Jana8-Sep-09 1:26 
QuestionFindcontrol of dynamically created html control Pin
yesu prakash8-Sep-09 0:18
yesu prakash8-Sep-09 0:18 
AnswerRe: Findcontrol of dynamically created html control Pin
N a v a n e e t h8-Sep-09 1:10
N a v a n e e t h8-Sep-09 1:10 
AnswerRe: Findcontrol of dynamically created html control Pin
Abhishek Sur8-Sep-09 1:46
professionalAbhishek Sur8-Sep-09 1:46 

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.