filling a textbox when dropdown selected item change

Accepted answer

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

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 Bhasme11y ago

Hi,

Is It Gettin called On Page Load event?

Mohammed Rizwanullah11y ago

Hi Bhushan

Mohammed Rizwanullah11y ago

i have hilighted with red color

Bhushan Bhasme11y ago

where You are Binding ddlstage dropdown list with master table

Mohammed Rizwanullah11y ago

This is the aspx page, and also all RFVs not working plz chek it

<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="New_Lead.aspx.cs" Inherits="New_Lead" %>

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">

<%#((GridViewRow)Container).DataItemIndex + 1 %>

<%--AlternateText="Delete" CommandName="Delete" runat="server" OnClientClick="javascript:return confirm('Do you want to delete this record?');" />--%>

ProviderName="<%$ ConnectionStrings:Leadcon.ProviderName %>" SelectCommand="SELECT DISTINCT Lead_City FROM Tbl_Lead_City_Master">

ProviderName="<%$ ConnectionStrings:Leadcon.ProviderName %>" SelectCommand="SELECT DISTINCT Lead_Source FROM Tbl_Lead_Source_Master">

ProviderName="<%$ ConnectionStrings:Leadcon.ProviderName %>" SelectCommand="SELECT DISTINCT Lead_Mode FROM Tbl_Lead_Mode_Master">

ProviderName="<%$ ConnectionStrings:Leadcon.ProviderName %>" SelectCommand="SELECT DISTINCT Lead_Stage FROM Tbl_Lead_Stage_Master">

ProviderName="<%$ ConnectionStrings:Leadcon.ProviderName %>" SelectCommand="SELECT Lead_Id,Lead_Date,Lead_Name,
Lead_Mobile,Lead_Email,Lead_City,Lead_Source,Lead_Mode,Lead_Worth,Lead_Stage,Lead_Percentage,Lead_Amount,Lead_Comment FROM Tbl_LeadManagement ORDER BY Lead_Id"
DeleteCommand="DELETE FROM Tbl_LeadManagement WHERE (Lead_Id = @Lead_Id)">

Mohammed Rizwanullah11y ago

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_Id,Lead_Date=@Lead_Date,Lead_Name=@Lead_Name,Lead_Mobile=@Lead_Mobile,Lead_Email=@Lead_Email,lead_City=@Lead_City,Lead_Source=@Lead_Source,Lead_Mode=@Lead_Mode,Lead_Worth=@Lead_Worth,Lead_Stage=@Lead_Stage,Lead_Percentage=@Lead_Percentage,Lead_Amount=@Lead_Amount,Lead_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 Bhasme11y ago

Please Paste Your code Here

Mohammed Rizwanullah11y ago

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 Rizwanullah11y ago

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 Rizwanullah11y ago

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