from dropdown list to text box using asp.net c#

Question

from 3 dropdown 1st clientId 2nd jobid 3rd module (if i chose clientid in that id how many job id must show in list and module in the jodid should be shown .the person who done the module should be show in the textbox ) using asp.net c# Untitled Page .style1 { width: 100%; } .style2 { width: 407px; }

Abhimanyu K Vatsa · Answer

I think by using Ajax Controls you can achieve this too. http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/CascadingDropDown/CascadingDropDown.aspx

V S N Raju Kanumuri · Answer

see below code it may be help U protected void DropDownList1_SelectedIndexChanged(object sender EventArgs e) { SqlConnection con = new SqlConnection(uid=sa;pwd=123;database=test;server=.);//provide ur connecting string SqlDataAdapter da = new SqlDataAdapter(select jobidjobname from jobs where jobid='+DropDownList1.SelectedValue+'con); DataTable dtjob = new DataTable(); da.Fill(dtjob); DropDownList2.DataSource = dtjob; DropDownList2.DataTextField = jobname; DropDownList2.DataValueField = jobid; DropDownList2.DataBind(); if (dtjob.Rows.Count > 0)// check wether jobs are there for client id { //Slect the first row jobid int jobid =Convert.ToInt32(dtjob.Rows[0][0]); //select modules for this job id and bind to drop down list //and check condition and show completed module in textbox }