Click here to Skip to main content
15,846,571 members
Home / Discussions / C#
   

C#

 
GeneralRe: c# file directory structure change Pin
Jegan Thiyagesan6-Mar-13 22:17
Jegan Thiyagesan6-Mar-13 22:17 
Questionpass Convert.ToDateTime to date in MysqlDataType Pin
Jassim Rahma6-Mar-13 3:21
Jassim Rahma6-Mar-13 3:21 
AnswerRe: pass Convert.ToDateTime to date in MysqlDataType Pin
Eddy Vluggen6-Mar-13 4:16
professionalEddy Vluggen6-Mar-13 4:16 
AnswerRe: pass Convert.ToDateTime to date in MysqlDataType Pin
OriginalGriff6-Mar-13 5:50
mveOriginalGriff6-Mar-13 5:50 
GeneralRe: pass Convert.ToDateTime to date in MysqlDataType Pin
Eddy Vluggen6-Mar-13 5:58
professionalEddy Vluggen6-Mar-13 5:58 
AnswerRe: pass Convert.ToDateTime to date in MysqlDataType Pin
Wayne Gaylard6-Mar-13 6:03
professionalWayne Gaylard6-Mar-13 6:03 
AnswerRe: pass Convert.ToDateTime to date in MysqlDataType Pin
jschell6-Mar-13 9:42
jschell6-Mar-13 9:42 
Questionplz check my sql code. is it correct ? Pin
Member 103026305-Mar-13 23:38
Member 103026305-Mar-13 23: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 23:41
subeditorPete O'Hanlon5-Mar-13 23:41 
GeneralRe: plz check my sql code. is it correct ? Pin
Member 103026306-Mar-13 0:43
Member 103026306-Mar-13 0:43 
GeneralRe: plz check my sql code. is it correct ? Pin
Pete O'Hanlon6-Mar-13 0:50
subeditorPete O'Hanlon6-Mar-13 0:50 
AnswerRe: plz check my sql code. is it correct ? Pin
PIEBALDconsult6-Mar-13 17:55
mvePIEBALDconsult6-Mar-13 17:55 
GeneralRe: plz check my sql code. is it correct ? Pin
Member 1030263012-Mar-13 20:15
Member 1030263012-Mar-13 20:15 
QuestionCreate DirectoryEntry Error Pin
arkno15-Mar-13 23:18
arkno15-Mar-13 23:18 
AnswerRe: Create DirectoryEntry Error Pin
Pete O'Hanlon5-Mar-13 23:45
subeditorPete O'Hanlon5-Mar-13 23:45 
QuestionReplacing items within a string Pin
Goaty651095-Mar-13 14:25
Goaty651095-Mar-13 14:25 
AnswerRe: Replacing items within a string Pin
NotPolitcallyCorrect5-Mar-13 14:33
NotPolitcallyCorrect5-Mar-13 14:33 
GeneralRe: Replacing items within a string Pin
Goaty651095-Mar-13 14:39
Goaty651095-Mar-13 14:39 
GeneralRe: Replacing items within a string Pin
NotPolitcallyCorrect5-Mar-13 15:26
NotPolitcallyCorrect5-Mar-13 15:26 
GeneralRe: Replacing items within a string Pin
Goaty651095-Mar-13 16:30
Goaty651095-Mar-13 16:30 
GeneralRe: Replacing items within a string Pin
SoMad6-Mar-13 0:21
professionalSoMad6-Mar-13 0:21 
GeneralRe: Replacing items within a string Pin
NotPolitcallyCorrect6-Mar-13 3:16
NotPolitcallyCorrect6-Mar-13 3:16 
GeneralRe: Replacing items within a string Pin
Bogza.Anton5-Mar-13 15:45
Bogza.Anton5-Mar-13 15:45 
GeneralRe: Replacing items within a string Pin
Goaty651095-Mar-13 16:32
Goaty651095-Mar-13 16:32 
GeneralRe: Replacing items within a string Pin
Bogza.Anton5-Mar-13 16:58
Bogza.Anton5-Mar-13 16: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.