private void button1_Click(object sender, EventArgs e) { Intermediate_page Check = new Intermediate_page(email); Check.Show(); Close(); }
private void lizard_submit_Click(object sender, EventArgs e) { string provider = ConfigurationManager.AppSettings["provider"]; string connectionString = ConfigurationManager.AppSettings["connectionString"]; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO LIZARD (Email, Name, Breed, Weight, Gender, Personality, Preffered_Temp, Food_Type, Age) VALUES " + "(@Email, @Name, @Breed, @Weight, @Gender, @Personality, @Preffered_Temp, @Food_Type, @Age)", connection); cmd.Parameters.AddWithValue("@Email", mail); cmd.Parameters.AddWithValue("@Name", name_text.Text); cmd.Parameters.AddWithValue("@Breed", breed_combo.SelectedItem.ToString()); cmd.Parameters.AddWithValue("@Weight", weight_combo.SelectedItem.ToString()); cmd.Parameters.AddWithValue("@Gender", gender_combo.SelectedItem.ToString()); cmd.Parameters.AddWithValue("@Personality", personality_combo.SelectedItem.ToString()); cmd.Parameters.AddWithValue("@Preffered_Temp", preffered_temp_combo.SelectedItem.ToString()); cmd.Parameters.AddWithValue("@Food_Type", food_type.SelectedItem.ToString()); cmd.Parameters.AddWithValue("@Age", age_combo.SelectedItem.ToString()); try { cmd.ExecuteNonQuery(); } catch (SqlException sqlEX) { MessageBox.Show(sqlEX.Message); } connection.Close(); } Intermediate_page Check = new Intermediate_page(mail); Check.Show(); Close(); }
private void Loigin_click(object sender, EventArgs e) { DataTable Emails = new DataTable(); bool login2 = false; string provider = ConfigurationManager.AppSettings["provider"]; string connectionString = ConfigurationManager.AppSettings["connectionString"]; using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlDataAdapter adapter = new SqlDataAdapter("Select Email FROM Seller ", connection)) { try { adapter.Fill(Emails); } catch (SqlException sql) { MessageBox.Show(sql.ToString()); } } } foreach (DataRow row in Emails.Rows) { if (owner_email_info.Text == row["Email"].ToString()) { Intermediate_page Check = new Intermediate_page(owner_email_info.Text); Check.Show(); Close(); login2 = true; break; } else { login2 = false; } } if (!login2) { MessageBox.Show("Please sign in using valid Email."); } }