store ID's in the database

M_employee

EMPID    Name 
1      abc
2      xyz
M_Division
DIVID  EMPID  DIVISON
1        2      arts
2        1      science
M_Designation
DESGID  EMPID  Designation
1         2      Teacher
2         1      Scientist

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using System.Web.UI.HtmlControls;
using System.Xml.Linq;
namespace Forms
{
    public partial class temporaryduty : System.Web.UI.Page
    {
        SqlConnection conn = new SqlConnection("Server; Database; Integrated security = true");
        protected void Page_Load(object sender, EventArgs e)
        {
            Lbltoday.Text = DateTime.Now.ToString();
            if (!IsPostBack)
            {
                GetName();
            }
        }
     private void GetName()
     {
         SqlCommand cmd = new SqlCommand("Select EMPID,Name FROM M_employee where IsActive=1 ORDER BY Name", conn);
         DataSet objDs = new DataSet();
         SqlDataAdapter sd = new SqlDataAdapter(cmd);
         conn.Open();
         sd.Fill(objDs);
         conn.Close();
         if (objDs.Tables[0].Rows.Count > 0)
         {
             ddlname.DataSource = objDs.Tables[0];
             ddlname.DataTextField = "Name";
             ddlname.DataValueField = "EMPID";
             ddlname.DataBind();
             ddlname.Items.Insert(0, "--Select--");
         }
     }
     protected void ddlname_SelectedIndexChanged(object sender, EventArgs e)
     {
         GetDivision(ddlname.SelectedItem.Value);
     }
     private void GetDivision(string Name)
     {
         SqlCommand cmd = new SqlCommand("SELECT M_employee.Name, M_Division.DIVISION, M_Division.DIVID AS Expr1, M_Designation.DesigID AS Expr2, M_Designation.Designation FROM M_employee INNER JOIN M_Division ON M_employee.DIVID = M_Division.DIVID INNER JOIN M_Designation ON M_employee.DesigID = M_Designation.DesigID WHERE M_employee.EMPID=@EMPID ", conn);
         cmd.Parameters.AddWithValue("@EMPID", Name);
         DataSet objDs = new DataSet();
         SqlDataAdapter sd = new SqlDataAdapter(cmd);
         conn.Open();
         sd.Fill(objDs);
         conn.Close();
         if (objDs.Tables[0].Rows.Count > 0)
         {
             lbldiv.Text = objDs.Tables[0].Rows[0]["DIVISION"].ToString();
             lbldesig.Text = objDs.Tables[0].Rows[0]["Designation"].ToString();
         }
     }
    protected void btnSubmit_Click2(object sender, EventArgs e)
    {
        string RelaseDate = Calendar1.SelectedDate.Date.ToString();
        SqlCommand cmd = new SqlCommand("Insert into T_TADA_tempform(EMPID,DIVID,DesigID) values(@EMPID,@DIVID,@DesigID)", conn);
        cmd.Parameters.AddWithValue("@EMPID", ddlname.SelectedValue);
        cmd.Parameters.AddWithValue("@DIVID", lbldesig.Text);
        cmd.Parameters.AddWithValue("@DesigID", lbldiv.Text);
        if (conn.State == ConnectionState.Closed)
        {
            conn.Open();
            int cnt = cmd.ExecuteNonQuery();
            conn.Close();
            if (cnt == 1)
            {
                Response.Redirect("form.aspx");
            }
            else
                Response.Write("Form has not been submitted,Please Try again!");
        }
    }
    }
    }