Create register for ASP.Net Web App

From TRCCompSci - AQA Computer Science
Revision as of 14:32, 19 October 2024 by Admin (talk | contribs)
Jump to: navigation, search

Creating the Page

Add a new Razor Page and call it `register`.

Now add the following HTML form:

	<form method="post">
		<input type="Text" name="user">
		<input type="Text" name="password">
		<input type="number" name="status">
		<input type="submit">
	</form>

Adding the code to handle the form

public IActionResult OnPost()
{
	string username = Request.Form["user"];
	string pass1 = Request.Form["password1"];
	string pass2 = Request.Form["password2"];
	int status = 0;

	if (pass1 == pass2)
	{
		using var connection = GetConnection;

		connection.Open();
		string sql = "insert into test values(@p1, @p2, @p3);";
		using var Command = new MySqlCommand(sql, connection);
		Command.Parameters.AddWithValue("@p1", username);
		Command.Parameters.AddWithValue("@p2", pass1);
		Command.Parameters.AddWithValue("@p3", status);

		Command.ExecuteNonQuery();
		connection.Close();
	}

	return Page();
}