Click here to Skip to main content
16,005,467 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: how to send alerts/messages from server to clients Pin
badgrs13-Mar-07 2:43
badgrs13-Mar-07 2:43 
QuestionHow to increase CrystalReportViewer ToolBar horizental length/width using .NET Pin
Elena200613-Mar-07 0:26
Elena200613-Mar-07 0:26 
Questionusing file uploader in a gridview Pin
chathu03j12-Mar-07 23:53
chathu03j12-Mar-07 23:53 
AnswerRe: using file uploader in a gridview Pin
kubben13-Mar-07 3:36
kubben13-Mar-07 3:36 
QuestionError in deleting a file !!! Pin
amin_behzadi12-Mar-07 23:52
professionalamin_behzadi12-Mar-07 23:52 
AnswerRe: Error in deleting a file !!! Pin
Paddy Boyd13-Mar-07 0:37
Paddy Boyd13-Mar-07 0:37 
GeneralRe: Error in deleting a file !!! Pin
amin_behzadi13-Mar-07 1:01
professionalamin_behzadi13-Mar-07 1:01 
QuestionMsg is not displaying when a Enter Email that is already in Database Pin
siddisagar12-Mar-07 23:24
siddisagar12-Mar-07 23:24 
Hi All,

I Created a Registration Page with only username,Pwd,Email,Contactno and Address fields.

1.when a Enter user with different Email then it is saved the details in Database.

2.My Code is working fine when a Enter username with Already Existing mail id then it is not taking.But only problem is msg is not displaying client side.

How to display msg .Pls find my code also.

procedure
---------

CREATE Procedure SP_Login
(
@Username varchar(50),
@pwd varchar(50),
@Email varchar(50),
@ContactNo varchar(50),
@Address varchar(50),
@Ret_val Int = Null Out,
@Ret_msg Varchar(75) = Null Out


)
AS

IF EXISTS(SELECT * FROM Login WHERE Email=@Email)
BEGIN
RAISERROR('The email address already exists', 16, 1)

END
ELSE
BEGIN

INSERT INTO Login (Username,pwd,Email,ContactNo,Address)VALUES(@Username,@pwd,@Email,@ContactNo,@Address)

END

If @@Error = 0
BEGIN
SET @RET_VAL = 1
SET @RET_MSG = 'DETAILS INSERTED SUCCESSFULLY.'
END
ELSE
BEGIN
SET @RET_VAL = 0
SET @RET_MSG = 'ERROR : Error in Inserting Details.'
END
GO







codebehind
----------

Try
conObj = New SqlConnection("Data Source=B4B-2F-323-CK26;user id=sa;password=sa;Database=TEST")
conObj.Open()

tranObj = conObj.BeginTransaction
cmdObj = conObj.CreateCommand
cmdObj.Transaction = tranObj

With cmdObj
.CommandText = "SP_Login"
.CommandType = CommandType.StoredProcedure
End With

With cmdObj.Parameters
.Add(New SqlParameter("@UserName", SqlDbType.VarChar, 50)).Value = txtUserName.Text
.Add(New SqlParameter("@pwd", SqlDbType.VarChar, 50)).Value = txtPwd.Text
.Add(New SqlParameter("@ContactNo", SqlDbType.VarChar, 50)).Value = txtPhoneno.Text
.Add(New SqlParameter("@Email", SqlDbType.VarChar, 50)).Value = txtEmail.Text
.Add(New SqlParameter("@Address", SqlDbType.VarChar, 50)).Value = txtAddress.Text

retvalp = .Add("@RET_VAL", SqlDbType.Int)
retvalp.Direction = ParameterDirection.Output
retmsgp = .Add("@RET_MSG", SqlDbType.VarChar, 50)
retmsgp.Direction = ParameterDirection.Output


End With

cmdObj.ExecuteNonQuery()

If retvalp.Value = 1 Then
tranObj.Commit()
lblmsg.Text = retmsgp.Value
Else
tranObj.Rollback()
lblmsg.Text = retmsgp.Value
End If
Catch ex As Exception
Response.Write(ex.ToString())
Finally
If Not tranObj Is Nothing Then tranObj.Dispose()
conObj.Close()
cmdObj.Dispose()
End Try


Questionis possible to draw on Image object at mousemove event? Pin
CodeBoi12-Mar-07 22:40
CodeBoi12-Mar-07 22:40 
AnswerRe: is possible to draw on Image object at mousemove event? Pin
badgrs13-Mar-07 2:41
badgrs13-Mar-07 2:41 
QuestionSpeed problem with Treeview Control Pin
Jeeva Mary Varghese12-Mar-07 22:26
Jeeva Mary Varghese12-Mar-07 22:26 
AnswerRe: Speed problem with Treeview Control Pin
N a v a n e e t h12-Mar-07 22:42
N a v a n e e t h12-Mar-07 22:42 
QuestionInternational standards Pin
Icarus12312-Mar-07 22:11
Icarus12312-Mar-07 22:11 
AnswerRe: International standards Pin
N a v a n e e t h12-Mar-07 22:21
N a v a n e e t h12-Mar-07 22:21 
QuestionAuto Documentation Pin
ADY00712-Mar-07 22:05
ADY00712-Mar-07 22:05 
Questionglobal variables Pin
vengaqua12-Mar-07 21:37
vengaqua12-Mar-07 21:37 
AnswerRe: global variables Pin
Sandeep Akhare12-Mar-07 22:09
Sandeep Akhare12-Mar-07 22:09 
GeneralRe: global variables Pin
vengaqua12-Mar-07 22:46
vengaqua12-Mar-07 22:46 
GeneralSessions Pin
ADY00712-Mar-07 22:49
ADY00712-Mar-07 22:49 
AnswerRe: global variables Pin
N a v a n e e t h12-Mar-07 22:23
N a v a n e e t h12-Mar-07 22:23 
GeneralRe: global variables Pin
vengaqua12-Mar-07 22:47
vengaqua12-Mar-07 22:47 
GeneralRe: global variables Pin
amin_behzadi13-Mar-07 0:10
professionalamin_behzadi13-Mar-07 0:10 
Questionhow to conver year to dateTime format Pin
ramyasangeet12-Mar-07 21:30
ramyasangeet12-Mar-07 21:30 
AnswerRe: how to conver year to dateTime format Pin
Sandeep Akhare12-Mar-07 22:11
Sandeep Akhare12-Mar-07 22:11 
GeneralRe: how to convert year to dateTime format Pin
ramyasangeet12-Mar-07 22:17
ramyasangeet12-Mar-07 22:17 

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.