filling a textbox when dropdown selected item change

Question

Hi I have a Master Table for Lead_Stage Agreement Closed Lost Now I want fill the value i.e when i select the item in dropdown Agrrement= 70%(should be displayed in the textbox) Closed=100% Lost=0% Followup=0% in the textbox plz guide me

Bhushan Bhasme · Answer

have you applied debugger and have checked the condition is becomming true or not..

Mohammed Rizwanullah · Answer

Hope U Gone Through my Code... No in Page load event not working.. Actually Values are lost when i submit for insert from the dropdowns

Bhushan Bhasme · Answer

Hi Is It Gettin called On Page Load event?

Mohammed Rizwanullah · Answer

Hi Bhushan

Mohammed Rizwanullah · Answer

i have hilighted with red color

Bhushan Bhasme · Answer

where You are Binding ddlstage dropdown list with master table

Mohammed Rizwanullah · Answer

This is the aspx page and also all RFVs not working plz chek it $(function () { $('#txtDate').datepicker({ changeMonth: true changeYear: true }); }); Lead Registration EnableViewState=false Visible=false runat=server /> EnableViewState=false Visible=false runat=server />--%> runat=server> * All fields are mandatory Lead ID *      runat=server AutoCompleteType=Enabled ClientIDMode=Static ValidationGroup=Add> ValidationGroup=Add> Lead Date *      runat=server AutoCompleteType=Disabled ValidationGroup=Add> ControlToValidate=txtDate ValidationGroup=Add > Lead Name *      runat=server AutoCompleteType=Disabled ValidationGroup=Add> ControlToValidate=txtName ValidationGroup=Add> Lead Mobile *      runat=server AutoCompleteType=Disabled ValidationGroup=Add> ControlToValidate=txtMobile ValidationGroup=Add > Lead Email *      runat=server AutoCompleteType=Disabled ValidationGroup=Add> ControlToValidate=txtEmail ValidationGroup=Add> Lead City * runat=server DataSourceID=srcCity DataTextField=Lead_City ValidationGroup=Add> ErrorMessage=Select City Display=Dynamic runat=server> Lead Source *   runat=server DataSourceID=srcSource DataTextField=Lead_Source ValidationGroup=Add> Display=Dynamic runat=server> Lead Mode *   runat=server DataSourceID=srcMode DataTextField=Lead_Mode ValidationGroup=Add> Display=Dynamic ValidationGroup=Add ControlToValidate=ddlMode> Lead Worth *      runat=server AutoCompleteType=Disabled ValidationGroup=Add> ControlToValidate=txtWorth ValidationGroup=Add Display=Dynamic> Lead Stage *   DataTextField=Lead_Stage DataSourceID=srcStage ValidationGroup=Add OnSelectedIndexChanged=ddlStage_SelectedIndexChanged> ErrorMessage=Select Stage ValidationGroup=Add runat=server> Lead Percentage *    runat=server AutoCompleteType=Disabled ValidationGroup=Add> ControlToValidate=txtPercent ValidationGroup=Add> Lead Amount ImageAlign=AbsMiddle ImageUrl=~/Images/rupee_symbol.jpg runat=server BackColor=#CCCCFF Height=20px /> *  --%> ControlToValidate=txtAmount ValidationGroup=Add > Lead Comment *      runat=server AutoCompleteType=Disabled TextMode=MultiLine ValidationGroup=Add> ControlToValidate=txtComment ValidationGroup=Add >   runat=server ValidationGroup=Add OnClick=btnAdd_Click OnClientClick=return basicValidation();/>     runat=server CausesValidation=False OnClick=btnClear_Click />    runat=server CausesValidation=False OnClick=btnUpdate_Click /> runat=server OnClick=imgExport_Click CausesValidation=False /> runat=server OnClick=linkExport_Click CausesValidation=False> DataSourceID=SqlDataSource1 DataKeyNames=Lead_Id BackColor=White BorderColor=#CC9966 BorderStyle=None BorderWidth=1px OnSelectedIndexChanged=GridStock_SelectedIndexChanged> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> '> --%>  ProviderName=  SelectCommand=SELECT DISTINCT Lead_City FROM Tbl_Lead_City_Master>  ProviderName=  SelectCommand=SELECT DISTINCT Lead_Source FROM Tbl_Lead_Source_Master>  ProviderName=  SelectCommand=SELECT DISTINCT Lead_Mode FROM Tbl_Lead_Mode_Master>  ProviderName=  SelectCommand=SELECT DISTINCT Lead_Stage FROM Tbl_Lead_Stage_Master>  ProviderName=  SelectCommand=SELECT Lead_IdLead_DateLead_Name Lead_MobileLead_EmailLead_CityLead_SourceLead_ModeLead_WorthLead_StageLead_PercentageLead_AmountLead_Comment FROM Tbl_LeadManagement ORDER BY Lead_Id DeleteCommand=DELETE FROM Tbl_LeadManagement WHERE (Lead_Id = @Lead_Id)>

Mohammed Rizwanullah · Answer

protected void Page_Load(object sender EventArgs e) { } protected void btnAdd_Click(object sender EventArgs e) { SqlConnection con = new SqlConnection(constring); SqlCommand cmd = new SqlCommand(insert_LeadRegistration con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(@Lead_Id txtLeadId.Text); cmd.Parameters.AddWithValue(@Lead_Date txtDate.Text); cmd.Parameters.AddWithValue(@Lead_Name txtName.Text); cmd.Parameters.AddWithValue(@Lead_Mobile txtMobile.Text); cmd.Parameters.AddWithValue(@Lead_Email txtEmail.Text); cmd.Parameters.AddWithValue(@Lead_City ddlCity.SelectedItem.Text); cmd.Parameters.AddWithValue(@Lead_Source ddlSource.SelectedItem.Text); cmd.Parameters.AddWithValue(@Lead_Mode ddlMode.SelectedItem.Text); cmd.Parameters.AddWithValue(@Lead_Worth txtWorth.Text); cmd.Parameters.AddWithValue(@Lead_Stage ddlStage.SelectedItem.Text); cmd.Parameters.AddWithValue(@Lead_Percentage txtPercent.Text); cmd.Parameters.AddWithValue(@Lead_Amount txtAmount.Text); cmd.Parameters.AddWithValue(@Lead_Comment txtComment.Text); try { con.Open(); int count = cmd.ExecuteNonQuery(); if (count > 0) { //imgInfo.Visible = true; lblInfo.Visible = true; lblInfo.Text = Record saved successfully; GridStock.DataSourceID = SqlDataSource1; } } catch (Exception ex) { //imgInfo.Visible = false; //imgError.Visible = true; lblInfo.Visible = true; lblInfo.Text = ex.Message; } finally { con.Close(); } } protected void GridStock_SelectedIndexChanged(object sender EventArgs e) { GridViewRow row = GridStock.SelectedRow; txtLeadId.Text = ((Label)row.FindControl(Label1)).Text; txtDate.Text = ((Label)row.FindControl(Label2)).Text; txtName.Text = ((Label)row.FindControl(Label3)).Text; txtMobile.Text = ((Label)row.FindControl(Label4)).Text; txtEmail.Text = ((Label)row.FindControl(Label5)).Text; ddlCity.SelectedItem.Text = ((Label)row.FindControl(Label6)).Text; ddlSource.SelectedItem.Text = ((Label)row.FindControl(Label7)).Text; ddlMode.SelectedItem.Text = ((Label)row.FindControl(Label8)).Text; txtWorth.Text = ((Label)row.FindControl(Label9)).Text; ddlStage.SelectedItem.Text = ((Label)row.FindControl(Label10)).Text; txtPercent.Text = ((Label)row.FindControl(Label11)).Text; txtAmount.Text = ((Label)row.FindControl(Label12)).Text; txtComment.Text = ((Label)row.FindControl(Label13)).Text; } protected void btnUpdate_Click(object sender EventArgs e) { string constring = System.Web.Configuration.WebConfigurationManager.ConnectionStrings[Leadcon].ConnectionString; SqlConnection con = new SqlConnection(constring); SqlCommand cmd = new SqlCommand(update Tbl_LeadManagement set Lead_Id=@Lead_IdLead_Date=@Lead_DateLead_Name=@Lead_NameLead_Mobile=@Lead_MobileLead_Email=@Lead_Emaillead_City=@Lead_CityLead_Source=@Lead_SourceLead_Mode=@Lead_ModeLead_Worth=@Lead_WorthLead_Stage=@Lead_StageLead_Percentage=@Lead_PercentageLead_Amount=@Lead_AmountLead_Comment=@Lead_Comment where Lead_Id=@Lead_Id con); cmd.Parameters.AddWithValue(@Lead_Id txtLeadId.Text); if (txtDate.Text != string.Empty) { string[] strdtarr1 = System.Text.RegularExpressions.Regex.Split(txtDate.Text /); string strdt1 = strdtarr1[1] + / + strdtarr1[0] + / + strdtarr1[2]; cmd.Parameters.AddWithValue(@Lead_Date strdt1); } else { cmd.Parameters.AddWithValue(@Lead_Date txtDate.Text); } cmd.Parameters.AddWithValue(@Lead_Name txtName.Text); cmd.Parameters.AddWithValue(@Lead_Mobile txtMobile.Text); cmd.Parameters.AddWithValue(@Lead_Email txtEmail.Text); cmd.Parameters.AddWithValue(@Lead_City ddlCity.SelectedItem.Text); cmd.Parameters.AddWithValue(@Lead_Source ddlSource.SelectedItem.Text); cmd.Parameters.AddWithValue(@Lead_Mode ddlMode.SelectedItem.Text); cmd.Parameters.AddWithValue(@Lead_Worth txtWorth.Text); cmd.Parameters.AddWithValue(@Lead_Stage ddlStage.SelectedItem.Text); cmd.Parameters.AddWithValue(@Lead_Percentage txtPercent.Text); cmd.Parameters.AddWithValue(@Lead_Amount txtAmount.Text); cmd.Parameters.AddWithValue(@Lead_Comment txtComment.Text); try { con.Open(); int intupdate = cmd.ExecuteNonQuery(); if (intupdate > 0) { //imgInfo.Visible = true; lblInfo.Visible = true; lblInfo.Text = Record updated successfully!; this.LoadGridData(); } } catch (Exception ex) { throw ex; } finally { con.Close(); } } protected void ddlStage_SelectedIndexChanged(object sender EventArgs e) { if (ddlStage.SelectedItem.Text == Agreement) { txtPercent.Text = 70%; } }

Bhushan Bhasme · Answer

Please Paste Your code Here

Mohammed Rizwanullah · Answer

Hi Bhushan its working But Theres some prob the values in the dropdown are missing when ever i again want to insert.. Agreement is missing from the dropdown plz help

Mohammed Rizwanullah · Answer

i will Check and reply you.. But Another help i.e whenever i open VS2012 with my app...a pop shwoing .Net Framework 4.0 not registered in the web server.. Could you plz help with that... actually am unable to do the debugging  i think is there any prop with the above issue the cursor is not reflecting at the code whenever i start debugging

Mohammed Rizwanullah · Answer

Sorry I think I have Confused You... I just have Dropdown in which Values are coming from a Master Table from database and I just want To Hardcode every value with some Percentage and this percentage value should disply in the textbox txtpercent whenever i select related item in the dropdown.

Mohammed Rizwanullah · Answer

protected void ddlStage_SelectedIndexChanged(object sender EventArgs e) { if (ddlStage.SelectedItem.Text == Agreement) { txtPercent.Text = 70%; } } sorry Last Reply was wrong... I have this way but its not working

Bhushan Bhasme · Answer

check first what value are you getting in ((Label)row.FindControl(Label1)).Text;

Mohammed Rizwanullah · Answer

Yes I wana hardCode it but its not working if (ddlStage.SelectedValue == Agreement) { txtPercent.Text = 70; } and already have some code in protected void GridStock_SelectedIndexChanged(object sender EventArgs e) { GridViewRow row = GridStock.SelectedRow; txtLeadId.Text = ((Label)row.FindControl(Label1)).Text; txtDate.Text = ((Label)row.FindControl(Label2)).Text; txtName.Text = ((Label)row.FindControl(Label3)).Text; txtMobile.Text = ((Label)row.FindControl(Label4)).Text; txtEmail.Text = ((Label)row.FindControl(Label5)).Text; ddlCity.SelectedItem.Text = ((Label)row.FindControl(Label6)).Text; ddlSource.SelectedItem.Text = ((Label)row.FindControl(Label7)).Text; ddlMode.SelectedItem.Text = ((Label)row.FindControl(Label8)).Text; txtWorth.Text = ((Label)row.FindControl(Label9)).Text; ddlStage.SelectedItem.Text = ((Label)row.FindControl(Label10)).Text; txtPercent.Text = ((Label)row.FindControl(Label11)).Text; txtAmount.Text = ((Label)row.FindControl(Label12)).Text; txtComment.Text = ((Label)row.FindControl(Label13)).Text; }

Bhushan Bhasme · Answer

suppose you have cmblead_Stage as dropdown list. where You are storing percentage value for aggrementclosedlost. if You want hard coated value then if(cmblead.selectedvalue==Agreement){ txtsample.text=70%; }