コード例 #1
0
        public frmStudentView(string User)
        {
            InitializeComponent();

            //Filling the textboxes in order for the student to view his/her marks.
            Con.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source = Students.accdb;
            Persist Security Info=False;";
            Con.Open();
            UserName = User;
            byte[]       ImageBytes;
            OleDbCommand Command = new OleDbCommand();

            Command.Connection  = Con;
            Command.CommandText = "select  FirstName,LastName,Passwords,tblStudents.StudentID,DOB,Mark1,Mark2,Mark3,Mark4,Mark5,Image,Address,Telephone,Gender from (tblStudents left join tblOtherInformation on tblStudents.StudentID=tblOtherInformation.StudentID) left join tblMarks on tblMarks.StudentID= tblStudents.StudentID where UserName='******'";
            OleDbDataReader Reader = Command.ExecuteReader();

            while (Reader.Read())
            {
                txtFirstName.Text  = Reader["FirstName"].ToString();
                txtLastName.Text   = Reader["LastName"].ToString();
                txtStudentID.Text  = Reader["StudentID"].ToString();
                txtDate.Text       = Convert.ToDateTime(Reader["DOB"].ToString()).ToString("yyyy/MM/dd");
                Mark[0]            = Reader["Mark1"].ToString();
                richtxtMarks.Text += Reader["Mark1"].ToString() + "\n";
                Mark[1]            = Reader["Mark2"].ToString();
                richtxtMarks.Text += Reader["Mark2"].ToString() + "\n";
                Mark[2]            = Reader["Mark3"].ToString();
                richtxtMarks.Text += Reader["Mark3"].ToString() + "\n";
                Mark[3]            = Reader["Mark4"].ToString();
                richtxtMarks.Text += Reader["Mark4"].ToString() + "\n";
                Mark[4]            = Reader["Mark5"].ToString();
                richtxtMarks.Text += Reader["Mark5"].ToString();
                txtPassword.Text   = Reader["Passwords"].ToString();
                txtAddress.Text    = Reader["Address"].ToString();
                txtTelephone.Text  = Reader["Telephone"].ToString();
                txtGender.Text     = Reader["Gender"].ToString();
                try
                {
                    ImageBytes = (byte[])Reader["Image"];
                    MemoryStream MS = new MemoryStream(ImageBytes, 0, ImageBytes.Length);
                    imgStudent.Image = Image.FromStream(MS, true);
                }
                catch { }
            }

            for (int i = 0; i < Mark.Length; i++)
            {
                Mark[i] = Mark[i].Replace(" ", "");
                if (Mark[i] == "")
                {
                    Array.Resize(ref Mark, i);
                    break;
                }
            }
            Marking Grading = new Marking();

            Grading.Calculation(Mark);
            txtAverage.Text = Grading._Average.ToString();
            txtLevel.Text   = Grading._Level.ToString();
            Con.Close();
        }
コード例 #2
0
        public frmAdmin(bool Button, string User)
        {
            InitializeComponent();
            //Connecting to the database.
            Con.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source = Students.accdb;
            Persist Security Info=False;";
            comboGender.Items.Add("Male");
            comboGender.Items.Add("Female");
            comboGender.Items.Add("Other");
            Buttons = Button;
            byte[] ImageBytes;
            UserName = User;
            if (Button == false)
            {
                //False means that the admin picked that he wanted to edit a user account.
                int NumberOfMarks = Mark.Length;
                btnSave.Text = "Save changes";
                Con.Open();
                OleDbCommand Command = new OleDbCommand();
                Command.Connection  = Con;
                Command.CommandText = "select  FirstName,LastName,Passwords,tblStudents.StudentID,DOB,Mark1,Mark2,Mark3,Mark4,Mark5,Image,Address,Telephone,Gender from (tblStudents left join tblOtherInformation on tblStudents.StudentID=tblOtherInformation.StudentID) left join tblMarks on tblMarks.StudentID= tblStudents.StudentID where UserName='******'";

                OleDbDataReader Reader = Command.ExecuteReader();
                while (Reader.Read())
                {
                    txtFirstName.Text  = Reader["FirstName"].ToString();
                    txtLastName.Text   = Reader["LastName"].ToString();
                    txtStudentID.Text  = Reader["StudentID"].ToString();
                    txtDate.Text       = Convert.ToDateTime(Reader["DOB"].ToString()).ToString("yyyy-MM-dd");
                    Mark[0]            = Reader["Mark1"].ToString();
                    richtxtMarks.Text += Reader["Mark1"].ToString() + "\n";
                    Mark[1]            = Reader["Mark2"].ToString();
                    richtxtMarks.Text += Reader["Mark2"].ToString() + "\n";
                    Mark[2]            = Reader["Mark3"].ToString();
                    richtxtMarks.Text += Reader["Mark3"].ToString() + "\n";
                    Mark[3]            = Reader["Mark4"].ToString();
                    richtxtMarks.Text += Reader["Mark4"].ToString() + "\n";
                    Mark[4]            = Reader["Mark5"].ToString();
                    richtxtMarks.Text += Reader["Mark5"].ToString();
                    txtPassword.Text   = Reader["Passwords"].ToString();
                    txtAddress.Text    = Reader["Address"].ToString();
                    txtTelephone.Text  = Reader["Telephone"].ToString();
                    comboGender.Text   = Reader["Gender"].ToString();
                    // http://stackoverflow.com/questions/9173904/byte-array-to-image-conversion and http://stackoverflow.com/questions/18998763/how-to-retrieve-binary-image-from-database-using-c-sharp-in-asp-net
                    // Changing the image into binary code is obtained from stackoverflow.
                    try
                    {
                        //Changing the stored binary into an image.
                        ImageBytes = (byte[])Reader["Image"];
                        MemoryStream MS = new MemoryStream(ImageBytes, 0, ImageBytes.Length);
                        imgStudent.Image = Image.FromStream(MS, true);
                    }
                    catch { }
                }
                //Detecting how many marks are available.
                for (int i = 0; i < Mark.Length; i++)
                {
                    Mark[i] = Mark[i].Replace(" ", "");
                    if (Mark[i] == "")
                    {
                        Array.Resize(ref Mark, i);
                        break;
                    }
                }
                Reader.Close();
                Marking Grading = new Marking();
                try
                {
                    //Calculating the average and level.
                    Grading.Calculation(Mark);
                    txtAverage.Text = Grading._Average.ToString();
                    txtLevel.Text   = Grading._Level.ToString();
                }
                catch { }
                Con.Close();
                Reader.Close();
            }
            if (Button == true)
            {
                //If the user decided to create a user, then it will a true.
                btnSave.Text         = "Create account";
                txtStudentID.Visible = false;
                lblStudentID.Visible = false;
                txtAverage.Visible   = false;
                txtLevel.Visible     = false;
                lblLevel.Visible     = false;
                lblAverage.Visible   = false;
            }
        }