示例#1
0
        private void button1_Click(object sender, EventArgs e)
        {
            //SmtpClient client = new SmtpClient();
            //client.Port = 587;
            //client.Host = "smtp.gmail.com";
            //client.EnableSsl = true;
            //client.Timeout = 10000;
            //client.DeliveryMethod = SmtpDeliveryMethod.Network;
            //client.UseDefaultCredentials = false;
            //client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "12261994");

            //MailAddress from = new MailAddress("*****@*****.**", "Student Registration");
            //MailAddress to = new MailAddress(textBox9.Text, textBox2.Text);
            //MailMessage mm = new MailMessage(from, to);
            //mm.Subject = "You have successfully registered";
            //mm.Body = "Hello " + textBox2.Text;
            //mm.BodyEncoding = UTF8Encoding.UTF8;
            //mm.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure;

            //client.Send(mm);

            string bday = bdayM.Text + " " + bdayD.Text + " " + bdayY.Text;

            try {
                SqlDataAdapter    sda = new SqlDataAdapter();
                SqlCommandBuilder cmd = new SqlCommandBuilder(sda);
                sda.InsertCommand = new SqlCommand("INSERT INTO Student_Info (studentID, FirstName, MiddleName, LastName, Address, BirthDate, Gender, Contact, Email, YearLevel, Course) VALUES (@stud_id, @stud_fname, @stud_mname, @stud_lname, @stud_address, @BirthDate, @Gender, @Contact, @Email, @stud_year, @stud_course)", connect);
                sda.InsertCommand.Parameters.Add("@stud_id", SqlDbType.VarChar).Value      = txtStudId.Text;
                sda.InsertCommand.Parameters.Add("@stud_fname", SqlDbType.VarChar).Value   = txtFname.Text;
                sda.InsertCommand.Parameters.Add("@stud_mname", SqlDbType.VarChar).Value   = txtMname.Text;
                sda.InsertCommand.Parameters.Add("@stud_lname", SqlDbType.VarChar).Value   = txtLname.Text;
                sda.InsertCommand.Parameters.Add("@stud_address", SqlDbType.VarChar).Value = txtAdd.Text;
                sda.InsertCommand.Parameters.Add("@stud_course", SqlDbType.VarChar).Value  = cmbCourse.Text;
                sda.InsertCommand.Parameters.Add("@stud_year", SqlDbType.VarChar).Value    = cmbYr.Text;
                sda.InsertCommand.Parameters.Add("@BirthDate", SqlDbType.VarChar).Value    = bday;
                sda.InsertCommand.Parameters.Add("@Gender", SqlDbType.VarChar).Value       = txtGender.Text;
                sda.InsertCommand.Parameters.Add("@Contact", SqlDbType.VarChar).Value      = txtContact.Text;
                sda.InsertCommand.Parameters.Add("@Email", SqlDbType.VarChar).Value        = txtEmail.Text;
                connect.Open();
                sda.InsertCommand.ExecuteNonQuery();
                connect.Close();
                ClearEntry();
                SqlDataAdapter da = new SqlDataAdapter();
                // when new student is added, the current id in the database will be incremented by 1
                da.UpdateCommand = new SqlCommand("UPDATE id_increment SET ID = " + (id_inc + 1) + " WHERE ID = " + id_inc, connect);
                connect.Open();
                da.UpdateCommand.ExecuteNonQuery();
                connect.Close();
            } catch (Exception ex) {
                MessageBox.Show(ex.Message);
            }
            this.Close();
            viewInfo obj = new viewInfo();

            obj.Show();
            MessageBox.Show("Record is already added!");
        }
示例#2
0
 private void StudentInfo_FormClosed(object sender, FormClosedEventArgs e)
 {
     // if editing is true and form is closed open the view student form
     if (this.edit == true)
     {
         viewInfo vv = new viewInfo();
         vv.Show();
         vv.TopMost = true;
     }
 }
示例#3
0
        private void viewInformationToolStripMenuItem_Click(object sender, EventArgs e)
        {
            viewInfo info = new viewInfo();

            info.Show();
        }
示例#4
0
        private void printInd_FormClosed(object sender, FormClosedEventArgs e)
        {
            viewInfo view = new viewInfo();

            view.Show();
        }