Click here to Skip to main content
15,891,033 members
Home / Discussions / C#
   

C#

 
GeneralRe: transferring vb.net solution to c#.net Pin
kourvoisier2-Feb-06 11:20
kourvoisier2-Feb-06 11:20 
GeneralRe: transferring vb.net solution to c#.net Pin
malharone2-Feb-06 11:41
malharone2-Feb-06 11:41 
Questioncreating a truly transparent control Pin
melanieab2-Feb-06 7:58
melanieab2-Feb-06 7:58 
QuestionRe: creating a truly transparent control Pin
melanieab2-Feb-06 8:34
melanieab2-Feb-06 8:34 
AnswerRe: creating a truly transparent control Pin
microsoc2-Feb-06 21:15
microsoc2-Feb-06 21:15 
QuestionInserting a record and retrieving recordid Pin
moazzamahmed2-Feb-06 7:00
moazzamahmed2-Feb-06 7:00 
AnswerRe: Inserting a record and retrieving recordid Pin
Colin Angus Mackay2-Feb-06 7:25
Colin Angus Mackay2-Feb-06 7:25 
AnswerRe: Inserting a record and retrieving recordid Pin
malharone2-Feb-06 7:33
malharone2-Feb-06 7:33 
Assuming your table contains an Identity column ..

create procedure EmployeeCreate (@name varchar(20), @dept varchar(20), @employeeid numeric out)<br />
as<br />
begin<br />
insert into Emplyee (Name, Department) values (@name, @dept)<br />
select @employeeid = @@identity<br />
end


So when you execute your SQL command from .net and pass parameters, pass a parameter for "@employeeid". You wont need to set a value for this SqlParameter, but you'll have to set the correct Direction.

- Malhar
QuestionSystem Bitmaps Pin
deepscyberpulse2-Feb-06 6:26
deepscyberpulse2-Feb-06 6:26 
AnswerRe: System Bitmaps Pin
malharone2-Feb-06 6:31
malharone2-Feb-06 6:31 
AnswerRe: System Bitmaps Pin
James Gupta2-Feb-06 8:30
professionalJames Gupta2-Feb-06 8:30 
QuestionProblems with VB 6.0 App loading .net assembly with own mdi window (message loop)... Pin
Chris Richner2-Feb-06 6:26
Chris Richner2-Feb-06 6:26 
QuestionSorting? algorithm Pin
criz84262-Feb-06 6:17
criz84262-Feb-06 6:17 
AnswerRe: Sorting? algorithm Pin
Paddy Boyd2-Feb-06 6:26
Paddy Boyd2-Feb-06 6:26 
GeneralRe: Sorting? algorithm Pin
criz84262-Feb-06 6:35
criz84262-Feb-06 6:35 
AnswerRe: Sorting? algorithm Pin
Guffa2-Feb-06 6:44
Guffa2-Feb-06 6:44 
GeneralRe: Sorting? algorithm Pin
criz84262-Feb-06 7:15
criz84262-Feb-06 7:15 
GeneralRe: Sorting? algorithm Pin
Guffa2-Feb-06 10:46
Guffa2-Feb-06 10:46 
GeneralRe: Sorting? algorithm Pin
criz84262-Feb-06 12:26
criz84262-Feb-06 12:26 
AnswerRe: Sorting? algorithm Pin
Guffa2-Feb-06 21:43
Guffa2-Feb-06 21:43 
QuestionHow did the user close the form? Pin
Chals2-Feb-06 4:45
Chals2-Feb-06 4:45 
AnswerRe: How did the user close the form? Pin
malharone2-Feb-06 5:42
malharone2-Feb-06 5:42 
GeneralRe: How did the user close the form? Pin
Chals2-Feb-06 5:45
Chals2-Feb-06 5:45 
GeneralRe: How did the user close the form? Pin
Dave Kreskowiak2-Feb-06 5:48
mveDave Kreskowiak2-Feb-06 5:48 
GeneralRe: How did the user close the form? Pin
Chals2-Feb-06 6:23
Chals2-Feb-06 6:23 

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.