1. Create a form to accept user registration information and perform validation
ID: 3773332 • Letter: 1
Question
1. Create a form to accept user registration information and perform validation according to following table: First Name, Last Name Cannot be empty State Cannot be empty and must be 2 characters Password Must contain the number 2. Create a web form and perform validations in your project. 3. Create a counter to show how many registration being saved (use sessions) 4. Create a button to print or display the registrations on new page.
This is a project in asp.net. I need to program it in both c# and vb.net
Explanation / Answer
web.config file
*******************
<configuration>
<connectionStrings>
<add name="CM_Connection" connectionString="data source=localhost;Initial Catalog=TestDB;Integrated Security=SSPI;" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
----------------------------------------------------------------------------------------------------------------------------------
handling createUser Button onClick() function
****************************************************
if (Page.IsValid)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CM_Connection"].ConnectionString))
{
SqlCommand sqlCmd = new SqlCommand();
Guid guid;
guid = Guid.NewGuid();
//preparing sql statement
string sql = "INSERT INTO RegisterUser (registeruser_id,registeruser_username,registeruser_email,registeruser_password";
sql += " ,registeruser_createdon,registeruser_modifiedon,registeruser_rowstate)";
sql += "VALUES (@ID,@Username,@Email,@Password,@Createdon,@Modifiedon,@Rowstate)";
//Storing data into database
sqlCmd.Parameters.AddWithValue("@ID", guid);
sqlCmd.Parameters.AddWithValue("@Username", UserName.Text.Trim());
sqlCmd.Parameters.AddWithValue("@Email", Email.Text.Trim());
sqlCmd.Parameters.AddWithValue("@Password", Password.Text);
sqlCmd.Parameters.AddWithValue("@Createdon", DateTime.Now);
sqlCmd.Parameters.AddWithValue("@Modifiedon", DateTime.Now);
sqlCmd.Parameters.AddWithValue("@Rowstate", 1);
sqlCmd.Connection = con;
sqlCmd.CommandText = sql;
con.Open();
try
{
//finally executing query
sqlCmd.ExecuteNonQuery();
ErrorMessage.Text = "Registered successfully.";
}
catch(Exception ex)
{
throw new Exception(ex.Message);
}
}
}
So using page.IsValid functoin one can register and check for validations in form input fields.
--------------------------------------------------------------------------------------------------------------------------------
Creating login / sign up form..... and storing data to session attributes...
****************************************************************************************
stringemail = UserName.Text.Trim();
string pwd = Password.Text;
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CM_Connection"].ConnectionString))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
// cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SELECT registeruser_id,registeruser_username, registeruser_email,registeruser_password FROM TestDB_RegisterUser where registeruser_email='" + email + "' and registeruser_password='" + pwd + "' and registeruser_rowstate<3 ";
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(dt);
if (dt.Rows.Count > 0)
{
Session.Add("UserID", dt.Rows[0][0].ToString());
Session.Add("Username", dt.Rows[0][1].ToString());
Session.Add("UserEmail", dt.Rows[0][2].ToString());
Response.Redirect("~/Default.aspx", false);
}
else
{
FailureText.Text = "Invalid username or password";
}
}
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.