SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Database1"].ConnectionString);
conn.Open();
bool exists = false;
using (SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM [User] WHERE Email = @email", conn)) { //checks if the email that the user has entered exists in the database table cmd.Parameters.AddWithValue("Email", txt_RegEmail.Text); exists = (int)cmd.ExecuteScalar() > 0; }
// if the email exists, send an alert if (exists) { Response.Write("alert('Sorry, Email is already taken!');"); } // else, insert else { string insertQuery = "INSERT INTO [USER] (User_ID, Username, Email, Password, Role, Created_At) " + "values (@id, @username, @email, @password, @role, @timestamp)";
Response.Write("alert('Successfully created account! Welcome! ');"); }
conn.Close();
txt_Username.Text = ""; txt_RegEmail.Text = ""; } [/code] После нажатия кнопки значения, отправленные на серверную часть, такие как txt_Username.Text, пусты