Source code for SECURITY in CCFD

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 pgSecurity : System.Web.UI.Page

{

    DataAccess data = new DataAccess();

    protected void Page_Load(object sender, EventArgs e)

    {

        Session["uid"] = "100";

       

        txtUId.Text = Session["uid"].ToString();

    }

    protected void btnSubmit_Click(object sender, EventArgs e)

    {

        data.DBOpen();

        data.cmd = new SqlCommand("security_SP", data.cn);

        data.cmd.CommandType = CommandType.StoredProcedure;

        data.cmd.Parameters.Add(new SqlParameter("@mode", 1));

        data.cmd.Parameters.Add(new SqlParameter("@uid", Convert.ToInt32(txtUId.Text)));

        data.cmd.Parameters.Add(new SqlParameter("@SecQues1", ddlQ1.SelectedItem.Text));

        data.cmd.Parameters.Add(new SqlParameter("@SecAnswer1", txtAns1.Text));

        data.cmd.Parameters.Add(new SqlParameter("@SecQues2", ddlQ2.SelectedItem.Text));

        data.cmd.Parameters.Add(new SqlParameter("@SecAnswer2", txtAns2.Text));

        data.cmd.Parameters.Add(new SqlParameter("@SecQues3", ddlQ3.SelectedItem.Text));

        data.cmd.Parameters.Add(new SqlParameter("@SecAnswer3", txtAns3.Text));

        data.cmd.Parameters.Add(new SqlParameter("@SecQues4", ddlQ3.SelectedItem.Text));

        data.cmd.Parameters.Add(new SqlParameter("@SecAnswer4", txtAns4.Text));

        data.cmd.Parameters.Add(new SqlParameter("@SecQues5", ddlQ3.SelectedItem.Text));

        data.cmd.Parameters.Add(new SqlParameter("@SecAnswer5", txtAns5.Text));

        data.cmd.Parameters.Add(new SqlParameter("@Email", txtEmail.Text));

        data.cmd.Parameters.Add(new SqlParameter("@DOB", Convert.ToDateTime(txtDOB.Text)));

        data.cmd.Parameters.Add(new SqlParameter("@gender", ddlGender.SelectedItem.Text));

        data.cmd.ExecuteNonQuery();

        data.DBCmdClose();

        Response.Redirect("pgLogin.aspx");

    }

}