protected void bUpdate_Click(object sender, EventArgs e) { string gender = ""; if (rbMale.Checked) { //Response.Write("Your Gender: " + rbMale.Text + ". "); gender = "Male"; } if (rbFemale.Checked) { //Response.Write("Your Gender: " + rbFemale.Text + ". "); gender = "Female"; } if (rbNotApplicable.Checked) { //Response.Write("Your Gender: " + rbNotApplicable.Text + ". "); gender = "NA"; } // Save data to database here SQLConnectionUsingADO sql = new SQLConnectionUsingADO(); sql.Init(); sql.Open(); sql.Update(tbName.Text, tbEmail.Text, gender, (cbDotNet.Checked ? cbDotNet.Text : "") + (cbSQL.Checked && cbDotNet.Checked ? "&" : "") + (cbSQL.Checked ? cbSQL.Text : ""), list.Text); sql.ExecuteNonQuery(); sql.Close(); Response.Write("Your details has been updated. \n\n"); }
protected void bRegister_Click(object sender, EventArgs e) { string gender = ""; //Response.Write("Your Name is " + tbName.Text + ". "); if (rbMale.Checked) { //Response.Write("Your Gender: " + rbMale.Text + ". "); gender = "Male"; } if (rbFemale.Checked) { //Response.Write("Your Gender: " + rbFemale.Text + ". "); gender = "Female"; } if (rbNotApplicable.Checked) { //Response.Write("Your Gender: " + rbNotApplicable.Text + ". "); gender = "NA"; } //Response.Write("You know " + (cbDotNet.Checked ? cbDotNet.Text : "") + (cbSQL.Checked ? " and " + cbSQL.Text : ".")); //Response.Write("You live in: " + list.SelectedValue + ". \n\n"); // Save data to database here SQLConnectionUsingADO sql = new SQLConnectionUsingADO(); sql.Init(); sql.Open(); sql.Create(tbName.Text, tbEmail.Text, gender, (cbDotNet.Checked ? cbDotNet.Text : "") + (cbSQL.Checked && cbDotNet.Checked ? "&" : "") + (cbSQL.Checked ? cbSQL.Text : ""), list.Text); sql.ExecuteNonQuery(); sql.Close(); Response.Write("You have registered successfully!"); Response.Write("\n\n"); //string connectionString = @"Data Source=THEACCELERATOR;Initial Catalog=Week6Database;Integrated Security=True"; //SqlConnection connection = new SqlConnection(connectionString); //SqlCommand sqlCommand = new SqlCommand(); //sqlCommand.CommandText = "SQL Command"; //sqlCommand.CommandType = CommandType.Text; //sqlCommand.Connection = connection; //connection.Open(); //sqlCommand.ExecuteNonQuery(); //connection.Close(); }
protected void bFetch_Click(object sender, EventArgs e) { if (tbEmail.Text.Length > 0) { // Get data from database here SQLConnectionUsingADO sql = new SQLConnectionUsingADO(); sql.Init(); sql.Open(); ArrayList data = sql.Get(tbEmail.Text); sql.Close(); if (data.Count > 0) { tbName.Text = data[1].ToString(); switch (data[3].ToString()) { case "Male": rbMale.Checked = true; rbFemale.Checked = false; rbNotApplicable.Checked = false; break; case "Female": rbMale.Checked = false; rbFemale.Checked = true; rbNotApplicable.Checked = false; break; default: rbFemale.Checked = false; rbFemale.Checked = false; rbNotApplicable.Checked = true; break; } list.SelectedValue = data[5].ToString(); Response.Write("Loaded past data."); } else { Response.Write("No past data."); } } else { Response.Write("Enter an email to check."); } }