NEXT Declare Schdule

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class ExamDept_ DeclareSchdule: System.Web.UI.Page

{

DBMgt objDBMgt = new DBMgt();

static int StuId;

static int CouId;

protected void Page_Load(object sender, EventArgs e)

{

StuId = Convert.ToInt16(Request.QueryString["StuId"]); //use i in next statement as 2nd argument....

CouId = Convert.ToInt16(Request.QueryString["CourseId"]);

}

protected void btnInsert_Click(object sender, EventArgs e)

{

try

{

SqlParameter[] parList = new SqlParameter[2];

parList[0] = new SqlParameter("@iStuId", StuId);

parList[1] = new SqlParameter("@dtSDate", txtExamDate.Text.Trim());

bool i = objDBMgt.ExecuteNonQueryStoreProc("insSchedule", parList);

if (i == true)

lblMsg.Text = "New Criteria Created!!!";

else

lblMsg.Text = "Criteria Not Created!!!";

}

catch (SqlException SqlEx) // This Catch block is used to Catch the Sql or Backend related Problem

{

lblMsg.Text = "Sorry for inconvenience!!!!<br>Following BackEnd related Error Occured: +'" + SqlEx.Message + "'<br>Try Again!!!";

}

catch (Exception ex) // This Block is used to catch any exception occured if not related to upper exception

{

lblMsg.Text = "Sorry for inconvenience!!!!<br>Following Error Occured: +'" + ex.Message + "'<br>Try Again!!!";

}

}

protected void Calendar1_SelectionChanged(object sender, EventArgs e)

{

if (Calendar1.SelectedDate.Date < DateTime.Today)

{

txtExamDate.Text = "Invalid Date assigned!!";

txtExamDate.BackColor = System.Drawing.Color.Red;

btnInsert.Enabled = false;

}

else

{

txtExamDate.Text = Calendar1.SelectedDate.Date.ToShortDateString();

txtExamDate.BackColor = System.Drawing.Color.White;

btnInsert.Enabled = true;

}

}

}

CheckSubjAns

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class ExamDept_ CheckSubjAns: System.Web.UI.Page

{

DBMgt objDBMgt = new DBMgt();

protected void Page_Load(object sender, EventArgs e)

{

}

protected void btnInsert_Click(object sender, EventArgs e)

{

try

{

SqlParameter[] parList = new SqlParameter[3];

parList[0] = new SqlParameter("@iStuId ", Convert.ToInt16(FormView1.DataKey.Value));

parList[1] = new SqlParameter("@iMarkOfSub",Convert.ToInt16(txtMarks.Text.Trim()));

parList[2] = new SqlParameter("@chStatus", DropDownList1.SelectedItem.Text.Trim());

bool i = objDBMgt.ExecuteNonQueryStoreProc("insResult", parList);

if (i == true)

lblMsg.Text = "Submitted!!!";

else

lblMsg.Text = "Not Submitted!!!";

}

catch (SqlException SqlEx) // This Catch block is used to Catch the Sql or Backend related Problem

{

lblMsg.Text = "Sorry for inconvenience!!!!<br>Following BackEnd related Error Occured: +'" + SqlEx.Message + "'<br>Try Again!!!";

}

catch (Exception ex) // This Block is used to catch any exception occured if not related to upper exception

{

lblMsg.Text = "Sorry for inconvenience!!!!<br>Following Error Occured: +'" + ex.Message + "'<br>Try Again!!!";

}

}

}