INTRODUCTION
1.1 PROBLEM STATEMENT:
Online examination is very helpful to users. The aim of this project is to provide quick,
immediate and easy way to appear the exam. It can provide special advantages to the
students/applications. The examination system automatically adds the mark allocated in each
question to determine the total marks for the questions. A time limit can be set for the question.
Online Examination System allows jumping to specific questions based on the previous answer.
The online examination limits the number of time a student can write a question. Login module
helps the user to login to the foe that he/she must type the username and password correctly. The
login Provision in this page helps the already registered user to directly access the site there is a
link for registration to a user who is new to this site. Student module is mainly for the students.
This helps the student to register for the exam and answer the exam. For register name, roll no,
department, degree, shift. Password should be entered and other are filled. This will provide
result after the exam according to correct and wrong answer. staff module is mainly contain the
creation of question paper, preview of already created question paper, and the report . For
creating the question paper he/she must enter Exam ID. No of questions, total time marks per
Question. Option type for showing the preview of already created question paper he/she must
enter the correct Exam id.
1.2 PROJECT DESCRIPTION
Modular Online Examination for Computer Science Department is title of this
project. Manual examination pattern for Computer Science Department in shifting to Online
Examination style is “Apex Objective” of this project. In this project gives of students
performance evaluation. Student Registration and Staff Registration are main two separate
phases of this project
‘Staff Registration’ phase is bringing it’s control the mode of job of subject Add,
Delete and question making works. ‘Student Registration’ phase is containing the mode of job to
login, Authentication, Subject, Selection and examination
At this project establish a link between question phase and exam phase. This is
important one and acting as bridge between them. This project is possessing the following
modules.
• Staff
• Question
• Student
• Subject
• Exam
• Result
In first the student register our details. Logging into the system then select the test. Selection
whether the test to taken in practice mode where the correct answer is shown after the exam.
The candidate select an option. Appearing for the [Link] limitation of the test if any.
Whether to randomize the questions. Staff logging into the [Link]/edit/delete the
questions then create the test. Staff only changing any modification of the exam process.
Question bank is created by the staff. At this section whenever staff gives inputs, at that timing
that data collection will in corporate and compare the existing database of project. Subjective
questions are the question with 4 choices of answers will be provided and student has to choose
any one out of it. Once the exam is finished, all the answers will be saved on the databases under
the prescribed student roll number. Answers and mars are allotted directly corrected by this
system. Finally results are generated.
1.3 EXISTING SYSTEM
The whole process of assigning test and evaluating their scores after the test , was done
manually till date. Processing the test paper checking and distributing respective scores used to
take time when the software was not installed. Actually this project’s process is [Link]
manual functionality has returned the following feed backs.
DISADVANTAGES OF EXISTING SYSTEM:
• Human process unable to manage the hurry situations and it cannot face the dramatical
changes of official activity.
• The existing system cannot provide a better security to the datum.
• The existing system is not [Link] it will create many major problems. If
department wants to avoid the above problems, It must be computerized with WAN support.
• The current system is very time consuming.
• To take exam of more candidates more invigilators are required but no need of invigilator
in case of online examinations.
• The chances of paper leakage are more in current system as compared to proposed
system.
• Result processing takes more time as it done manually.
• Offline examination is time consuming.
• Waste of paper.
• Delay of result
1.4 PROPOSED SYSTEM:
From proposed system developer has shifted the progressions of examination from
manual to manual. In this project, developer has covered the entire course of actions of
examination process. First, programmer has sketched out works and take list of necessary
modules. Then will create databases required no-of tables in backend SQL server for
administrate core records of examination.
Then programmer should develop the designing, coding in front-end the following
operations.
• Auto generation as sequentially.
• New records are affected from front-end to back-end.
• Validation process.
• Retrieving process.
• Modify (or) Updating process.
• Records finding process.
• Referential intergration process.
• And all dynamic actions.
2. SYSTEM DESIGN
2.4 FORM DESIGN
Input design is the process of converting user oriented in com based
format. Input design one of the most expensive a face of the computerized system
and is offer major problem of a system in this project input design is done with
various form and various method.
2.4.1 STUDENT REGISTRATION
This page is used to register the students details.
2.4.2 STUDENT LOGIN
The student gives correct student name and password to enter into the
application.
2.4.3 STAFF REGISTRATION
This page is used staff registration details.
2.4.4 STAFF LOGIN
This page is used staff login. The user gives correct and staff ID and
password to enter the application.
2.2.5 ADD SUBJECT
Staff can add, delete, update the particular subject.
2.2.6 CREATE QUESTION
This page is used to create question. The staff can add, delete, update
question.
2.2.7 OVERALL REPORT
This form is displayed overall Student Report.
2.5 MODULES EXPLANATION
1) Staff
2) Question Bank
3) Student
4) Subject Selection
5) Exam
6) Result
1) Staff
This is separate modules and especial to authorized staff registration,
department, subject name are feeding. If above information are correct, Gateway
will open for Adding, Deleting, Updating the question process. This is working
principle of staff module.
2) Question Bank
Examination related Questions are generated for students by staff. The
student will select the subject to get the particular questions. The questions are
Randamly prepared by the staff. The Staff only login to create, delete, update, clear
questions in this section.
3) Student
At this section only for computer science students. Students registration
details are feeding here, then the details will save permanently in a table of
particular database. Then student will select the subject to write the exam.
4) Subject Selection
Subject selection for examination is a vital task of this modules. List out the
department related subjects for exam candidate’s selection purpose. This task is
occurring at this unit.
5) Exam
The student will select the subject, then the questions are Randam to
displayed. Then students are write the exam. The examination section is particular
time to logout.
6) Result
Finish the exam progression result will generate as automatically. The result
is two types to displayed. The first one is subject wise, the students select the
subject result is displayed. Another one is class wise to generating result.
3. SYSTEM IMPLEMENTATION
System implementation is the stage of the project when the theoretical is
tuned into working system. If any implementation system stage is not carefully
controlled and planned, it can cause chaos. Thus it can be the most critical stage in
achieving a successful new system and in giving the users a confidence that the
system at work and be effective.
3.1 MODULES IMPLEMENTATION
Home:
Step 1: Run the project
Step 2: Open the home page
Step 3: Display the home page
Step 4: End
Staff:
Step 1: Start
Step 2: Register our details
Step 3: Enter valid staff id and password then click login
Step 4: Then the question adding process
Step 5: Click the question page.
Step 6: Select the subject the question id is automatically displayed
Step 7: Enter the questions.
Step 8: Click to save questions
Step 9: Display the message box” Question added successfully”
Step 10: Then the question is successfully added
Step 11: End
Question:
Step 1: Start
Step 2: Select the Subject
Step 3: Question id is automatically displayed
Step 4: Enter Questions
Step 5: Click to save, delete, Update, Clear the questions
Step 6: Display the message box” successfully”
Step 7: End
Student:
Step 1: Start
Step 2: Register the Students details
Step 3: Enter the student name& roll number then click to login
Step 4: Select the subject
Step 5: Display the particular questions
Step 6: Click to write the exam
Step7: End
Subject:
Step 1: Start
Step 2: Open the subject page
Step 3: Click to select the subject
Step 4: Take the examination
Step 5: End
Exam:
Step 1: Start
Step 2: Display the exam page
Step 3: Subject name, no-of questions, starting time & running time is
appearing this
Page
Step 4: Display the question & answers
Step 5: Click the correct answer to write the exam
Step 6: End
Result:
Step 1: Start
Step 2: Then click the report
Step 3: Staff id & password type and click the button
Step 4: Then view the result
Step 5: End
4. SYSTEM TESTING
Unit Testing:
The software units in a system are modules and routines that are assembled and
integrated to perform a specific function. Unit testing focuses first on modules,
independently of one another, to locate errors. This enables, to detect errors in
coding and logic that are contained within each module. This testing includes
entering data and ascertaining if the value matches to the type and size supported
by java. The various controls are tested to ensure that each performs its action as
required.
Integration Testing :
Data can be lost across any interface, one module can have an adverse
effect on another, sub functions when combined, may not produce the desired
major functions. Integration testing is a systematic testing to discover errors
associated within the interface. The objective is to take unit tested modules and
build a program structure. All the modules are combined and tested as a whole.
Here the Server module and Client module options are integrated and tested. This
testing provides the assurance that the application is well integrated functional unit
with smooth transition of data.
Objective Test:
We Have First Written Objectives That Can Understand System. I have
Prioritized Objective. Test Environment: By this testing we can check ability to
utilize existing computers to set up separate test environment. This includes web
server, database server and client application.
Logical Testing
Download [Link], [Link], java, c, c++, project source code and project Search this
Project Report on Online Entrance Examination System Project. Logical testing
was conducted to test every aspect of each form, report and query as soon as it was
implemented, using valid, invalid and extreme data. Test data was added to each
code module and results compared with the expected results.
II. Functional Testing
Each menu item was tested in turn to ensure that no function had been missed out.
III. System Testing - Online Examination System project
We manage end to end process of Online Entrance Examination. Online and
Offline Registration Management system for EXON Solutions is derived from
Examination. The whole ranges of tests were conducted to ensure that no errors
had been introduced in the system. In system testing, performance and acceptance
standards were developed and substandard performance or service interruptions
that result in system failure were checked. System testing did also check the
integration of the various modules along with the testing of the logical and
syntactical errors. System testing was conducted in a phase wise manner; the
involved phases were as follows :-
1. Program Testing (To test logical and syntactical errors)
2. System Testing (To test system integrity)
3. String Testing (To test the interactivity of the programs)
IV. Recovery Testing
Online Examination System is built on [Link], Entrance examinations can also
be conducted. Online Examination Project Report Documentation. The computer
was rebooted while the database was open to insure that data was not lost or
corrupted in the event of a power failure. The recovery testing was also aimed at
determining the system ability to face an awkward situation like paper jam in the
printer.
V. Acceptance Testing
Download [Link], [Link], java, c, c++, project source code and project Online
Entrance Examination System [Link] Project. Java Online Examination System.
The acceptance test had the objective of selling the user on the validity and
reliability of the system. It verified that the system’s procedure operated system
specifications and that the integrity of important data was maintained. Performance
of an acceptance test was actually the user’s show. User motivation was very
important for the successful performance of the system.
5. FUTURE ENHANCEMENT
Software scope describes the data and control to be processed, function describes
performance, constants, interfaces and reliability. Function describes in the
statement of scope are evaluated and in some case refined to provide more detail
prior to the beginning of the estimation. Because both cost and schedule estimates
are functionally oriented, some degree of decomposition is often useful. We can
implement easily this application. Reusability is possible as and when we require
in this application. We can update it next version. We can add new features as and
when we require. There is flexibility in all the modules. Scope of this document is
to put down the requirements. Clearly identifying the information needed by the
user, the source of the information and outputs expected from the system. It is
highly likely that the scope well change web application project moves forward ;
the web process model should be incremental. This allows the development team
to “freez” the scope for one increment so that an operational web application
release can be created. The next increment, but once the second increment
commences, scope is again frozen temporarily. This approach enables the web App
team to work without having to accommodate.
6. CONCLUSION:
This Web Application provides facility to conduct online examination world wide.
It saves time as it allows number of students to give the exam at a time and
displays the results as the test gets over, so no need to wait for the result. It is
automatically generated by the server. Administrator has a privilege to create,
modify and delete the test papers and its particular questions. User can register,
login and give the test with his specific id, and can see the results as well.
REFERENCES
APPENDIX A SYSTEM SPECIFICATION
HARDWARE SPECIFICATION:
• System : Pentium IV 2.4 GHz.
• Hard Disk : 40 GB.
• Floppy Drive : 1.44 Mb.
• Monitor : 15 VGA Color.
• Mouse : Logitech.
• Ram : 512 Mb.
SOFTWARE SPECIFICATION:
• Operating system : Windows XP/7.
• Coding Language : C#.net, ASP .net
• Tool : Visual Studio 2010
APPENDIX B
SAMPLE CODING
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
public partial class all_forgotpassword1 : [Link]
protected void Page_Load(object sender, EventArgs e)
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
public partial class all_modify : [Link]
SqlConnection con = new SqlConnection(@"Data Source=.\
SQLEXPRESS;AttachDbFilename=E:\PROJECT\New folder\Online_Exam_New
fresh\App_Data\[Link];Integrated Security=True;User Instance=True");
protected void Page_Load(object sender, EventArgs e)
if (!IsPostBack)
if ([Link]["id"] != null)
[Link] = [Link]["id"];
[Link]();
SqlCommand d = new SqlCommand("select sname from oe_subjects
where sid=" + [Link], con);
SqlDataReader dr;
dr = [Link]();
[Link]();
[Link] = false;
[Link] = dr[0].ToString();
[Link] = dr[0].ToString();
[Link]();
protected void sub_Click(object sender, EventArgs e)
[Link]();
SqlCommand d = new SqlCommand("Update oe_subjects set sname='" +
[Link] + "' where sid=" + [Link], con);
[Link]();
[Link]("<script>");
[Link]("alert('Updated Successful')");
[Link]("</script>");
protected void can_Click(object sender, EventArgs e)
[Link]();
SqlCommand d = new SqlCommand("delete from oe_subjects where sid=" +
[Link], con);
[Link]();
[Link]("<script>");
[Link]("alert('Deleted Successful')");
[Link]("</script>");
protected void DDLID_TextChanged(object sender, EventArgs e)
[Link]();
SqlCommand d = new SqlCommand("select sname from oe_subjects where
sid=" + [Link], con);
SqlDataReader dr;
dr = [Link]();
[Link]();
[Link] = dr[0].ToString();
[Link] = dr[0].ToString();
[Link]();
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
public partial class all_Questions : [Link]
{
SqlConnection con = new SqlConnection(@"Data Source=.\
SQLEXPRESS;AttachDbFilename=E:\PROJECT\New folder\Online_Exam_New
fresh\App_Data\[Link];Integrated Security=True;User Instance=True");
string si = null;
protected void Page_Load(object sender, EventArgs e)
if (!IsPostBack)
string SubjectName = "";
[Link]();
SqlCommand cmd1 = new SqlCommand("select subId from oe_staffs
where sid=" + Session["StaffId"].ToString(), con);
SqlDataReader dr = [Link]();
if ([Link]())
SubjectName = dr[0].ToString();
[Link]();
if (SubjectName != "")
[Link]();
SqlCommand cmd = new SqlCommand("select * from oe_subjects
where sname in (" + SubjectName + ")", con);
//[Link]("@sname", SubjectName);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
[Link](ds);
[Link] = [Link][0].Columns["sname"].ToString();
[Link] = [Link][0].Columns["sid"].ToString();
[Link] = [Link][0];
[Link]();
[Link](0, new ListItem("--Select--", "-1"));
[Link]();
//int s;
//string ss = [Link](Session["A"]);
//[Link]();
//SqlCommand cmd2 = new SqlCommand("select sid, sname from
oe_subjects where sid='" + [Link] + "'", con);
//SqlDataReader dr = [Link]();
//if ([Link]())
//{
// string s2;
// s2 = dr[1].ToString();
// si = dr[0].ToString();
// //[Link] = [Link]();
//}
//[Link]();
//[Link]();
//SqlCommand cmd1 = new SqlCommand("select isnull(max(qid),0) from
oe_questions where sid='" + [Link] + "'", con);
//SqlDataReader dr1 = [Link]();
//if([Link]()){
////string sl = [Link]([Link]());
////if (sl == null || sl == "")
////{
//// s = 1;
////}
////else
////{
// s = Convert.ToInt32(dr1[0]);
// s = s + 1;
// [Link] = [Link]();
//}
//[Link]();
protected void btnsave_Click(object sender, EventArgs e)
{
//SqlCommand cmd2 = new SqlCommand("select noq from oe_subjects
where sid=" + ss, con);
//string s2 = [Link]([Link]());
//int c = Convert.ToInt32(s2);
//[Link]();
//if (s > c)
//{
// [Link]([Link](), "myalert",
"alert('Question stack is Full');", true);
// [Link]("~/all/[Link]");
//}
//int kk;
//kk = Convert.ToInt16(Session["sid"]);
[Link]();
SqlCommand cmd = new SqlCommand("insert into oe_questions values('" +
[Link] + "','" + [Link] + "','" + [Link] + "','" +
[Link] + "','" + [Link] + "','" + [Link] + "','" + [Link]
+ "','" + si + "','" + [Link] + "')", con);
[Link]();
[Link]();
[Link]([Link](), "myalert", "alert('Question
Added Successfully');", true);
[Link]();
SqlCommand d = new SqlCommand("select isnull(max(qid),0) from
oe_questions where sname='" + [Link] + "'", con);
SqlDataReader dr = [Link]();
if ([Link]())
int i, j;
i = Convert.ToInt16(dr[0]);
j = i + 1;
[Link] = [Link]();
[Link]();
//[Link] = "";
[Link] = "";
[Link] = "";
[Link] = "";
[Link] = "";
[Link] = "";
[Link] = "";
//int s;
//[Link]();
//SqlCommand cmd1 = new SqlCommand("select max(qid) from
oe_questions where sid=" + si, con);
//string sl = [Link]([Link]());
//if (sl == null || sl == "")
//{
// s = 1;
//}
//else
//{
// s = Convert.ToInt32(sl);
// s = s + 1;
//}
// [Link] = [Link]();
protected void btndelete_Click(object sender, EventArgs e)
//SqlConnection con = new SqlConnection(@"Data Source=.\
SQLEXPRESS;AttachDbFilename=D:\PROJECT\Online_Exam\App_Data\
[Link];Integrated Security=True;User Instance=True");
int kk;
kk = Convert.ToInt16(Session["sid"]);
[Link]();
SqlCommand cmd = new SqlCommand("delete from oe_questions where
qid='" + [Link] + "' and sname='" + [Link] + "'", con);
[Link]();
[Link]();
[Link]([Link](), "myalert", "alert('Question
Deleted Successfully');", true);
[Link]();
[Link] = "";
[Link] = false;
[Link] = "";
[Link] = "";
[Link] = "";
[Link] = "";
[Link] = "";
[Link] = "";
public void show1(object a, EventArgs b)
int kk;
kk = Convert.ToInt16(Session["sid"]);
[Link]();
SqlCommand d = new SqlCommand("select
question,ans1,ans2,ans3,ans4,cans from oe_questions where qid='" + [Link] +
"' and sname='" + [Link] + "'", con);
SqlDataReader dr;
dr = [Link]();
if ([Link]())
[Link] = dr[0].ToString();
[Link] = dr[1].ToString();
[Link] = dr[2].ToString();
[Link] = dr[3].ToString();
[Link] = dr[4].ToString();
[Link] = dr[5].ToString();
[Link]();
public void del(object a, EventArgs b)
[Link] = true;
protected void btnupdate_Click(object sender, EventArgs e)
{
int kk;
kk = Convert.ToInt16(Session["sid"]);
[Link]();
SqlCommand cmd = new SqlCommand("update oe_questions set question='"
+ [Link] + "', ans1='" + [Link] + "', ans2='" + [Link] + "',
ans3='" + [Link] + "', ans4='" + [Link] + "', cans='" +
[Link] + "' where qid='" + [Link] + "'", con);
[Link]();
[Link]();
[Link]([Link](), "myalert", "alert('Question
Updated Successfully');", true);
[Link] = "";
[Link] = "";
[Link] = "";
[Link] = "";
[Link] = "";
[Link] = "";
[Link] = "";
[Link]();
protected void btncancle_Click(object sender, EventArgs e)
[Link] = "";
[Link] = "";
[Link] = "";
[Link] = "";
[Link] = "";
[Link] = "";
[Link] = "";
[Link]();
protected void subID_SelectedIndexChanged(object sender, EventArgs e)
//[Link]([Link](), "myalert", "alert('Not
Able to Choose another Subjects');", true);
[Link]();
SqlCommand d = new SqlCommand("select isnull(max(qid),0) from
oe_questions where sname='" + [Link] + "'", con);
SqlDataReader dr = [Link]();
if ([Link]())
int i, j;
i = Convert.ToInt16(dr[0]);
j = i + 1;
[Link] = [Link]();
[Link]();
protected void move(object sender, EventArgs e)
[Link]();
SqlCommand cmd = new SqlCommand("select * from oe_subjects", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
[Link](ds);
[Link] = [Link][0].Columns["sname"].ToString();
[Link] = [Link][0].Columns["sid"].ToString();
[Link] = [Link][0];
[Link]();
[Link]();
[Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
public partial class all_subject : [Link]
SqlConnection con = new SqlConnection(@"Data Source=.\
SQLEXPRESS;AttachDbFilename=E:\PROJECT\New folder\Online_Exam_New
fresh\App_Data\[Link];Integrated Security=True;User Instance=True");
protected void Page_Load(object sender, EventArgs e)
if (!IsPostBack)
bindSubject();
public void bindSubject()
[Link]();
SqlCommand cmd = new SqlCommand("select * from oe_subjects", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
[Link](ds);
[Link] = [Link][0].Columns["sname"].ToString();
[Link] = [Link][0].Columns["sid"].ToString();
[Link] = [Link][0];
[Link]();
[Link](0, new ListItem("--Select--", "-1"));
[Link]();
protected void sub_Click(object sender, EventArgs e)
SqlConnection con = new SqlConnection(@"Data Source=.\
SQLEXPRESS;AttachDbFilename=E:\PROJECT\New folder\Online_Exam_New
fresh\App_Data\[Link];Integrated Security=True;User Instance=True");
bool flag = false;
if (Session["StaffId"] != null)
string subsId = "";
string StaffId = Session["StaffId"].ToString();
Session["sid"] = [Link];
//SqlCommand cmd = new SqlCommand("insert into oe_subjects values("
+ [Link] + ",'" + [Link] + "','" + "10" + "')", con);
[Link]();
SqlCommand cmd3 = new SqlCommand("select subId from oe_staffs
where sid not in (" + StaffId + ")", con);
SqlDataAdapter da1 = new SqlDataAdapter(cmd3);
DataTable ds1 = new DataTable();
[Link](ds1);
[Link]();
foreach (DataRow item in [Link])
if (item[0].ToString() != "")
if (!item[0].ToString().Contains([Link]))
flag = true;
else
flag = false;
break;
if ([Link] == 0)
flag = true;
if (flag==true)
[Link]();
SqlCommand cmd1 = new SqlCommand("select isnull(subId,'0') from
oe_staffs where sid=" + StaffId, con);
SqlDataReader dr = [Link]();
if ([Link]())
//subsId = dr[0].ToString();
if (dr[0].ToString() == [Link])
{
[Link]([Link](), "myalert",
"alert('This Subject Already Assigned to Staff.');", true);
else
if ("0" == dr[0].ToString())
subsId = "'" + [Link] + "'";
else
subsId = dr[0].ToString();
subsId = subsId + ",'" + [Link] + "'";
//subsId = [Link];
[Link]();
[Link]();
[Link]();
SqlCommand cmd = new SqlCommand("update oe_staffs set
subId=@subId where sid=" + StaffId, con);
[Link]("@subId", subsId);
[Link]();
[Link]();
[Link]([Link](), "myalert",
"alert('Subject Assigned to Staff Successfully');", true);
[Link] = false;
[Link] = false;
if ([Link] == [Link])
[Link]();
else
{
[Link]([Link](), "myalert", "alert('This
Subject Already Assigned to another Staff');", true);
protected void can_Click(object sender, EventArgs e)
[Link]("../Staff_Home.aspx");
protected void DDLSName_SelectedIndexChanged(object sender, EventArgs e)
[Link] = [Link];
//if ([Link] == "C Language")
//{
// [Link]="1";
//}
//else if ([Link] == "Java")
//{
// [Link]="2";
//}
//else if ([Link] == "C++")
//{
// [Link]="3";
//}
//else if ([Link] == "OS")
//{
// [Link]="4";
//}
//else
//{
//}
protected void nadd(object sender, EventArgs e)
[Link]();
SqlCommand d = new SqlCommand("Select isnull(max(sid),0) from
oe_subjects", con);
SqlDataReader dr = [Link]();
[Link]();
int i, j;
i = Convert.ToInt16(dr[0]);
j = i + 1;
[Link] = [Link]();
[Link]();
[Link] = true;
[Link] = true;
protected void sub_Clck(object sender, EventArgs e)
[Link]();
SqlCommand cmd = new SqlCommand("insert into oe_subjects values(" +
[Link] + ",'" + [Link] + "','" + "10" + "')", con);
[Link]();
[Link]();
[Link] = false;
[Link] = false;
[Link] = "";
[Link]([Link](), "myalert", "alert('New
Subject Added Successfully');", true);
bindSubject();
protected void T121_TextChanged(object sender, EventArgs e)
[Link]();
SqlCommand d = new SqlCommand("Select isnull(max(sid),0) from
oe_subjects", con);
SqlDataReader dr = [Link]();
[Link]();
int i, j;
i = Convert.ToInt16(dr[0]);
j = i + 1;
[Link] = [Link]();
[Link]();
protected void nadd1(object sender, EventArgs e)
{
[Link]("[Link]?id=" + [Link]);
Overall [Link]
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
public partial class Staff_Login : [Link]
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnLogin_Click(object sender, EventArgs e)
SqlConnection con = new SqlConnection([Link] );
try
[Link]();
SqlCommand cmd = new SqlCommand("select * from oe_staffs where
StaffID = @stfid and Password = @pwd", con);
[Link]("@stfid", [Link], 10).Value =
[Link];
[Link]("@pwd", [Link], 10).Value =
[Link];
Session["A"] = [Link];
SqlDataReader dr = [Link]();
if ([Link]())
Session["StaffId"] = dr[0].ToString();
[Link]();
[Link]("Staff_Home.aspx");
}
else
[Link] = "Invalid Login!";
[Link]();
catch (Exception ex)
[Link] = "Error --> " + [Link];
finally
[Link]();
protected void btnReg_Click(object sender, EventArgs e)
[Link]("Staff_Register.aspx");
}
Staff login
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
public partial class Staff_Login : [Link]
protected void Page_Load(object sender, EventArgs e)
}
protected void btnLogin_Click(object sender, EventArgs e)
SqlConnection con = new SqlConnection([Link] );
try
[Link]();
SqlCommand cmd = new SqlCommand("select * from oe_staffs where
StaffID = @stfid and Password = @pwd", con);
[Link]("@stfid", [Link], 10).Value =
[Link];
[Link]("@pwd", [Link], 10).Value =
[Link];
Session["A"] = [Link];
SqlDataReader dr = [Link]();
if ([Link]())
Session["StaffId"] = dr[0].ToString();
[Link]();
[Link]("Staff_Home.aspx");
}
else
[Link] = "Invalid Login!";
[Link]();
catch (Exception ex)
[Link] = "Error --> " + [Link];
finally
[Link]();
protected void btnReg_Click(object sender, EventArgs e)
[Link]("Staff_Register.aspx");
}
}
Staff Registration
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
public partial class Staff_Register : [Link]
protected void Page_Load(object sender, EventArgs e)
}
protected void btnRegister_Click(object sender, EventArgs e)
SqlConnection con = new SqlConnection([Link]);
try
[Link]();
SqlCommand cmd = new SqlCommand("select * from oe_staffs where
staffID = @stfid", con);
[Link] = "select isnull(max(sid),0) + 1 from oe_staffs";
int sid = (Int32)[Link]();
[Link]();
[Link] = "insert into oe_staffs
values(@sid,@stfname,@stfid,@spwd,@dpt,@subId)";
[Link]("@sid", [Link]).Value = sid;
[Link]("@stfname", [Link], 20).Value =
txt_staffname .Text;
[Link]("@stfid", [Link], 20).Value =
txt_StaffID.Text;
[Link]("@spwd", [Link], 20).Value =
txt_password.Text;
[Link]("@dpt", [Link], 30).Value =
DL_degree.Text;
[Link]("@subId", [Link], 30).Value =
[Link];
if ([Link]() > 0)
[Link] = "Registration is successful. Please click <a
href=Staff_Login.aspx>here</a> to login!";
txt_staffname.Text = "";
txt_StaffID.Text = "";
txt_password.Text = "";
else
[Link] = "Sorry! Some error occured during registration!";
catch (Exception ex)
[Link] = "Error --> " + [Link];
}
finally
[Link]();
protected void btnCancel_Click(object sender, EventArgs e)
[Link]("[Link]");
APPENDIX C
SAMPLE SCREEN SHOT