data question (ASP.NET2.0 - C#)

[Justin Rich]

I am making a fairly simple help desk program. when a new ticket is created
it is sent in to two tables.

TICKETS and CONVERSATIONS

the username, computer, topic and subject go in to TICKETS and the problem
description goes in to CONVERSATION

the problem is i need the TICKET_ID from the TICKETS table to insert in to
the CONVERSATION table..

what i can do is do the insert and then query the TICKET_ID field for max
(its an identity, counts up, highest number is the new ticket)

but im guessing there is some nice way to do this in ASP.NET/C#

so i guess what im looking for is..... is there a way to return the auto
generated ticket_id from the insert?

Thanks
Justin

 

[Brock Allen]

You should look at changing your insert to also include a select SCOPE_IDENTITY()
call:

Fredrik discusses this here:

http://fredrik.nsquared2.com/viewpost.aspx?PostID=162&showfeedback=true

-Brock
DevelopMentor
http://staff.develop.com/ballen

 

[Justin Rich]

thats awesome.. thanks!

You should look at changing your insert to also include a select
SCOPE_IDENTITY() call:

Fredrik discusses this here:

http://fredrik.nsquared2.com/viewpost.aspx?PostID=162&showfeedback=true

-Brock
DevelopMentor
http://staff.develop.com/ballen