Candidate details

 using System;

using System.Data;

using System.Configuration;

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;

using System.Collections.Generic;

public partial class _Default : System.Web.UI.Page 

{

    protected void Page_Load(object sender, EventArgs e)

    {

        int a;

    }

    protected void Button1_Click(object sender, EventArgs e)

    {

        int age;

        DateTime bday = Calendar1.SelectedDate;

        DateTime today = DateTime.Today;

        age = today.Year - bday.Year;

        if (bday > today.AddYears(-age))

        {

            age--;

        }

        String skill;

        skill="";

        foreach (ListItem lst in CheckBoxList1.Items)

        {

            if (lst.Selected == true)

            {

                skill += lst.Text + ",";

            }

        }

        SqlConnection con = new SqlConnection("");

        SqlCommand cmd = new SqlCommand();

        cmd.Connection = con;

        con.Open();

        cmd.CommandText = "insert into job values('" + txtname.Text + "','" + txtfname.Text + "','" + Rbl1.SelectedItem.Text + "'," + age + ",'" + txtq.Text + "','" + txtname.Text + "')";

        cmd.ExecuteNonQuery();

        con.Close();

        Response.Write("<script>alert('Your details have been inserted successfully')</script)");

        Response.Redirect("success.aspx");

        

    }

    protected void Calendar1_SelectionChanged(object sender, EventArgs e)

    {

        int today = Calendar1.TodaysDate.Year;

        int d = Calendar1.SelectedDate.Year;

        age = toay - d;

        if (age < 21)

            lblage.Text = "Ages ";

        else

            a = age;

    }

}