Online examination system project In Asp.Net with c#, SQL Database including Admin Panel - Download Part 1
Admin Login
DashBoard.aspx Page code
======================================================================
UserEntry.aspx Page code
ManageUsers.aspx Code
using System;
=======================================================================
SubjectEntry.aspx Code
=======================================================================
SubjectEntry.aspx.cs Code
=======================================================================
Questions Create\Read\Update\Delete
Live-Online Examination System is an online examinationing program ran by qualified live examination online perfect for your children to enhance their education online. Online examinationing is an easy way to teach kids and to let them have fun while learning. Live-Online Examination System has advanced online examinationing techniques using an advanaced online classroom to examination children online
Screens : These are the screens for OnlineExam.
Admin Login Panel
Admin Login
Dash Board
Create User
Create Exam
Manage Users
Subject Entry
Question Entry
Exam Entry
View results
View\Edit Questions
Reports
User Login
User Home
Update profile
Change Password
Start Exam
Previous Exams
Downloads
Admin Login Screen master Page :
AdminMaster.master
<%@ Master
Language="C#"
AutoEventWireup="true"
CodeBehind="AdminMaster.master.cs"
Inherits="OnlineExam.AdminMaster"
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD
XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>:: Online Examination System::</title>
<link href="bower_components/bootstrap/dist/css/bootstrap.min.css"
rel="stylesheet"
type="text/css"
/>
<link href="bower_components/metisMenu/dist/metisMenu.min.css"
rel="stylesheet"
type="text/css"
/>
<link href="dist/css/sb-admin-2.css"
type="text/css"
rel="stylesheet"/>
<link href="bower_components/font-awesome/css/font-awesome.min.css"
rel="stylesheet"
type="text/css"/>
<script src="bower_components/jquery/dist/jquery.min.js"
type="text/javascript"></script>
<script src="bower_components/bootstrap/dist/js/bootstrap.min.js"
type="text/javascript"></script>
<script src="bower_components/metisMenu/dist/metisMenu.min.js"
type="text/javascript"></script>
<script src="dist/js/sb-admin-2.js"
type="text/javascript"></script>
</head>
<body>
<form id="form1" runat="server">
<div>
<div id="wrapper">
<!-- Navigation -->
<nav class="navbar
navbar-default navbar-static-top" role="navigation" style="margin-bottom: 0">
<div >
<a class="navbar-brand" href="">
<h4 style="font-size: x-large; font-weight: bold; color: #800000">
Online Examination - Admin Panel </h4><asp:Image ID="Image1" runat="server"
ImageUrl=""
></asp:Image></a><br />
</div>
<!-- /.navbar-header -->
<ul class="nav
navbar-top-links navbar-right">
<!-- /.dropdown -->
<li
class="dropdown">
<a class="dropdown-toggle"
data-toggle="dropdown"
href="#">
<i class="fa fa-user fa-fw"></i> <i class="fa fa-caret-down"></i>
</a>
<ul
class="dropdown-menu
dropdown-user">
<li><a href="" target="_blank"><i class="fa fa-user fa-fw"></i>View Website</a>
</li>
<li><a href=""><i
class="fa fa-gear
fa-fw"></i> Settings</a>
</li>
<li class="divider"></li>
<li><a href=""><i
class="fa
fa-sign-out fa-fw"></i><asp:LinkButton ID="LinkButton1"
runat="server"
Text="Logout"
onclick="LinkButton1_Click1"></asp:LinkButton></a>
</li>
</ul>
<!-- /.dropdown-user -->
</li>
<!-- /.dropdown -->
</ul>
<!-- /.navbar-top-links -->
<div class="navbar-default
sidebar" role="navigation">
<div
class="sidebar-nav
navbar-collapse">
<ul
class="nav"
id="side-menu">
<li class="sidebar-search">
<div class="input-group
custom-search-form">
<span class="input-group-btn">
<i class="fa fa-search"></i>
</button>
</span>
</div>
<!-- /input-group -->
</li>
<li>
<a href="DashBoard.aspx"><i class="fa fa-dashboard fa-fw"></i> Dashboard</a>
</li>
<li>
<a href="UserEntry.aspx"><i class="fa fa-bar-chart-o fa-fw"></i> User Entry</a>
</li>
<li>
<a href="ManageUsers.aspx"><i class="fa fa-sitemap fa-fw"></i>Manage Users</a>
</li>
<li>
<a href="SubjectEntry.aspx"><i class="fa fa-bar-chart-o fa-fw"></i> Subject Entry</a>
</li>
<li>
<a href="QuestionsEntry.aspx"><i class="fa fa-sitemap fa-fw"></i>Questions
Entry</a>
</li>
<li>
<a href="ViewQuestion.aspx"><i class="fa fa-sitemap fa-fw"></i>View Questions
</a>
</li>
<li>
<a href="ViewResults.aspx"><i class="fa fa-sitemap fa-fw"></i>View Results</a>
</li>
<li>
<a href="ExamEntry.aspx"><i class="fa fa-sitemap fa-fw"></i>Exam Entry</a>
</li>
<li>
<a href="ChangePassword.aspx"><i class="fa fa-files-o fa-fw"></i>ChangePassword</a>
</li>
<li>
<asp:LinkButton ID="LinkButton2"
runat="server"
onclick="LinkButton1_Click1">
Logout</asp:LinkButton>
</li>
</ul>
</div>
<!-- /.sidebar-collapse -->
</div>
<!-- /.navbar-static-side -->
</nav>
<!-- Page Content -->
<div id="page-wrapper">
<div class="container-fluid">
<div
class="row">
<div
class="col-lg-12">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<asp:ContentPlaceHolder
ID="ContentPlaceHolder1"
runat="server">
</asp:ContentPlaceHolder>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
</div>
<!-- /.container-fluid -->
</div>
<!-- /#page-wrapper -->
</div>
<!-- /#wrapper -->
<!-- jQuery -->
</div>
</form>
</body>
</html>
===========================================================================================
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace OnlineExam
{
public partial class AdminMaster
: System.Web.UI.MasterPage
{
protected void
Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
if (Session.Count == 0)
{
Response.Redirect("Login.aspx");
}
}
}
catch (Exception
ex)
{
}
}
protected void
LinkButton1_Click1(object sender, EventArgs e)
{
Session.Clear();
Session.Abandon();
Session.RemoveAll();
Response.Redirect("Login.aspx");
}
}
}
=============================================================================================
Login.aspx page code
<%@ Page
Language="C#"
AutoEventWireup="true"
CodeBehind="Login.aspx.cs"
Inherits="OnlineExam.Login"
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD
XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en"><head><meta http-equiv="Content-Type"
content="text/html;
charset=UTF-8">
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible"
content="IE=edge">
<meta name="viewport"
content="width=device-width,
initial-scale=1">
<meta name="description"
content="">
<meta name="author"
content="">
<link rel="icon" href="http://getbootstrap.com/favicon.ico">
<title>:: Admin Panel - Online Examination System ::</title>
<!-- Bootstrap core CSS -->
<link href="http://getbootstrap.com/dist/css/bootstrap.min.css"
rel="stylesheet">
<!-- Custom styles for this template -->
<link href="http://getbootstrap.com/examples/signin/signin.css"
rel="stylesheet">
<script src="login_files/ie-emulation-modes-warning.js"
type="text/javascript"></script>
<script src="login_files/ie10-viewport-bug-workaround.js"
type="text/javascript"></script>
<script src="login_files/1500765803.js"
type="text/javascript"></script>
</head>
<body>
<div class="container">
<form id="Form1" class="form-signin"
role="form"
runat="server">
<h2 class="form-signin-heading">Please
sign in</h2>
<label for="inputEmail"
class="sr-only">Email
address</label>
<asp:TextBox ID="txtEmail"
runat="server"
class="form-control"
placeholder="Email
address" required="" autofocus=""></asp:TextBox>
<label for="inputPassword"
class="sr-only">Password</label>
<asp:TextBox ID="txtPassword"
class="form-control"
placeholder="Password"
required="" runat="server"
TextMode="Password"></asp:TextBox>
<div class="checkbox">
<label>
</label>
</div>
<asp:Button ID="BtnLogin"
class="btn btn-lg
btn-primary btn-block" runat="server"
Text="Sign in"
onclick="BtnLogin_Click"
/>
<br />
<asp:Label ID="lblmsg" runat="server"></asp:Label></form>
</div> <!-- /container
--></body></html>
===========================================================================================
Login.aspx.cs page code
using System;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Data;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Web.Configuration;
using System.Configuration;
using System.Threading;
using System.ComponentModel;
using System.Text;
using System.IO;
namespace OnlineExam
{
public partial class Login :
System.Web.UI.Page
{
General csGen = new
General();
SqlConnection cnn = new
SqlConnection();
SqlDataAdapter da;
SqlCommand cmd;
DataSet ds;
SqlDataReader dr;
protected void
Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session.Count != 0)
{
Session.Clear();
Session.Abandon();
Session.RemoveAll();
if (!Page.IsPostBack)
Session.Abandon();
}
}
}
protected void
BtnLogin_Click(object sender, EventArgs e)
{
try
{
String UserID = "",
Password = "";
UserID = txtEmail.Text;
Password = txtPassword.Text;
General clsGeneral = new
General();
DataSet ds = clsGeneral.ValidateLogin(UserID,
Password);
DataView dv = ds.Tables[0].DefaultView;
if (dv.Table.Rows.Count > 0)
{
Session["uid"] =
dv.Table.Rows[0]["STRUSERID"].ToString();
Response.Redirect("DashBoard.aspx");
}
else
{
lblmsg.Text = "Invalid
UserID/Password";
}
}
catch(Exception
ex)
{
WriteLog(ex.Message);
}
}
}
}
===========================================================================================
<%@ Page Title="" Language="C#" MasterPageFile="~/AdminMaster.Master" AutoEventWireup="true" CodeBehind="DashBoard.aspx.cs" Inherits="OnlineExam.DashBoard" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<div class="row">
<div class="col-lg-12">
<h1 class="page-header">Dashboard</h1>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
<div class="row">
<div class="col-lg-3 col-md-6">
</div>
<div class="col-lg-3 col-md-6">
</div>
<div class="col-lg-3 col-md-6">
</div>
</div>
<!-- /.row -->
<div class="row">
<div class="col-lg-3 col-md-6">
<div class="panel panel-primary">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-comments fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<div class="huge">26</div>
<div>New Comments!</div>
</div>
</div>
</div>
<a href="#">
<div class="panel-footer">
<span class="pull-left">View Details</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
<div class="col-lg-3 col-md-6">
<div class="panel panel-green">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-tasks fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<div class="huge">12</div>
<div>New Tasks!</div>
</div>
</div>
</div>
<a href="#">
<div class="panel-footer">
<span class="pull-left">View Details</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
<div class="col-lg-3 col-md-6">
<div class="panel panel-yellow">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-shopping-cart fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<div class="huge">124</div>
<div>New Orders!</div>
</div>
</div>
</div>
<a href="#">
<div class="panel-footer">
<span class="pull-left">View Details</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
<div class="col-lg-3 col-md-6">
<div class="panel panel-red">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-support fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<div class="huge">13</div>
<div>Support Tickets!</div>
</div>
</div>
</div>
<a href="#">
<div class="panel-footer">
<span class="pull-left">View Details</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
</div>
<div class="row">
<div class="col-lg-3 col-md-6">
<div class="panel panel-primary">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-comments fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<div class="huge">26</div>
<div>New Comments!</div>
</div>
</div>
</div>
<a href="#">
<div class="panel-footer">
<span class="pull-left">View Details</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
<div class="col-lg-3 col-md-6">
<div class="panel panel-green">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-tasks fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<div class="huge">12</div>
<div>New Tasks!</div>
</div>
</div>
</div>
<a href="#">
<div class="panel-footer">
<span class="pull-left">View Details</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
<div class="col-lg-3 col-md-6">
<div class="panel panel-yellow">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-shopping-cart fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<div class="huge">124</div>
<div>New Orders!</div>
</div>
</div>
</div>
<a href="#">
<div class="panel-footer">
<span class="pull-left">View Details</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
<div class="col-lg-3 col-md-6">
<div class="panel panel-red">
<div class="panel-heading">
<div class="row">
<div class="col-xs-3">
<i class="fa fa-support fa-5x"></i>
</div>
<div class="col-xs-9 text-right">
<div class="huge">13</div>
<div>Support Tickets!</div>
</div>
</div>
</div>
<a href="#">
<div class="panel-footer">
<span class="pull-left">View Details</span>
<span class="pull-right"><i class="fa fa-arrow-circle-right"></i></span>
<div class="clearfix"></div>
</div>
</a>
</div>
</div>
</div>
<!-- /.row -->
</asp:Content>
==========================================================================================
DashBoard.aspx.cs Page code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Threading;
using System.Globalization;
namespace OnlineExam
{
public partial class DashBoard :
System.Web.UI.Page
{
SqlConnection con = new
SqlConnection(ConfigurationManager.ConnectionStrings["ConOnlineExam"].ConnectionString);
General clsGeneral = new
General();
SqlDataAdapter adp, adp1;
SqlCommand cmd, cmd1, cmd2;
DataSet ds, ds1;
string query, query1, query2;
string url = "";
int ires; string
sres;
protected void
Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
if (Session["uid"]
== null)
{
Response.Redirect("Login.aspx");
}
else {
//
bind();
}
}
}
catch (Exception
ex)
{
}
}
}
}
<%@ Page
Title=""
Language="C#"
MasterPageFile="~/AdminMaster.Master"
AutoEventWireup="true"
CodeBehind="UserEntry.aspx.cs"
Inherits="OnlineExam.UserEntry"
%>
<%@ Register
assembly="AjaxControlToolkit"
namespace="AjaxControlToolkit"
tagprefix="cc1"
%>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<div class="row">
<div class="col-lg-12">
<h4>
Student Entry</h4>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
<div class="row" align="center">
<asp:Label ID="lblres" runat="server"
Font-Bold="True"
ForeColor="Red"
></asp:Label>
<br />
<table class="table
table-striped table-bordered table-hover"><%-- style="background-color: #ccccff"--%>
<tr>
<td colspan="2" align="left"
style=" font-family: Verdana;
font-size: 10pt; color:Orange; font-style: italic; font-weight: bolder">
Personal Details</td>
</tr>
<tr>
<td align="right"
>
<span style="color: Red">*</span>First Name:
</td>
<td align="left">
<asp:TextBox Width="240px"
ID="txtfname"
runat="server"
class="form-control"
CausesValidation="true"></asp:TextBox>
<asp:RequiredFieldValidator
ID="FirstNameValidator"
runat="server"
ControlToValidate="txtfname"
ErrorMessage="First
Name should not be empty" SetFocusOnError="True"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right"
>
Last Name:
</td>
<td align="left"
>
<asp:TextBox Width="240px"
ID="txtlname"
class="form-control"
runat="server"
CausesValidation="true"></asp:TextBox>
</td>
</tr>
<tr>
<td align="right">
Date Of Birth:
</td>
<td align="left"
>
<asp:TextBox ID="GMDatePicker1"
runat="server" Width="160px" ></asp:TextBox>
<cc1:CalendarExtender ID="abc" runat="server" Format="dd-MM-yyyy" TargetControlID="GMDatePicker1">
</cc1:CalendarExtender>
<asp:Label ID="lblFormat"
runat="server"
Text="mm/dd/yyyy"
Enabled="false"></asp:Label>
</td>
</tr>
<tr>
<td align="right"
>
<span style="color: Red">*</span>Gender:
</td>
<td align="left"
>
<asp:RadioButtonList ID="rdSex" runat="server"
RepeatDirection="Horizontal">
<asp:ListItem Text="Male" Value="Male">
</asp:ListItem>
<asp:ListItem Text="Female"
Value="Female">
</asp:ListItem>
</asp:RadioButtonList>
<asp:RequiredFieldValidator
ID="GenderValidator"
runat="server"
ErrorMessage="PLZ
Select the gender!!!"
ControlToValidate="rdSex"
Display="Dynamic"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right"
>
Contact No:
</td>
<td align="left"
>
<asp:TextBox Width="240px"
ID="txtcontact"
class="form-control"
MaxLength="20"
runat="server"></asp:TextBox>
<asp:CompareValidator ID="CompareValidator2" runat="server"
ErrorMessage="Must
enter numeric value"
Operator="DataTypeCheck"
Type="Integer"
ControlToValidate="txtcontact"></asp:CompareValidator>
</td>
</tr>
<tr>
<td align="right"
>
Alternate E-Mail ID:
</td>
<td align="left"
>
<asp:TextBox Width="240px"
ID="txtmail"
class="form-control"
runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td colspan="2" align="left"
style="font-family: Verdana;
font-size: 10pt; color: Orange; font-style: italic; font-weight: bolder">
Address Details
</td>
</tr>
<tr>
<td align="right"
>
<span style="color: Red">*</span>Address:
</td>
<td align="left">
<asp:TextBox Width="240px"
ID="txtaddr"
class="form-control"
runat="server"
TextMode="MultiLine">
</asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator1"
runat="server"
ErrorMessage="This
Field should not be blank"
ControlToValidate="txtaddr"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td align="right"
>
ZIP Code:
</td>
<td align="left"
>
<asp:TextBox Width="240px"
class="form-control"
ID="txtZipCode"
MaxLength="6"
runat="server"></asp:TextBox>
<asp:RegularExpressionValidator
ID="RegularExpressionValidator1"
runat="server"
ControlToValidate="txtZipCode"
ErrorMessage="Enter
Proper Zip Code" ValidationExpression="\d{6}">
</asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td align="right"
>
</td>
<td align="left"
>
<br /> <asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="btnSubmit_Click"
class="btn-primary
btn-xs" />
</td>
</tr>
<tr>
<td>
<small><span style="color: Red">*Note:</span>Must enter data</small>
</td>
</tr>
</table></div>
</asp:Content>
============================================================================================
UserEntry.aspx.cs Page code
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using OnlineExam.DAL;
using OnlineExam.BL;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace OnlineExam
{
public partial class UserEntry :
System.Web.UI.Page
{
SqlConnection con = new
SqlConnection(ConfigurationManager.ConnectionStrings["ConOnlineExam"].ConnectionString);
protected void
Page_Load(object sender, EventArgs e)
{
int i;
if (!IsPostBack)
{
if (Session["uid"]
== null)
{
Response.Redirect("Login.aspx");
}
}
}
private DateTime
convertDateIndia(string datetoconvert)
{
DateTime dtParam;
System.Globalization.CultureInfo enGB
= new System.Globalization.CultureInfo("en-GB");
try
{
dtParam = Convert.ToDateTime(datetoconvert.ToString(),
enGB);
return dtParam;
}
catch (Exception
ex)
{
throw ex;
}
finally
{
}
}
protected void
btnSubmit_Click(object sender, EventArgs e)
{
try
{
string
j;
SqlParameter[]
p = new SqlParameter[10];
p[0] = new SqlParameter("@fname", SqlDbType.NVarChar);
p[0].Value = txtfname.Text;
p[1] = new SqlParameter("@lname", SqlDbType.NVarChar);
p[1].Value = txtlname.Text;
p[2] = new SqlParameter("@dob", SqlDbType.DateTime);
p[2].Value = convertDateIndia(GMDatePicker1.Text);
p[3] = new SqlParameter("@ContactNo", SqlDbType.NVarChar);
p[3].Value = txtcontact.Text;
p[4] = new SqlParameter("@gender", SqlDbType.NVarChar);
p[4].Value = rdSex.SelectedValue;
p[5] = new SqlParameter("@emailId", SqlDbType.NVarChar);
p[5].Value = txtmail.Text;
p[6] = new SqlParameter("@Address", SqlDbType.NVarChar);
p[6].Value = txtaddr.Text;
p[7] = new SqlParameter("@ZipCode ", SqlDbType.VarChar);
p[7].Value = txtZipCode.Text;
p[8] = new SqlParameter("@password ", SqlDbType.VarChar);
p[8].Value = "Test";
p[9] = new SqlParameter("@OId", SqlDbType.Int);
p[9].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(ConnectionString.GetConnectionString(), CommandType.StoredProcedure, "spRegistration", p);
j= ((p[9].Value.ToString()));
SqlCommand cmd = new SqlCommand("select StId from tbluser where UserId = "
+ j + "", con);
// cmd.CommandType = CommandType.Text;
con.Open();
string k =
(cmd.ExecuteScalar()).ToString();
con.Close();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(),
"alertMessage", "alert('Student Registered Successfully and ID : " + k + "')", true);
clear();
lblres.Text = "Student Registered
Successfully and ID : '" + k
+ "'";
}
catch (Exception
ex)
{
}
}
protected void
clear()
{
Resetfromcontrol(this);
}
public void
Resetfromcontrol(Control parent)
{
foreach (Control c
in parent.Controls)
{
if (c.Controls.Count > 0)
{
Resetfromcontrol(c);
}
else
{
switch (c.GetType().ToString())
{
case "System.Web.UI.WebControls.TextBox":
((TextBox)c).Text = "";
break;
}
}
}
}
protected void
txtuser_TextChanged(object sender, EventArgs e)
{
}
}
}
======================================================================
Admin can manage users
<%@ Page
Title=""
Language="C#"
MasterPageFile="~/AdminMaster.Master"
AutoEventWireup="true"
CodeBehind="ManageUsers.aspx.cs"
Inherits="OnlineExam.ManageUsers"
%>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<div class="row">
<div class="col-lg-12">
<h4> Manage Users </h4>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
<div class="row">
<table border="0" cellpadding="0"
cellspacing="0"
class="table
table-striped table-bordered table-hover"
align="center"
style="width: 1189px; height: 795px;">
<tr>
<td>
<div
class="box-body">
<table class="table table-bordered">
<asp:GridView ID="grdProperties"
runat="server"
AutoGenerateColumns="False"
ShowFooter="true"
CellPadding="4"
CssClass="table
table-hover table-bordered" GridLines="None"
Width="101%"
Style="margin-right: 20px"
>
<RowStyle BackColor="#F5F5F5"
/>
<AlternatingRowStyle
BackColor="#FFFFFF"
/>
<Columns>
<asp:TemplateField HeaderText="ID"
FooterText="ID"
FooterStyle-Font-Bold="true">
<ItemTemplate>
<asp:Label ID="lblctgry"
runat="server"
Text='<%# Eval("StId") %>'></asp:Label>
</ItemTemplate>
<FooterTemplate>
ID
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Name"
FooterText="Name"
FooterStyle-Font-Bold="true">
<ItemTemplate>
<asp:Label ID="lblqst" runat="server"
Text='<%# Eval("name") %>'></asp:Label>
</ItemTemplate>
<FooterTemplate>
Name
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Phone"
>
<ItemTemplate>
<asp:Label ID="lblfid" runat="server"
Text='<%# Eval("ContactNo") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Email"
>
<ItemTemplate>
<asp:Label ID="lblfid" runat="server" Text='<%# Eval("EmailID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Active\InActive"
>
<ItemTemplate>
<asp:RadioButton ID="RadioButton1"
runat="server"
/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<EmptyDataTemplate>
<b>No records found</b>
</EmptyDataTemplate>
</asp:GridView>
</table>
</div><!-- /.box-body
-->
<div
class="box-footer
clearfix">
<div
style="float:right;">
<table
cellpadding="0"
border="0">
<tr><td>
<asp:Label ID="lblPageInfo"
runat="server"
style="font-weight: 700"
Visible="false"></asp:Label>
</td><td> </td>
<td align="right">
<asp:LinkButton ID="lbtnFirst"
runat="server"
CausesValidation="false"
OnClick="lbtnFirst_Click"
CssClass="paging"
Visible="false">First</asp:LinkButton>
</td>
<td align="right">
<asp:LinkButton ID="lbtnPrevious"
CssClass="paging"
runat="server"
CausesValidation="false"
OnClick="lbtnPrevious_Click"><<</asp:LinkButton> </td>
<td >
<asp:DataList ID="dlPaging"
runat="server"
RepeatDirection="Horizontal"
OnItemCommand="dlPaging_ItemCommand"
OnItemDataBound="dlPaging_ItemDataBound">
<ItemTemplate>
<asp:LinkButton ID="lnkbtnPaging" runat="server" CommandArgument='<%# Eval("PageIndex") %>'
CommandName="Paging"
Text='<%# Eval("PageText") %>'></asp:LinkButton>
</ItemTemplate>
<SeparatorTemplate> | </SeparatorTemplate>
</asp:DataList>
</td>
<td align="left">
<asp:LinkButton CssClass="paging" ID="lbtnNext" runat="server" CausesValidation="false"
OnClick="lbtnNext_Click">>></asp:LinkButton></td>
<td align="left">
<asp:LinkButton ID="lbtnLast"
runat="server"
Visible="false"
CausesValidation="false"
OnClick="lbtnLast_Click"
CssClass="paging">Last</asp:LinkButton></td>
<td style="padding-left:5px;"> </td>
</tr>
<tr>
<td colspan="7" align="center"
style="display:none;" valign="middle">
</td>
</tr>
</table></div>
</div>
</td>
</tr></table>
</div>
</asp:Content>
==========================================================================================
ManageUsers.aspx.cs Code
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Threading;
using System.Globalization;
namespace OnlineExam
{
public partial class ManageUsers
: System.Web.UI.Page
{
#region
Declaration
General clsGeneral = new
General();
comFunctions fssFunctions = new comFunctions();
SqlDataAdapter adp;
DataSet ds, dsHelp;
string strLogUser;
int Result;
#endregion
SqlConnection cn = new
SqlConnection(ConfigurationManager.ConnectionStrings["ConOnlineExam"].ToString());
#region
Private Properties
private int
CurrentPage
{
get
{
object objPage = ViewState["_CurrentPage"];
int _CurrentPage = 0;
if (objPage == null)
{
_CurrentPage = 0;
}
else
{
_CurrentPage = (int)objPage;
}
return _CurrentPage;
}
set { ViewState["_CurrentPage"]
= value; }
}
private int fistIndex
{
get
{
int _FirstIndex = 0;
if (ViewState["_FirstIndex"]
== null)
{
_FirstIndex = 0;
}
else
{
_FirstIndex = Convert.ToInt32(ViewState["_FirstIndex"]);
}
return _FirstIndex;
}
set { ViewState["_FirstIndex"]
= value; }
}
private int lastIndex
{
get
{
int _LastIndex = 0;
if (ViewState["_LastIndex"]
== null)
{
_LastIndex = 0;
}
else
{
_LastIndex = Convert.ToInt32(ViewState["_LastIndex"]);
}
return _LastIndex;
}
set { ViewState["_LastIndex"]
= value; }
}
#endregion
#region
PagedDataSource
PagedDataSource _PageDataSource = new PagedDataSource();
#endregion
string lang = "";
protected void
Page_Load(object sender, EventArgs e)
{
if (Session["uid"]
== null)
{
ClientScriptManager csm =
Page.ClientScript;
csm.RegisterStartupScript(this.GetType(),
"redirectlogin", "<script
type='text/javascript' language='javascript'>parent.top.location.href='Login.aspx';
</script>");
return;
}
try
{
string ConStr = ConfigurationManager.ConnectionStrings["ConOnlineExam"].ConnectionString;
cn = new
SqlConnection(ConStr);
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
Page.MaintainScrollPositionOnPostBack = true;
if (Page.IsPostBack == false)
{
BindQuestions();
}
}
catch (Exception
ex)
{
WriteLog(ex.Message);
throw ex;
}
}
private bool
WriteLog(string strError)
{
string AppPath = AppDomain.CurrentDomain.BaseDirectory;
string strLog = @"LOG1\";
string strFilePath = AppPath + strLog;
if (!(Directory.Exists(strFilePath)))
{
Directory.CreateDirectory(strFilePath);
}
string fn = string.Format("{0}{1}.txt", strFilePath, DateTime.Now.ToString("ddMMyyyy"));
FileStream fs = new
FileStream(fn, FileMode.Append,
FileAccess.Write, FileShare.ReadWrite);
StreamWriter writer = new
StreamWriter(fs);
writer.Write("[ " + DateTime.Now.Hour.ToString() + ":" + DateTime.Now.Minute.ToString()
+ ":" + DateTime.Now.Second.ToString()
+ " ]");
writer.WriteLine(strError);
writer.WriteLine("--------------------------------------------------------------------------");
writer.Close();
fs.Close();
return true;
}
protected string
Gethtml(string sttdesc)
{
return Server.HtmlDecode(sttdesc);
}
public void
BindQuestions()
{
try
{
adp = new SqlDataAdapter("SELECT
[UserId] ,[StId],[FName] + [LName] as name ,[ContactNo],[EmailID] FROM
[OnlineExam].[dbo].[tblUser]", cn);
ds = new DataSet();
adp.Fill(ds);
DataSet BindBatch = ds;
if (BindBatch.Tables[0].Rows.Count >
0)
{
DataTable dataTable =
BindBatch.Tables[0];
_PageDataSource.DataSource = dataTable.DefaultView;
_PageDataSource.AllowPaging = true;
_PageDataSource.PageSize = 20;
_PageDataSource.CurrentPageIndex = CurrentPage;
ViewState["TotalPages"] =
_PageDataSource.PageCount;
//this.lblPageInfo.Text = "Page " +
(CurrentPage + 1) + " of " + _PageDataSource.PageCount;
this.lbtnPrevious.Enabled =
!_PageDataSource.IsFirstPage;
this.lbtnNext.Enabled =
!_PageDataSource.IsLastPage;
this.grdProperties.DataSource
= _PageDataSource;
this.grdProperties.DataBind();
grdProperties.Columns[1].ItemStyle.Width = 180;
grdProperties.Columns[3].ItemStyle.Width = 90;
grdProperties.Columns[4].ItemStyle.Width = 90;
grdProperties.Columns[5].ItemStyle.Width = 90;
this.doPaging();
}
else
{
grdProperties.DataSource = null;
grdProperties.DataBind();
}
}
catch (Exception
ex)
{
}
}
private void
doPaging()
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add("PageIndex");
dt.Columns.Add("PageText");
fistIndex = CurrentPage - 5;
if (CurrentPage > 5)
{
lastIndex = CurrentPage + 5;
}
else
{
lastIndex = 10;
}
if (lastIndex > Convert.ToInt32(ViewState["TotalPages"]))
{
lastIndex = Convert.ToInt32(ViewState["TotalPages"]);
fistIndex = lastIndex - 10;
}
if (fistIndex < 0)
{
fistIndex = 0;
}
for
(int i = fistIndex; i < lastIndex; i++)
{
DataRow dr = dt.NewRow();
dr[0] = i;
dr[1] = i + 1;
dt.Rows.Add(dr);
}
this.dlPaging.DataSource = dt;
this.dlPaging.DataBind();
}
catch (Exception
ex)
{
WriteLog("ViewProperty.aspx--doPaging()--"
+ Session["UserLog"].ToString() + "--" + ex.Message);
throw ex;
}
}
protected void
lbtnFirst_Click(object sender, EventArgs e)
{
CurrentPage = 0;
this.BindQuestions();
}
protected void
lbtnPrevious_Click(object sender, EventArgs e)
{
CurrentPage -= 1;
this.BindQuestions();
}
protected void
lbtnNext_Click(object sender, EventArgs e)
{
CurrentPage += 1;
this.BindQuestions();
}
protected void
lbtnLast_Click(object sender, EventArgs e)
{
CurrentPage = (Convert.ToInt32(ViewState["TotalPages"]) - 1);
this.BindQuestions();
}
protected void
dlPaging_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName.Equals("Paging"))
{
CurrentPage = Convert.ToInt16(e.CommandArgument.ToString());
this.BindQuestions();
}
}
protected void
dlPaging_ItemDataBound(object sender, DataListItemEventArgs e)
{
try
{
if (e.Item.ItemType != ListItemType.Separator)
{
LinkButton lnkbtnPage = (LinkButton)e.Item.FindControl("lnkbtnPaging");
if
(lnkbtnPage.CommandArgument.ToString() == CurrentPage.ToString())
{
lnkbtnPage.Enabled = false;
lnkbtnPage.Style.Add("fone-size", "14px");
lnkbtnPage.Font.Bold = true;
}
}
}
catch (Exception
ex)
{
WriteLog("ViewProperty.aspx--dlPaging_ItemDataBound()--"
+ Session["UserLog"].ToString() + "--" + ex.Message);
throw ex;
}
}
protected void
ddlshow_SelectedIndexChanged(object sender, EventArgs e)
{
BindQuestions();
}
protected void
ddlSubCat_SelectedIndexChanged(object sender, EventArgs e)
{
}
}
}
Subject Create\Read\update\Delete
<%@ Page
Title=""
Language="C#"
MasterPageFile="~/AdminMaster.Master"
AutoEventWireup="true"
CodeBehind="SubjectEntry.aspx.cs"
Inherits="OnlineExam.SubjectEntry"
%>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<script language="javascript"
type="text/javascript">
function validate() {
if (document.getElementById("<%=txtSub.ClientID%>").value
== "") {
alert("Sublect can not be blank");
document.getElementById("<%=txtSub.ClientID%>").focus();
return false;
}
}
}
</script>
<div class="row">
<div class="col-lg-12">
<h4> Subject
Entry </h4>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
<div class="row">
<table border="0" cellpadding="0"
cellspacing="0"
class="table
table-striped table-bordered table-hover"
align="center"
style="width: 1189px; height: 795px;">
<tr>
<td
valign="top"
align="center"
style="width: 366px">
<table>
<tr><td>
<table style="width: 97%; height: 118px;" cellpadding="0"
cellspacing="0">
<tr>
<td
align="center"
style="padding: 5px; vertical-align: top; text-align: left"
colspan="3">
<label> Subject
Entry </label>
</td>
</tr>
<tr
>
<td
align="right"
style="padding: 5px; vertical-align: top; width: 10%; text-align: left">
<asp:Label ID="Label5" runat="server"
CssClass="LBLBLACK"
Text="Subject
Name"
Width="150px"></asp:Label>
</td>
<td
align="right"
style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 3%; padding-top: 5px; text-align: left">
<asp:Label ID="Label8" runat="server"
CssClass="LBLBLACK"
Text=":"></asp:Label>
</td>
<td
align="left"
style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:TextBox ID="txtSub" runat="server"
class="form-control"
placeholder="Enter
Subject" MaxLength="50" TabIndex="1"
Width="166px"
ValidationGroup="co"
></asp:TextBox>
</td>
</tr>
<tr>
<td align="right"
style="padding: 5px; vertical-align: top; width: 10%; text-align: left">
<asp:Label ID="lblvid" runat="server"></asp:Label>
</td>
<td align="right"
style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 3%; padding-top: 5px; text-align: left">
</td>
<td
align="left"
style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:Button ID="btnCatSave"
runat="server"
class="btn-primary
btn-xs" TabIndex="10"
Text="Save"
ToolTip="To
Save the data" ValidationGroup="co"
OnClientClick="return
validate();" onclick="btnCatSave_Click"
/>
<asp:Button ID="btnCatClear"
runat="server"
CausesValidation="False"
class="btn-primary
btn-xs" TabIndex="10"
Text="Clear"
ToolTip="To
Clear the Screen" onclick="btnCatClear_Click"
/>
<br
/>
</td>
</tr>
<tr>
<td
align="right"
style="padding: 5px; vertical-align: top; width: 10%; text-align: left">
</td>
<td align="right"
style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 3%; padding-top: 5px; text-align: left">
</td>
<td
align="left"
style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
</td>
</tr>
</table></td></tr>
<tr><td>
</td></tr>
</table>
</td>
<td valign="top" align="center" style="width: 533px">
<table
style="width: 490px; height: 301px">
<tr>
<td
valign="top"
align="left"
style="height: 127px"> Subject - Edit/Delete <br />
<%--<div id="div2" style="height:323px;
Main menu - Edit/Delete --%><br />
<div id="div2" style="height:397px; overflow:auto; width: 491px;" align="center">
<table><tr><td>
<asp:GridView ID="grdMain"
runat="server"
CellPadding="4"
CssClass="table
table-hover table-bordered"
GridLines="None"
PageSize="20"
AutoGenerateColumns="False"
onrowcommand="grdMain_RowCommand"
Width="347px"
AutoGenerateSelectButton="True"
onselectedindexchanging="grdMain_SelectedIndexChanging">
<Columns>
<asp:BoundField HeaderText="ID"
DataField="sid" />
<asp:BoundField HeaderText="Subject"
DataField="sname"
SortExpression="sname"
/>
<asp:TemplateField HeaderText="Delete"
ShowHeader="true">
<ItemTemplate>
<asp:Button ID="btndelete"
runat="server"
class="btn-primary
btn-xs"
CommandName="Del"
CommandArgument='<%# Eval("sid") %>' Height="24px"
TabIndex="10"
Text="Delete"
OnClientClick="return
confirm('Are you sure you want to delete?');" ToolTip="To delete the
data" ValidationGroup="co" Width="46px" />
</ItemTemplate>
<ItemStyle
HorizontalAlign="Center"
/>
</asp:TemplateField>
</Columns>
<PagerStyle HorizontalAlign="Center"
BackColor="#B9D684"
ForeColor="White"></PagerStyle>
<EmptyDataTemplate>
<b>No records found</b>
</EmptyDataTemplate>
</asp:GridView></td><td valign="bottom">
</td></tr></table>
</div></td>
</tr>
</div></td></tr>
</table>
</td>
</tr>
</table>
</div>
</asp:Content>
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.IO;
namespace OnlineExam
{
public partial class SubjectEntry
: System.Web.UI.Page
{
SqlConnection con = new
SqlConnection(ConfigurationManager.ConnectionStrings["ConOnlineExam"].ConnectionString);
General clsGeneral = new
General();
SqlDataAdapter adp, adp1;
SqlCommand cmd, cmd1, cmd2;
DataSet ds, ds1;
string query, query1, query2;
string url = "";
int ires; string
sres;
private void
WriteLog(string strError)
{
try
{
string AppPath = AppDomain.CurrentDomain.BaseDirectory;
string strLog = @"LOG1\";
string strFilePath = AppPath + strLog;
if (!(Directory.Exists(strFilePath)))
{
Directory.CreateDirectory(strFilePath);
}
string fn = string.Format("{0}{1}.txt", strFilePath, DateTime.Now.ToString("ddMMyyyy"));
FileStream fs = new FileStream(fn,
FileMode.Append, FileAccess.Write,
FileShare.ReadWrite);
StreamWriter writer = new StreamWriter(fs);
writer.WriteLine(string.Format("[ {0} ] {1}", DateTime.Now.ToString("HH:mm:ss"), strError));
writer.Close();
fs.Close();
}
finally
{
//nothing
}
}
protected void
Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session.Count == 0)
{
Response.Redirect("Login.aspx");
}
else
{
btnCatSave.Text = "Save";
lblvid.Visible = true;
lblvid.Text = "";
BindSubjects();
}
}
}
public void
BindSubjects()
{
try
{
adp = new SqlDataAdapter("select sid,sname
from Subjects order by sname", con);
ds = new DataSet();
adp.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
grdMain.DataSource = ds;
grdMain.DataBind();
}
}
catch (Exception
ex)
{
WriteLog(ex.Message);
}
}
protected void
btnCatSave_Click(object sender, EventArgs e)
{
try
{
if (btnCatSave.Text == "Save")
{
if (txtSub.Text != "")
{
query = "select sname from Subjects where sname = '"
+ txtSub.Text + "'";
cmd = new SqlCommand(query,
con);
con.Open();
var getValue = cmd.ExecuteScalar();
if (getValue == null)
{
query2 = "Insert into Subjects(sname, Created_by, Created_dt)
values ('" + txtSub.Text + "',
'" + Session["uid"].ToString()
+ "', getdate() )";
cmd2 = new SqlCommand(query2,
con);
cmd2.ExecuteNonQuery();
con.Close();
txtSub.Text
= "";
BindSubjects();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(),
"alertMessage", "alert('Subject added succesfully')", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(),
"alertMessage", "alert('Subject alredy Existed')", true);
}
}
}
if (btnCatSave.Text == "Update")
{
if (txtSub.Text != ""
)
{
con.Open();
query2 = "update Subjects set
sname ='" + txtSub.Text + "' where sid= '" + Convert.ToInt32(lblvid.Text) + "' ";
cmd2 = new SqlCommand(query2,
con);
cmd2.ExecuteNonQuery();
con.Close();
txtSub.Text = "";
lblvid.Text = "";
btnCatSave.Text = "Save";
BindSubjects();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(),
"alertMessage", "alert('Subject Updated added succesfully')",
true);
}
}
}
catch (Exception
ex)
{
WriteLog(ex.Message);
}
}
protected void
btnCatClear_Click(object sender, EventArgs e)
{
txtSub.Text = "";
btnCatSave.Text = "Save";
}
protected void
grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "Del")
{
int ID = Convert.ToInt32(e.CommandArgument);
cmd = new
SqlCommand("delete
from Subjects where sid='" + ID + "'",
con);
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
BindSubjects();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(),
"alertMessage", "alert('Subject item deleted')", true);
}
}
catch (Exception
ex)
{
WriteLog(ex.Message);
}
}
protected void
grdMain_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
try
{
adp = new SqlDataAdapter("select sid, sname from Subjects where sid= '"
+ grdMain.Rows[e.NewSelectedIndex].Cells[1].Text + "'",
con);
ds = new DataSet();
adp.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
txtSub.Text =
ds.Tables[0].Rows[0]["sname"].ToString();
lblvid.Visible = false;
lblvid.Text = grdMain.Rows[e.NewSelectedIndex].Cells[1].Text.ToString();
btnCatSave.Text = "Update";
}
}
catch (Exception
ex)
{
WriteLog(ex.Message);
}
}
}
}
QuestionsEntry.aspx page code
<%@ Page Title="" Language="C#" MasterPageFile="~/AdminMaster.Master" AutoEventWireup="true"
CodeBehind="QuestionsEntry.aspx.cs" Inherits="OnlineExam.QuestionsEntry" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<script type="text/javascript" src="tinymce/jscripts/tiny_mce/tiny_mce.js"></script>
<script type="text/javascript">
tinyMCE.init({
mode: "textareas",
theme: "advanced",
plugins: "safari,spellchecker,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template,imagemanager,filemanager",
theme_advanced_buttons1: "save,newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,|,styleselect,formatselect,fontselect,fontsizeselect",
theme_advanced_buttons2: "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,insertdate,inserttime,preview,|,forecolor,backcolor",
theme_advanced_buttons3: "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,print,|,ltr,rtl,|,fullscreen",
theme_advanced_buttons4: "insertlayer,moveforward,movebackward,absolute,|,styleprops,spellchecker,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,blockquote,pagebreak,|,insertfile,insertimage",
theme_advanced_toolbar_location: "top",
theme_advanced_toolbar_align: "left",
theme_advanced_statusbar_location: "bottom",
theme_advanced_resizing: false,
template_external_list_url: "js/template_list.js",
external_link_list_url: "js/link_list.js",
external_image_list_url: "js/image_list.js",
media_external_list_url: "js/media_list.js",
height: 500
});
</script>
<script language="javascript" type="text/javascript">
function validate() {
if (document.getElementById("<%=ddlSub.ClientID%>").selectedIndex == 0) {
alert("Please select Subject");
document.getElementById("<%=ddlSub.ClientID%>").selectedIndex == 0;
return false;
}
if (document.getElementById("<%=txtOption1.ClientID%>").value == "") {
alert("Option 1 can not be blank");
document.getElementById("<%=txtOption1.ClientID%>").focus();
return false;
}
if (document.getElementById("<%=txtOption2.ClientID%>").value == "") {
alert("Option 2 can not be blank");
document.getElementById("<%=txtOption2.ClientID%>").focus();
return false;
}
if (document.getElementById("<%=txtOption3.ClientID%>").value == "") {
alert("Option 3 can not be blank");
document.getElementById("<%=txtOption3.ClientID%>").focus();
return false;
}
if (document.getElementById("<%=txtOption4.ClientID%>").value == "") {
alert("Option 4 can not be blank");
document.getElementById("<%=txtOption4.ClientID%>").focus();
return false;
}
if (document.getElementById("<%=rbtAns.ClientID%>").Checked == false) {
alert("Correct Answer can not be blank");
return false;
}
}
</script>
<div class="row">
<div class="col-lg-12">
<h4>
Question Entry</h4>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
<div class="row">
<table border="0" cellpadding="0" cellspacing="0" class="table table-striped table-bordered table-hover"
style="width: 100%">
<tr>
<td style="padding-top: 10px; padding-bottom: 20px; padding-left: 9px; height: 675px;"
valign="top" align="center">
<table id="table83" border="0" cellpadding="0" cellspacing="0" class="" width="600"
style="text-align: center; width: 71%;">
<tr style="vertical-align: top">
<td colspan="3" style="padding-right: 10px; padding-left: 10px; padding-top: 2px;
height: 374px;">
<table style="width: 95%" cellpadding="0" cellspacing="0">
<tr>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; padding-top: 5px; text-align: left" valign="top">
<table style="width: 104%" cellpadding="0" cellspacing="0">
<tr>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
</td>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 3%; padding-top: 5px; text-align: left">
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:Label ID="lblresult" runat="server" Font-Bold="True" Font-Names="Verdana" Font-Size="11px"
ForeColor="Green" Style="position: static"></asp:Label>
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
</td>
</tr>
<tr>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
Only for Excel Upload</td>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 3%; padding-top: 5px; text-align: left">
:</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:FileUpload ID="FileUpload2" runat="server" /> <asp:Button ID="Button1"
Text="Upload" runat="server" onclick="Button1_Click" />
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
</td>
</tr>
<tr>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:Label ID="lblcontactnumber2" runat="server" CssClass="LBLBLACK" Text="Select Subject"
Width="140px"></asp:Label>
</td>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 3%; padding-top: 5px; text-align: left">
<asp:Label ID="Label62" runat="server" CssClass="LBLBLACK" Text=":"></asp:Label>
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:DropDownList ID="ddlSub" class="form-control" runat="server" Height="29px" Width="160px"
>
</asp:DropDownList>
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
</td>
</tr>
<tr>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:Label ID="lblQuestion" runat="server" CssClass="LBLBLACK" Text="Question" Width="78px"></asp:Label>
</td>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 3%; padding-top: 5px; text-align: left">
<asp:Label ID="Label61" runat="server" CssClass="LBLBLACK" Text=":"></asp:Label>
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<div>
<asp:Panel ID="pnlEditor" runat="server">
<asp:TextBox ID="txtQuestion" runat="server" TextMode="MultiLine" MaxLength="100000"></asp:TextBox><br />
<asp:FileUpload ID="FileUpload1" runat="server" />
<asp:Button ID="btnUpload" runat="server" Text="Upload" OnClick="btnUpload_Click" />
</asp:Panel>
<asp:Button ID="btnSave" runat="server" Text="Save" OnClick="btnSave_Click" Visible="False" />
<asp:Button ID="btnCancel" runat="server" Text="Cancel" Visible="false" OnClick="btnCancel_Click" />
<asp:Label ID="lblDisplay" runat="server" Text="" Visible="false"></asp:Label>
</div>
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
</td>
</tr>
<tr>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:Label ID="lblAns1" runat="server" CssClass="LBLBLACK" Text="Option 1" Width="150px"></asp:Label>
</td>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 3%; padding-top: 5px; text-align: left">
:
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:TextBox ID="txtOption1" runat="server" class="form-control" placeholder="Enter Option1"
MaxLength="7000" TabIndex="1" Width="593px"></asp:TextBox>
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
</td>
</tr>
<tr>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:Label ID="lblAns2" runat="server" CssClass="LBLBLACK" Text="Option 2" Width="150px"></asp:Label>
</td>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 3%; padding-top: 5px; text-align: left">
:
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:TextBox ID="txtOption2" runat="server" class="form-control" placeholder="Enter Option2"
MaxLength="7000" TabIndex="1" Width="593px"></asp:TextBox>
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
</td>
</tr>
<tr>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:Label ID="lblAns3" runat="server" CssClass="LBLBLACK" Text="Option 3" Width="150px"></asp:Label>
</td>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 3%; padding-top: 5px; text-align: left">
:
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:TextBox ID="txtOption3" runat="server" class="form-control" placeholder="Enter Option3"
MaxLength="7000" TabIndex="1" Width="593px"></asp:TextBox>
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
</td>
</tr>
<tr>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:Label ID="lblAns4" runat="server" CssClass="LBLBLACK" Text="Option 4" Width="150px"></asp:Label>
</td>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 3%; padding-top: 5px; text-align: left">
:
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:TextBox ID="txtOption4" runat="server" class="form-control" placeholder="Enter Option4"
MaxLength="7000" TabIndex="1" Width="593px"></asp:TextBox>
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
</td>
</tr>
<tr>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:Label ID="lblCans" runat="server" CssClass="LBLBLACK" Text="Correct Answer"
Width="150px"></asp:Label>
</td>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 3%; padding-top: 5px; text-align: left">
:
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:RadioButtonList ID="rbtAns" runat="server" Height="16px"
RepeatDirection="Horizontal" Width="439px">
<asp:ListItem Value="1">Option1</asp:ListItem>
<asp:ListItem Value="2">Option2</asp:ListItem>
<asp:ListItem Value="3">Option3</asp:ListItem>
<asp:ListItem Value="4">Option4</asp:ListItem>
</asp:RadioButtonList>
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
</td>
</tr>
<tr>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
<asp:HiddenField ID="hdfupload3" runat="server" />
</td>
<td align="right" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 3%; padding-top: 5px; text-align: left">
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
</td>
<td align="left" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: top; width: 22%; padding-top: 5px; text-align: left">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center" style="padding-right: 5px; padding-left: 5px; padding-bottom: 5px;
vertical-align: middle; padding-top: 5px; height: 35px; text-align: center" valign="middle">
<asp:Button ID="BtnBatchsave" runat="server" class="btn-primary btn-xs" TabIndex="10"
CausesValidation="true" OnClientClick="return validate();" Text="Submit" ToolTip="To Save the data"
OnClick="BtnBatchsave_Click" />
<asp:Button ID="BtnbatchClear" runat="server" class="btn-primary btn-xs" CausesValidation="false"
TabIndex="10" Text="ClearAll" ToolTip="To Clear the Screen" OnClick="BtnbatchClear_Click" />
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</asp:Content>
==========================================================================================
Click here for Online examination system project In Asp.Net with c#, SQL Database including Admin Panel - Download Part 2
==========================================================================================
Click here for Online examination system project In Asp.Net with c#, SQL Database including Admin Panel - Download Part 2






where is the mainpage.master plssss
ReplyDeleteGood one.......
ReplyDeletePlz send all files of this project as a zip file...
Rahulmhatre300@gmail.com
Could u plz send all pjt files to dotnetmaheshbabu@gmail.com
ReplyDeleteWill u please send me mail of this project of online exam.. it will be very helpful for my career growth..
ReplyDeletemy email id: azhardevna@gmail.com
its very good.
ReplyDeletesend me full project, please. thanks.
live.mlm@gmail.com
Nice work!!
ReplyDeleteplease sir can you send me the full file of this project to emmanuel2015fut@gmail.com
thanks
Nice work!!
ReplyDeleteplease can you send me full file of this project at emmanuel2015fut@gmail.com
Thanks
pls send User Home,Update profile,Change Password,Start Exam,Previous Exams
ReplyDeleteDownloads to satish07.1985@gmail.com
please send me full project this mail- gsmshah@hotmail.com
ReplyDeletesir plz iska admin login kya ..jisse ki hm dashboard ja sake...qyestion entry kar sake.....mca ke final year project me submit karna ha................mere mail account ..deepubaba991mth@gmail.com pe admin k user id or password bheje sir
ReplyDeletesir kindly send full project @ jahangeerrathore@gmail.com
ReplyDeleteGood one.......
ReplyDeletePlz send all files of this project as a zip file...
please send me a complete project @- bishnumcsa@gmail.com
kindly send me all the project can you
ReplyDeleteplease send me full project this mail nuribaba27@gmail.com
ReplyDeleteplease send me full project this mail- mazharkayaoglu@gmail.com
ReplyDeleteplease send me full project this mail- htsunemikuv9@gmail.com
ReplyDeleteplz send me the code princemujeeb12@gmail.com
ReplyDeleteplease send me full project this mail- csmkrsnbs@gmail.com
ReplyDeleteplease send me the full project to this mail id:- saisurya.prashanth@gmail.com
ReplyDeleteNice
ReplyDeleteCan you please send the project as whole to my email shrikanthbasa35@gmail.com
ReplyDeletePlease send the project as whole to my email mgbaig@gmail.com
ReplyDeleteNice work
ReplyDeleteplease can you send me full file of this project at taher_vip22@hotmail.com
Thanks
Send full file to : udrescudaniel95@yahoo.com
ReplyDeleteplease send me this project on my email address:- rjkanaramyadav@gmail.com
ReplyDeleteCan you send me the complete source code on h.altamas74@gmail.com
ReplyDeleteCan you please send the project as whole to my email belkas@gmail.com
ReplyDeleteI like it your blog. Thanks for sharing
ReplyDelete.Net Online Course
This post will help the internet visitors for setting up new
ReplyDeletewebpage or even a weblog from start to end.
did he send send the project for any one
ReplyDeleteplease send me the project to : mohammad.shatat@outlook.com