Create Users in MySQL database in ASP.Net

Hi eapiater,

Refer Simple User Registration Form Example in ASP.Net.

For insert user refer below procedure.

DELIMITER $$
CREATE PROCEDURE `Insert_User`
(
    Username NVARCHAR(20),
    Password NVARCHAR(20),
    Email NVARCHAR(30)
)
BEGIN
    IF EXISTS (SELECT UserId FROM Users WHERE Username = Username) THEN
        SELECT -1;
    ELSEIF EXISTS (SELECT UserId FROM Users WHERE Email = Email) THEN
        SELECT -2;
    ELSE
        INSERT INTO Users (Username, Password, Email, CreatedDate) VALUES (Username, Password, Email, GETDATE());
        SELECT LAST_INSERT_ID();
    END IF;
END $$