Hi! i have a slight problem here,I have the following master tables
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

and based on the ID's present in the master table i retreieve few fields on a label in a form....What i want to do is when i store these values of the form in a new table i want only the id's to be stored and not the text values which are being displayed in the label of the form.Below is the code I tried..Can anyone help me?

*

    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.Data.OleDb;
    using System.Configuration;
    using System.Web.UI.HtmlControls;
    using System.Xml.Linq;


    namespace Travel1.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();//adding the group to the dropdownbox



                }
            }














         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!");
            }

        }








        }
        }*

As it stands you don't put the ids in the labels.Or anywhere on the formfor that matter.

you could add two extra hidden labels on the form where you store the ids and them pull their text into the parameters

This article has been dead for over six months. Start a new discussion instead.