Exemplo n.º 1
0
        private void button1_Click(object sender, EventArgs e)
        {
            int IRTBLines = 0, i = 0, j = 0; // Counter Represent Lines from TextBox

            //Read Lines from TextBox
            for (IRTBLines = 0; IRTBLines < textBox1.Lines.Length; IRTBLines++)
            {
                //If IRTBLine is not Null Then
                if (string.Compare(textBox1.Lines[IRTBLines], "") != 0)
                {
                    //Data Base Command 2
                    SqlCommand DBcom2 = new SqlCommand("select * from subject where sub_name ='" + textBox1.Lines[IRTBLines] + "'", con);

                    //Database Reader 2
                    SqlDataReader DBRead2;

                    //Read From Database
                    DBRead2 = DBcom2.ExecuteReader();

                    // Check if Department Name is Exist
                    if (DBRead2.HasRows)
                    {
                        j = 1;
                        //Department Name is Already Exist
                        MessageBox.Show("subject Name =" + textBox1.Lines[IRTBLines] + " is skipped because it is already exist");

                        //Dispose Database command 2 and reader 2
                        DBRead2.Dispose();
                        DBcom2.Dispose();
                    }
                    else
                    {
                        i = 1;
                        //Department Name is Not Already Exist
                        //Database Command3 String
                        string SCom1 = "insert into subject values('" + textBox1.Lines[IRTBLines].ToString() + "')";
                        //Dispose Databse command 2 and reader 2
                        DBRead2.Dispose();
                        DBcom2.Dispose();

                        //Database Command 3
                        SqlCommand DBcom3 = new SqlCommand(SCom1, con);

                        //Execute Database Command 3.
                        DBcom3.ExecuteNonQuery();

                        //Dispose Database Command 3
                        DBcom3.Dispose();

                        //MessageBox.Show("subject Name =" + textBox1.Lines[IRTBLines] + " is entered into database");
                    }
                }
            }

            if (i == 0)
            {
                MessageBox.Show("Please input subject in text box", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
            if (i == 1)
            {
                MessageBox.Show("Data Entered Into Database");
            }
            //Clear RichTextBox1 Content
            textBox1.ResetText();
        }
Exemplo n.º 2
0
        private void button1_Click_1(object sender, EventArgs e)
        {
            if (comboBox1.SelectedIndex > 0)
            {
                string cb = "";
                int    i = 0, j = 0;
                var    row = (DataRowView)comboBox1.SelectedItem;
                //cb = comboBox1.Items[comboBox1.SelectedIndex].ToString();
                cb = row["sub_name"].ToString();

                int IRTBLines = 0; // Counter Represent Lines from RichTextBox
                                   //Read Lines from RichTextBox
                for (IRTBLines = 0; IRTBLines < textBox1.Lines.Length; IRTBLines++)
                {
                    //If IRTBLine is not Null Then
                    if (string.Compare(textBox1.Lines[IRTBLines], "") != 0)
                    {
                        //Data Base Command 2
                        SqlCommand DBcom2 = new SqlCommand("select * from student where subject = '" + cb + "' AND student_name ='" + textBox1.Lines[IRTBLines] + "'", con);

                        //Database Reader 2
                        SqlDataReader DBRead2;

                        //Read From Database
                        DBRead2 = DBcom2.ExecuteReader();

                        // Check if Department Name is Exist
                        if (DBRead2.HasRows)
                        {
                            i = 1;
                            //Department Name is Not Already Exist
                            //Database Command3 String
                            string SCom1 = "delete from student where subject ='" + cb + "' and student_name = '" + textBox1.Lines[IRTBLines].ToString() + "'";
                            //Dispose Databse command 2 and reader 2
                            DBRead2.Dispose();
                            DBcom2.Dispose();

                            //Database Command 3
                            SqlCommand DBcom3 = new SqlCommand(SCom1, con);

                            //Execute Database Command 3.
                            DBcom3.ExecuteNonQuery();

                            //Dispose Database Command 3
                            DBcom3.Dispose();
                        }
                        else
                        {
                            j = 1;
                            //Department Name is Already Exist
                            MessageBox.Show("student Name =" + textBox1.Lines[IRTBLines] + " is skipped because it doesn't exist");

                            //Dispose Database command 2 and reader 2
                            DBRead2.Dispose();
                            DBcom2.Dispose();
                        }
                        //  MessageBox.Show("Data Entered Into Database");
                    }
                }
                if (i == 0 && j == 0)
                {
                    MessageBox.Show("Please input name in text box", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                }
                if (i == 1)
                {
                    MessageBox.Show("Student Name Deleted From Subject = " + cb + " ");
                }

                //Clear RichTextBox1 Content
                textBox1.ResetText();
                label5.Text = "0";
            }
            else
            {
                MessageBox.Show("Please Select Subject", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }
Exemplo n.º 3
0
        private void button2_Click(object sender, System.EventArgs e)
        {
            if (comboBox1.SelectedIndex > 0)
            {
                string cb  = "";
                var    row = (DataRowView)comboBox1.SelectedItem;
                //cb = comboBox1.Items[comboBox1.SelectedIndex].ToString();
                cb = row["sub_name"].ToString();
                int IRTBLines = 0; // Counter Represent Lines from RichTextBox
                                   //Read Lines from RichTextBox
                for (IRTBLines = 0; IRTBLines < textBox1.Lines.Length; IRTBLines++)
                {
                    //If IRTBLine is not Null Then
                    if (string.Compare(textBox1.Lines[IRTBLines], "") != 0)
                    {
                        //Data Base Command 2
                        SqlCommand DBcom2 = new SqlCommand("select * from student where subject = '" + cb + "' AND student_name ='" + textBox1.Lines[IRTBLines] + "'", con);

                        //Database Reader 2
                        SqlDataReader DBRead2;

                        //Read From Database
                        DBRead2 = DBcom2.ExecuteReader();

                        // Check if Department Name is Exist
                        if (DBRead2.HasRows)
                        {
                            //string SCom1 = "insert into student(subject,student_name,attendence) values('" + cb + "','" + textBox1.Lines[IRTBLines].ToString() + "','" + a + "')";
                            //Dispose Databse command 2 and reader 2
                            string SCom1 = "update student set attendence = attendence +1 where subject = '" + cb + "' AND student_name ='" + textBox1.Lines[IRTBLines] + "'";
                            DBRead2.Dispose();
                            DBcom2.Dispose();

                            //Database Command 3
                            SqlCommand DBcom3 = new SqlCommand(SCom1, con);

                            //Execute Database Command 3.
                            DBcom3.ExecuteNonQuery();

                            //Dispose Database Command 3
                            DBcom3.Dispose();
                        }
                        else
                        {
                            //Department Name is Already Exist
                            MessageBox.Show("student Name =" + textBox1.Lines[IRTBLines] + " These Student name not found in database (please add these student)");

                            //Dispose Database command 2 and reader 2
                            DBRead2.Dispose();
                            DBcom2.Dispose();
                        }
                    }
                }

                //Clear RichTextBox1 Content
                textBox1.ResetText();
            }
            else
            {
                MessageBox.Show("Please Select Subject", "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
            }
        }