Difference between revisions of "Create register for ASP.Net Web App"

From TRCCompSci - AQA Computer Science
Jump to: navigation, search
Line 1: Line 1:
 +
==Creating the Page==
 +
Add a new Razor Page and call it `register`.
  
 +
Now add the following HTML form:
 +
<syntaxhighlight lang=html>
 +
<form method="post">
 +
<input type="Text" name="user">
 +
<input type="Text" name="password">
 +
<input type="number" name="status">
 +
<input type="submit">
 +
</form>
 +
</syntaxhighlight>
 +
 +
==Adding the code to handle the form==
 
<syntaxhighlight lang=c#>
 
<syntaxhighlight lang=c#>
 
public IActionResult OnPost()
 
public IActionResult OnPost()

Revision as of 14:32, 19 October 2024

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();
}