NEXT ManageExpert

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 Controller_ ManageExpert: 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

{

string strLoginName = txtFName.Text.Trim() + txtCourse.Text.Trim();

string strPWD = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPWD.Text.Trim(), "SHA1");

SqlParameter[] parList = new SqlParameter[5];

parList[0] = new SqlParameter("@cFName", txtFName.Text.Trim());

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

parList[2] = new SqlParameter("@cCourse ", txtCourse.Text.Trim());

parList[3] = new SqlParameter("@vLoginName", strLoginName);

parList[4] = new SqlParameter("@vPassword ", strPWD);

bool i = objDBMgt.ExecuteNonQueryStoreProc("insExpert", 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!!!";

}

}

}