Solved

TEXTBOX DEPENDENCY ON DROPDOWN SELECTION

Posted on 2014-10-07
2
124 Views
Last Modified: 2014-10-08
Please review the attach code behind segment.    Section one of the code below works fine populating TextBox    "EmpAP" data from the DB when a corresponding value is selected from "CondBY".    However, I have a second drop down "InspBy1" in which I need to accomplish the same thing.

I need assistance with the arrangement of the code.  

-------------------------------------------------------------------------------------------------------------------------------------------------------


protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            FillDropdown();
        }
    }
    //Filldrop down
    void FillDropdown()
    {

        SqlConnection con = new SqlConnection("");//connection string;
        con.Open();

        SqlCommand cmd = new SqlCommand("select * from EmpData", con);
        SqlDataAdapter dap = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        dap.Fill(ds);
        CondBY.DataSource = ds;
        CondBY.DataTextField = "Name1";//Database table filed name for display in dropdown
        CondBY.DataValueField = "EmpNo";//display in textbox when select dropdown field
        CondBY.DataBind();
    }


    protected void CondBY_SelectedIndexChanged(object sender, EventArgs e)
    {
        EmpAP.Text = CondBY.SelectedValue.ToString();// get value form dropdown

    }


----------------------------------------------------------------------------------------------------------------------------------------------------------

    private void Page_Load(object sender, EventArgs e)
    {


        SqlConnection con = new SqlConnection("");//connection string;
        con.Open();

        SqlCommand cmd = new SqlCommand("select * from EmpData", con);
        SqlDataAdapter dap = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        dap.Fill(ds);
        InspBy1.DataSource = ds;
        InspBy1.DataTextField = "Name1";//Database table filed name for display in dropdown
        InspBy1.DataValueField = "EmpNo";//display in textbox when select dropdown field
        InspBy1.DataBind();
    }


    protected void InspBy1_SelectedIndexChanged(object sender, EventArgs e)
    {
        EmpAP1.Text = InspBy1.SelectedValue.ToString();// get value form dropdown


    }


}
0
Comment
Question by:BOEING39
2 Comments
 
LVL 2

Accepted Solution

by:
Vishal Patil earned 500 total points
ID: 40367696
Hello Boeing39,

If i have understood your question correctly,
Arrange code in following manner :
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            FillDropdown(CondBY);
            FillDropdown(InspBy1);
        }
    }
    //Filldrop down
    void FillDropdown(DropDownList ddl)
    {

        SqlConnection con = new SqlConnection("");//connection string;
        con.Open();

        SqlCommand cmd = new SqlCommand("select * from EmpData", con);
        SqlDataAdapter dap = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        dap.Fill(ds);
        ddl.DataSource = ds;
        ddl.DataTextField = "Name1";//Database table filed name for display in dropdown
        ddl.DataValueField = "EmpNo";//display in textbox when select dropdown field
        ddl.DataBind();
    }


    protected void CondBY_SelectedIndexChanged(object sender, EventArgs e)
    {
        EmpAP.Text = CondBY.SelectedValue.ToString();// get value form dropdown

    }
    protected void InspBy1_SelectedIndexChanged(object sender, EventArgs e)
    {
        EmpAP1.Text = InspBy1.SelectedValue.ToString();// get value form dropdown
    }

Open in new window

0
 

Author Closing Comment

by:BOEING39
ID: 40368350
Thx for the quick response - that took care of the problem.


Thx Again
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
C# HTTP GET method sample code 3 57
free scanner TWAIN can be operated with a Web application 9 60
rest webservice call over https via c# 6 37
Keyboard 2 33
Article by: Najam
Having new technologies does not mean they will completely replace old components.  Recently I had to create WCF that will be called by VB6 component.  Here I will describe what steps one should follow while doing so, please feel free to post any qu…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question