Click here to Skip to main content
15,892,927 members
Home / Discussions / C#
   

C#

 
Generaldeploying application Pin
Ammar Ben Hadj Amor27-May-04 23:25
professionalAmmar Ben Hadj Amor27-May-04 23:25 
QuestionHow to programmitically extract zip file in C# Pin
vinod jadhav27-May-04 22:47
vinod jadhav27-May-04 22:47 
AnswerRe: How to programmitically extract zip file in C# Pin
netclectic27-May-04 23:43
netclectic27-May-04 23:43 
GeneralRemoting Questions Pin
James Simpson27-May-04 22:36
James Simpson27-May-04 22:36 
Generalstrings in DLL calls Pin
Gian27-May-04 21:37
Gian27-May-04 21:37 
GeneralRe: strings in DLL calls Pin
Gian27-May-04 21:40
Gian27-May-04 21:40 
GeneralChecking connection of some IP to the internet Pin
Den2Fly27-May-04 21:27
Den2Fly27-May-04 21:27 
Generalconformation Pin
sreejith ss nair27-May-04 20:59
sreejith ss nair27-May-04 20:59 
GeneralRe: conformation Pin
Dave Kreskowiak28-May-04 3:36
mveDave Kreskowiak28-May-04 3:36 
GeneralType.GetType Pin
Silly Boy27-May-04 18:53
Silly Boy27-May-04 18:53 
GeneralRe: Type.GetType Pin
ian mariano27-May-04 20:24
ian mariano27-May-04 20:24 
GeneralC# and SQL Autonumber Pin
Antonius_r327-May-04 18:06
Antonius_r327-May-04 18:06 
GeneralRe: C# and SQL Autonumber Pin
Grimolfr28-May-04 3:20
Grimolfr28-May-04 3:20 
GeneralRe: C# and SQL Autonumber Pin
Dave Kreskowiak28-May-04 3:26
mveDave Kreskowiak28-May-04 3:26 
GeneralRe: C# and SQL Autonumber Pin
Antonius_r328-May-04 7:26
Antonius_r328-May-04 7:26 
GeneralRe: C# and SQL Autonumber Pin
Dave Kreskowiak28-May-04 7:54
mveDave Kreskowiak28-May-04 7:54 
GeneralRe: C# and SQL Autonumber Pin
Antonius_r329-May-04 3:48
Antonius_r329-May-04 3:48 
GeneralRe: C# and SQL Autonumber Pin
Dave Kreskowiak29-May-04 14:25
mveDave Kreskowiak29-May-04 14:25 
GeneralRe: C# and SQL Autonumber Pin
Antonius_r329-May-04 18:56
Antonius_r329-May-04 18:56 
GeneralRe: C# and SQL Autonumber Pin
Dave Kreskowiak30-May-04 3:22
mveDave Kreskowiak30-May-04 3:22 
Like the first responder said in your post, you SQL statement IS wrong. You said you corrected it, but you changed it back to the incorrect statement again:
ALTER PROCEDURE programservice.insert_job(
    @JobID int output,
    @CustomerID char(20),
    @Date datetime
) AS
SET NOCOUNT ON
INSERT INTO dbo.table_job(CustomerID, Date) VALUES (@CustomerID, @Date);
SET @JobID = SCOPE_IDENTITY()
SELECT JobID, CustomerID, Date FROM dbo.tabel_job WHERE (JobID = @JobID)

The JobID will not have a number until SQL commits the new record to the database (the INSERT statement). Then you can get the new JobID into @JobID using SCOPE_IDENTITY(). Then the SELECT statement returns the updated record to the caller as the sole record in the dataset.

Since JobID is the Primary Key and IDENTITY, it CAN'T ever be NULL...


RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

GeneralRe: C# and SQL Autonumber Pin
Antonius_r331-May-04 13:02
Antonius_r331-May-04 13:02 
QuestionHow to make points well -distributed ? Pin
fu027-May-04 18:04
fu027-May-04 18:04 
AnswerRe: How to make points well -distributed ? Pin
Broken God28-May-04 20:17
Broken God28-May-04 20:17 
GeneralSNMP MIB : How to use it with C# Pin
youssef27-May-04 12:28
youssef27-May-04 12:28 
GeneralRe: SNMP MIB : How to use it with C# Pin
Dave Kreskowiak28-May-04 3:18
mveDave Kreskowiak28-May-04 3:18 

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.