private void saveButton_Click_1(object sender, EventArgs e) { try { SqlConnection connection = new SqlConnection(connectionString); connection.Open(); if (fullNameTextBox.Text == String.Empty) { fullNameTextBox.Text = "Please Enter Name"; } else if (EmailValidation.CheckForMail(emailTextbox.Text)) { string query = string.Format(@"insert into administration values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')" , idTextBox.Text, fullNameTextBox.Text, sexComboBox.Text, presentTextBox.Text, permanentTextBox.Text, departmentComboBox.Text, joiningdateTimePickerBox.Value.Date, resigningdateTimePickerBox.Value.Date, mobileTextbox.Text, emailTextbox.Text); SqlCommand command = new SqlCommand(query, connection); int rows = command.ExecuteNonQuery(); if (rows > 0) { MessageBox.Show("Data Saved Succsfully !", "Successful Notice Window", MessageBoxButtons.OK, MessageBoxIcon.Information); connection.Close(); } else { MessageBox.Show("Data Not Saved", "Error Window", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { emaillebelBox.Visible = true; exampleBox.Visible = true; emaillebelBox.Text = "Please Enter Accurate Mail Format.Example:"; exampleBox.Text = "*****@*****.**"; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void saveButton_Click(object sender, EventArgs e) { try { SqlConnection connection = new SqlConnection(connectionString); connection.Open(); if (idTextBox.Text == String.Empty) { idLebelBox.Visible = true; idLebelBox.Text = "Please Enter ID"; } else if (TeacheremailTextBox.Text == String.Empty || EmailValidation.CheckForMail(TeacheremailTextBox.Text)) { string query = string.Format(@"insert into TeacharsEntry values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')", this.idTextBox.Text, this.fullNametextBox.Text, this.permanentTextBox.Text, this.presentTextBox.Text, this.honsTextBox.Text, this.mscTextBox.Text, this.phdTextBox.Text, this.deptComboBox.Text, this.dateTimePickerBox.Text, this.mobileTextBox.Text, this.TeacheremailTextBox.Text); SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = query; DateTimePicker inputdate = dateTimePickerBox; if (DateTime.Today > inputdate.Value) { int rows = command.ExecuteNonQuery(); if (rows > 0) { MessageBox.Show("Data Saved Succsfully"); } else { MessageBox.Show("Data Not Saved"); } } else { MessageBox.Show("You Entered The Wrong Joning Date.\nJoining Date Does Not More Than Current Date and Time"); } } else { exampleBox.Visible = true; label11.Visible = true; label11.Text = "Invalid Email:"; exampleBox.Text = "*****@*****.**"; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void saveButton_Click(object sender, EventArgs e) { try { int ssc; int hsc; bool sscresult = int.TryParse(sscTextBox.Text, out ssc); bool hscresult = int.TryParse(sscTextBox.Text, out hsc); SqlConnection connection = new SqlConnection(connectionString); connection.Open(); if (fullNameTextBox.Text == String.Empty) { idLebelBox.Visible = true; idLebelBox.Text = "Please Enter Name"; } else if (rollTextBox.Text == String.Empty) { idLebelBox.Visible = false; rollLevel.Visible = true; rollLevel.Text = "Please Enter Roll"; } else if (registrationTextBox.Text == String.Empty) { rollLevel.Visible = false; regiLevel.Visible = true; regiLevel.Text = "Please Enter Registration"; } else if (ssc <= 0 || ssc > 5) { regiLevel.Visible = false; sscLevel.Visible = true; sscLevel.Text = "Please Input upto 0 and less than 5"; } else if (hsc <= 0 || hsc > 5) { sscLevel.Visible = false; HscLevel.Visible = true; HscLevel.Text = "Please Input upto 0 and less than 5"; } else if (EmailValidation.CheckForMail(emailTextbox.Text)) { MemoryStream stream = new MemoryStream(); pictureBox3.Image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] ima = stream.ToArray(); string query = string.Format(@"insert into GeneralStudent values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}')" , idTextBox.Text, fullNameTextBox.Text, @ima, sexComboBox.Text, presentTextBox.Text, permanentTextBox.Text, rollTextBox.Text, registrationTextBox.Text, departmentComboBox.Text, sessionComboBox.Text, sscTextBox.Text, hsctextbox.Text, mobileTextbox.Text, familyTextBox.Text, emailTextbox.Text); SqlCommand command = new SqlCommand(query, connection); command.Parameters.Add(new SqlParameter("@ima", ima)); int rows = command.ExecuteNonQuery(); if (rows > 0) { MessageBox.Show("Data Saved Succsfully !", "Successful Notice Window", MessageBoxButtons.OK, MessageBoxIcon.Information); connection.Close(); } else { MessageBox.Show("Data Not Saved", "Error Window", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { emaillebelBox.Visible = true; exampleBox.Visible = true; emaillebelBox.Text = "Please Enter Accurate Mail Format.Example:"; exampleBox.Text = "*****@*****.**"; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }