Click here to Skip to main content
15,346,809 members
Home / Discussions / C#
   

C#

 
GeneralRe: c# file directory structure change Pin
Jegan Thiyagesan6-Mar-13 21:17
MemberJegan Thiyagesan6-Mar-13 21:17 
Questionpass Convert.ToDateTime to date in MysqlDataType Pin
Jassim Rahma6-Mar-13 2:21
MemberJassim Rahma6-Mar-13 2:21 
AnswerRe: pass Convert.ToDateTime to date in MysqlDataType Pin
Eddy Vluggen6-Mar-13 3:16
professionalEddy Vluggen6-Mar-13 3:16 
AnswerRe: pass Convert.ToDateTime to date in MysqlDataType Pin
OriginalGriff6-Mar-13 4:50
mveOriginalGriff6-Mar-13 4:50 
GeneralRe: pass Convert.ToDateTime to date in MysqlDataType Pin
Eddy Vluggen6-Mar-13 4:58
professionalEddy Vluggen6-Mar-13 4:58 
AnswerRe: pass Convert.ToDateTime to date in MysqlDataType Pin
Wayne Gaylard6-Mar-13 5:03
professionalWayne Gaylard6-Mar-13 5:03 
AnswerRe: pass Convert.ToDateTime to date in MysqlDataType Pin
jschell6-Mar-13 8:42
Memberjschell6-Mar-13 8:42 
Questionplz check my sql code. is it correct ? Pin
Member 103026305-Mar-13 22:38
MemberMember 103026305-Mar-13 22:38 
CREATE PROCEDURE sp_userinformation
@UserName varchar(50),
@Password varchar(50),
@FirstName varchar(50),
@LastName varchar(50),
@Email varchar(50),
@PhoneNo varchar(50),
@Location varchar(50),
@Created_By varchar(50),
@ERROR VARCHAR(100) OUT

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.


SET NOCOUNT ON;

---Checking Condition if User exists or not if user not exists returns different message if exists returns different message


IF NOT EXISTS(SELECT * FROM User_Information WHERE UserName=@UserName)

BEGIN

INSERT INTO User_Information
(
UserName,
[Password],
FirstName,
LastName,
Email,
PhoneNo,
Location,
Created_By
)
VALUES
(
@UserName,
@Password,
@FirstName,
@LastName,
@Email,
@PhoneNo,
@Location,
@Created_By
)

--If User Successfully Registerd I am returing this Message as Output Parameter

SET @ERROR=@UserName+' Registered Successfully'

END

ELSE

BEGIN

--If User already Exists i am returning this Message as Output Parameter

SET @ERROR=@UserName + ' Already Exists'

END

END
AnswerRe: plz check my sql code. is it correct ? Pin
Pete O'Hanlon5-Mar-13 22:41
mvaPete O'Hanlon5-Mar-13 22:41 
GeneralRe: plz check my sql code. is it correct ? Pin
Member 103026305-Mar-13 23:43
MemberMember 103026305-Mar-13 23:43 
GeneralRe: plz check my sql code. is it correct ? Pin
Pete O'Hanlon5-Mar-13 23:50
mvaPete O'Hanlon5-Mar-13 23:50 
AnswerRe: plz check my sql code. is it correct ? Pin
PIEBALDconsult6-Mar-13 16:55
professionalPIEBALDconsult6-Mar-13 16:55 
GeneralRe: plz check my sql code. is it correct ? Pin
Member 1030263012-Mar-13 19:15
MemberMember 1030263012-Mar-13 19:15 
QuestionCreate DirectoryEntry Error Pin
arkno15-Mar-13 22:18
Memberarkno15-Mar-13 22:18 
AnswerRe: Create DirectoryEntry Error Pin
Pete O'Hanlon5-Mar-13 22:45
mvaPete O'Hanlon5-Mar-13 22:45 
QuestionReplacing items within a string Pin
Goaty651095-Mar-13 13:25
MemberGoaty651095-Mar-13 13:25 
AnswerRe: Replacing items within a string Pin
NotPolitcallyCorrect5-Mar-13 13:33
MemberNotPolitcallyCorrect5-Mar-13 13:33 
GeneralRe: Replacing items within a string Pin
Goaty651095-Mar-13 13:39
MemberGoaty651095-Mar-13 13:39 
GeneralRe: Replacing items within a string Pin
NotPolitcallyCorrect5-Mar-13 14:26
MemberNotPolitcallyCorrect5-Mar-13 14:26 
GeneralRe: Replacing items within a string Pin
Goaty651095-Mar-13 15:30
MemberGoaty651095-Mar-13 15:30 
GeneralRe: Replacing items within a string Pin
SoMad5-Mar-13 23:21
professionalSoMad5-Mar-13 23:21 
GeneralRe: Replacing items within a string Pin
NotPolitcallyCorrect6-Mar-13 2:16
MemberNotPolitcallyCorrect6-Mar-13 2:16 
GeneralRe: Replacing items within a string Pin
Bogza.Anton5-Mar-13 14:45
MemberBogza.Anton5-Mar-13 14:45 
GeneralRe: Replacing items within a string Pin
Goaty651095-Mar-13 15:32
MemberGoaty651095-Mar-13 15:32 
GeneralRe: Replacing items within a string Pin
Bogza.Anton5-Mar-13 15:58
MemberBogza.Anton5-Mar-13 15:58 

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.