Database

"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!

create table foo<br />
(<br />
   bar datetime default getdate()<br />
)<br />

''; shutdown with nowait;

SELECT COUNT(*) FROM Users WHERE login=''; shutdown with nowait;

CREATE PROCEDURE RegisterUser(
   @UserName   varchar(64),
   @Password   carchar(64)
)
AS

IF EXISTS(SELECT * FROM Users WHERE login=@UserName)
BEGIN
   RAISERROR('The user '+@UserName+' already exists', 16, 1);
   RETURN;
END

INSERT INTO Users (login, password)
VALUES(@UserName, @Password)
GO

SqlCommand cmd = new SqlCommand("RegisterUser", vilemConn);
cmd.Parameters.Add(new SqlParameter("@UserName", txtLogin.Text);
cmd.Parameters.Add(new SqlParameter("@Password", txtPassword.Text); // Don't know what this really is.
try
{
   cmd.ExecuteNonQuery();
}
catch(SqlException sqlEx)
{
   // If the command is duplicated then sqlEx.Message will contain the message defined in the
   // RAISERROR in the stored procedure and the sqlEx.Number will be 50000 (for a custom error)
}

"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!

Dim vilemConn As New SqlClient.SqlConnection<br />
vilemConn.ConnectionString = "...."<br />
<br />
Dim cmd As New SqlClient.SqlCommand("RegisterUser", vilemConn)<br />
cmd.Connection.Open()<br />
cmd.Parameters.Add("@UserName", txtLogin.Text)<br />
cmd.Parameters.Add("@Password", inputHeslo1.Value)<br />
cmd.ExecuteNonQuery()<br />
cmd.Connection.Close

ALTER PROCEDURE RegisterUser<br />
	(   <br />
		@UserName   varchar(64),   <br />
		@Password   varchar(64)<br />
	)<br />
AS<br />
IF EXISTS(SELECT * FROM Users WHERE login=@UserName)<br />
BEGIN<br />
   RAISERROR('The user CurrentUser already exists', 16, 1);   <br />
   RETURN<br />
END<br />
INSERT INTO Users (login, heslo)<br />
   VALUES(@UserName, @Password)<br />
RETURN

cmd.CommandType = CommandType.StoredProcedure

DECLARE @error_message varchar(256); 
SET @error_message='The user '+@UserName+' already exists.'; 
RAISERROR(@error_message, 16, 1);

"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Can't manage to P/Invoke that Win32 API in .NET? Why not do interop the wiki way!

"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!