Values lost during submit event

Question

I Have three dropdowns, and whenever i select the items and enter the submit button to insert the record.. the values which i selected are lost from dropdown plz help me out with this

Priyaranjan K S · Answer

Hi Mohammed, M best guess is that when the button is clicked it caused post back and the page reloads. Now you might have written the drop down population in the form load without checking if it is a post back or not . Populate your drop down values inside the form load event within the '!Page.IsPostBack' block as below : protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //Populate your dropdowns } } This should retain your drop down values in previous state. Thanks, Priyan If you found this useful Please mark this as Answer

Mohammed Rizwanullah · Answer

Any Solutions?

Mohammed Rizwanullah · Answer

Any Solutions?

Mohammed Rizwanullah · Answer

Values are saving to the database no prob..but when again if i want insert another record the last values which was selected lost from the dropdown

Mohammed Rizwanullah · Answer

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

Mohammed Rizwanullah · Answer

Its an Asp.net application

Mohammed Rizwanullah · Answer

This Is My Code for inserting the record 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(); } And This Is code where am binding the dropdown,i mean i have datasource Lead City * runat="server" DataSourceID="srcCity" DataTextField="Lead_City"> ErrorMessage="Select City" Display="Dynamic" runat="server"> Lead Source *   runat="server" DataSourceID="srcSource" DataTextField="Lead_Source" > Display="Dynamic" runat="server"> Lead Mode *   runat="server" DataSourceID="srcMode" DataTextField="Lead_Mode" > 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" OnSelectedIndexChanged="ddlStage_SelectedIndexChanged"> ErrorMessage="Select Stage" ValidationGroup="Add" runat="server"> Values are saving to the database no prob..but when again if i want insert another record the last values which was selected lost from the dropdown

Sasindran Thavaselvam · Answer

Could you please let me know "Whether its MVC or ASP.NET application?"

Vishwakant Tripathi · Answer

Can you please post how you binding dropdownlist and submit event, so it would help to track the issue.

vivekanantha Sampath · Answer

Hi Mohammed, Could you please let me know "The value lost" means its not saving to the database or after saving once the page refreshed DropDown values are cleared. Thanks Vivekanantha Sampath