コード例 #1
0
        private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            this.Close();
            StudentGrid d = new StudentGrid();

            d.Show();
        }
コード例 #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                Student s = new Student();
                s.set_FirstName(FirstName.Text);
                s.set_LastName(LastName.Text);
                s.set_Registration_No(RegistrationNumber.Text);
                s.set_Contact(Contact.Text);
                s.set_Email(Email.Text);
                s.set_Status(Status.Text);
                if ((FirstName.Text == "") || (LastName.Text == "") || (Contact.Text == "") || (RegistrationNumber.Text == "") || (Email.Text == "") || (Status.Text == ""))
                {
                    MessageBox.Show("Submssion is not allowed with null values");
                }
                else if ((s.get_FirstName() == null) || (s.get_LastName() == null) || (s.get_Contact() == null) || (s.get_Registration_No() == null) || (s.get_Email() == null) || (s.get_Status() == null))
                {
                    MessageBox.Show("Invalid Data Entered!!");
                }

                else
                {
                    string        constr = "Data Source=DESKTOP-GP94IEM\\SQLEXPRESS;Initial Catalog=Projectb;Integrated Security=True";
                    SqlConnection c      = new SqlConnection(constr);
                    c.Open();

                    string     s2 = string.Format("SELECT LookupId FROM Lookup WHERE Category=@Category and Name =@Name");
                    SqlCommand a  = new SqlCommand(s2, c);
                    a.Parameters.Add(new SqlParameter("@Category", "STUDENT_STATUS"));
                    a.Parameters.Add(new SqlParameter("@Name", this.Status.Text));
                    int id = (int)a.ExecuteScalar();

                    string s1 = string.Format("INSERT INTO Student(FirstName,LastName,Contact,Email,RegistrationNumber,Status) values('" + s.get_FirstName() + "',  '" + s.get_LastName() + "','" + s.get_Contact() + "','" + s.get_Email() + "','" + s.get_Registration_No() + "','" + id + "')");

                    //string s1 = string.Format("INSERT INTO Student(FirstName,LastName,Contact,Email,RegistrationNumber,Status) values('{0}', '{1}', '{2}', '{3}', '{4}', '{5}')", s.get_FirstName(), s.get_LastName(), s.get_Contact(), s.get_Email(), s.get_Registration_No(), id);
                    SqlCommand a2 = new SqlCommand(s1, c);
                    //int rows = DatabaseConnection.getInstance().exectuteQuery(s1);
                    int rows = a2.ExecuteNonQuery();
                    if (rows != 0)
                    {
                        MessageBox.Show("Student Added");
                        this.Close();
                        StudentGrid n = new StudentGrid();
                        n.Show();
                    }
                    c.Close();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
コード例 #3
0
ファイル: Form1.cs プロジェクト: AqsaZahid256/DBMS_Project
        private void linkLabel6_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            StudentGrid g = new StudentGrid();

            g.Show();
        }
コード例 #4
0
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            string        constr = "Data Source=DESKTOP-GP94IEM\\SQLEXPRESS;Initial Catalog=Projectb;Integrated Security=True";
            SqlConnection conn   = new SqlConnection(constr);

            conn.Open();
            if (dataGridView1.Columns[e.ColumnIndex].Name == "Delete")
            {
                try
                {
                    MessageBox.Show("you are going to delete this row");


                    string     Reg    = (string)(dataGridView1.Rows[e.RowIndex].Cells["RegistrationNumber"].Value);
                    string     Reg_No = string.Format("SELECT ID FROM STUDENT WHERE RegistrationNumber=@RegistrationNumber");
                    SqlCommand o      = new SqlCommand(Reg_No, conn);
                    o.Parameters.Add(new SqlParameter("@RegistrationNumber", Reg));
                    int        t  = (int)o.ExecuteScalar();
                    string     Id = string.Format("DELETE FROM STUDENT WHERE Id=@Id");
                    SqlCommand p  = new SqlCommand(Id, conn);
                    p.Parameters.AddWithValue("@Id", t);
                    int i = p.ExecuteNonQuery();
                    if (i != 0)
                    {
                        MessageBox.Show("Data deleted");
                        conn.Close();
                        this.Hide();
                        StudentGrid d1 = new StudentGrid();
                        d1.Show();
                    }
                }

                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }

            else if (dataGridView1.Columns[e.ColumnIndex].Name == "Edit")
            {
                //SqlConnection c = new SqlConnection(constr);
                //conn.Open();
                panel1.Show();
                int    f   = dataGridView1.CurrentCell.RowIndex;
                string id4 = (string)(dataGridView1.Rows[e.RowIndex].Cells["RegistrationNumber"].Value);
                //MessageBox.Show("Updating this entry");
                string     Reg    = (string)(dataGridView1.Rows[e.RowIndex].Cells["RegistrationNumber"].Value);
                string     Reg_No = string.Format("SELECT Id FROM STUDENT WHERE RegistrationNumber=@RegistrationNumber");
                SqlCommand o      = new SqlCommand(Reg_No, conn);
                o.Parameters.Add(new SqlParameter("@RegistrationNumber", Reg));
                int t = (int)o.ExecuteScalar();

                string     s2 = string.Format("SELECT FirstName,LastName,Contact,Email,RegistrationNumber,Status FROM STUDENT Where Id=@Id");
                SqlCommand d  = new SqlCommand(s2, conn);
                d.Parameters.Add(new SqlParameter("@Id", t));
                SqlDataReader dr = d.ExecuteReader();
                try
                {
                    while (dr.Read())
                    {
                        textBox5.Text = dr.GetString(0);
                        textBox4.Text = dr.GetString(1);
                        textBox3.Text = dr.GetString(2);
                        textBox2.Text = dr.GetString(3);
                        textBox1.Text = dr.GetString(4);
                        if ((int)dr.GetValue(5) == 5)
                        {
                            comboBox1.Text = "Active";
                        }
                        else
                        {
                            comboBox1.Text = "InActive";
                        }
                    }
                    dr.Close();
                    panel1.Show();

                    /**
                     * string Reg = (string)(dataGridView1.Rows[e.RowIndex].Cells["RegistrationNumber"].Value);
                     * string Reg_No = string.Format("SELECT Id FROM STUDENT WHERE RegistrationNumber=@RegistrationNumber");
                     * SqlCommand o = new SqlCommand(Reg_No, c);
                     * o.Parameters.Add(new SqlParameter("@RegistrationNumber", Reg));
                     * int t = (int)o.ExecuteScalar();
                     * SqlCommand com = new SqlCommand("UPDATE STUDENT SET FirstName = @FirstName, LastName = @LastName,Contact = @Contact,Email =@Email,RegistrationNumber=@RegistrationNumber,Status=@Status WHERE Id ='" + t + "'");
                     * com.Parameters.Add("");
                     **/
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
            else
            {
                MessageBox.Show("No data Here");
            }
        }
コード例 #5
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                Student s = new Student();
                s.set_FirstName(textBox5.Text);
                s.set_LastName(textBox4.Text);
                s.set_Registration_No(textBox1.Text);
                s.set_Contact(textBox3.Text);
                s.set_Email(textBox2.Text);
                s.set_Status(comboBox1.Text);
                if ((s.get_FirstName() == null) || (s.get_LastName() == null) || (s.get_Contact() == null) || (s.get_Registration_No() == null) || (s.get_Email() == null) || (s.get_Status() == null))
                {
                    MessageBox.Show("Submssion is not allowed with null values");
                }
                else
                {
                    string        constr = "Data Source=DESKTOP-GP94IEM\\SQLEXPRESS;Initial Catalog=Projectb;Integrated Security=True";
                    SqlConnection c      = new SqlConnection(constr);
                    c.Open();

                    string     s2 = string.Format("SELECT LookupId FROM Lookup WHERE Category=@Category and Name =@Name");
                    SqlCommand a  = new SqlCommand(s2, c);
                    a.Parameters.Add(new SqlParameter("@Category", "STUDENT_STATUS"));
                    a.Parameters.Add(new SqlParameter("@Name", this.comboBox1.Text));
                    int id = (int)a.ExecuteScalar();

                    int    f   = dataGridView1.CurrentCell.RowIndex;
                    string id4 = (string)(dataGridView1.Rows[f].Cells["RegistrationNumber"].Value);
                    //MessageBox.Show("Updating this entry");
                    string     Reg    = (string)(dataGridView1.Rows[f].Cells["RegistrationNumber"].Value);
                    string     Reg_No = string.Format("SELECT Id FROM STUDENT WHERE RegistrationNumber=@RegistrationNumber");
                    SqlCommand o      = new SqlCommand(Reg_No, c);
                    o.Parameters.Add(new SqlParameter("@RegistrationNumber", Reg));
                    int t = (int)o.ExecuteScalar();

                    string s1 = string.Format("UPDATE STUDENT SET FirstName=@FirstName, LastName=@LastName,Contact=@Contact,Email=@Email,RegistrationNumber=@RegistrationNumber,Status=@Status where Id=@Id");

                    //values('" + s.get_FirstName() + "',  '" + s.get_LastName() + "','" + s.get_Contact() + "','" + s.get_Email() + "','" + s.get_Registration_No() + "','" + id + "')");

                    //string s1 = string.Format("INSERT INTO Student(FirstName,LastName,Contact,Email,RegistrationNumber,Status) values('{0}', '{1}', '{2}', '{3}', '{4}', '{5}')", s.get_FirstName(), s.get_LastName(), s.get_Contact(), s.get_Email(), s.get_Registration_No(), id);
                    List <SqlParameter> p  = new List <SqlParameter>();
                    SqlCommand          a2 = new SqlCommand(s1, c);
                    //GetExample(a2, p.ToArray());

                    a2.Parameters.Add(new SqlParameter("Id", t));

                    a2.Parameters.Add(new SqlParameter("@FirstName", SqlDbType.VarChar));
                    a2.Parameters["@FirstName"].Value = s.get_FirstName();
                    a2.Parameters.Add(new SqlParameter("@LastName", SqlDbType.VarChar));
                    a2.Parameters["@LastName"].Value = s.get_LastName();
                    a2.Parameters.Add(new SqlParameter("@Contact", SqlDbType.VarChar));
                    a2.Parameters["@Contact"].Value = s.get_Contact();
                    a2.Parameters.Add(new SqlParameter("@RegistrationNumber", SqlDbType.VarChar));
                    a2.Parameters["@RegistrationNumber"].Value = s.get_Registration_No();
                    a2.Parameters.Add(new SqlParameter("@Status", SqlDbType.VarChar));
                    a2.Parameters["@Status"].Value = id;
                    a2.Parameters.Add(new SqlParameter("@Email", SqlDbType.VarChar));
                    a2.Parameters["@Email"].Value = s.get_Email();

                    /**
                     * a2.Parameters.AddWithValue("@FirstName" , s.get_FirstName());
                     * a2.Parameters.AddWithValue("@LastName", s.get_LastName());
                     * a2.Parameters.AddWithValue("@ContactName", s.get_Contact());
                     * a2.Parameters.AddWithValue("@RegistrationNumber", s.get_Registration_No());
                     * a2.Parameters.AddWithValue("@Status", id);
                     * a2.Parameters.AddWithValue("@Email", s.get_Email());**/

                    //int rows = DatabaseConnection.getInstance().exectuteQuery(s1);
                    int rows = a2.ExecuteNonQuery();
                    if (rows != 0)
                    {
                        MessageBox.Show("Student Updated");
                        panel1.Hide();
                        StudentGrid m = new StudentGrid();
                        m.Show();
                        c.Close();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }