How to remove Dropdown values in asp.net using c sharp?

Question

i have one dropdown in my form .....

if we click dropdown and it shows vales like 1
2
3
4 etc

I select value (1) in dropdown and saved those values in table successfully.

i need to remove the selected value(1) from dropdown after saved those values in table ....

If we click the dropdown again....I need the below result.....

I need result like 2
3
4

value 1 have to remove from the dropdown...How?

Ehtesham · Answer

If Save Button is used In Button_click //get the selected value for processing int SelectedValue=dropdownlist.SelectedValue; //after storing the selected value remove from dropdown dropdownlist.items.remove(dropdownlist.selecteditem); or dropdownlist.items.removeat(dropdownlist.selectedindex); ---------------------------------------------------------- If Save button is not used use SelectedIndexChanged event set Autopostback property of dropdownlist to true in SelectedIndexChanged event //get the selected value for processing int SelectedValue=dropdownlist.SelectedValue; //after storing the selected value remove from dropdown dropdownlist.items.remove(dropdownlist.selecteditem); or dropdownlist.items.removeat(dropdownlist.selectedindex);

Satyapriya Nayak · Answer

Hi MohanRaj Try this... Untitled Page onselectedindexchanged=DropDownList1_SelectedIndexChanged> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Dropdownlist_values_insert { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; string str; SqlCommand com; protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { DropDownList1.Items.Add(Select); DropDownList1.Items.Add(1); DropDownList1.Items.Add(2); DropDownList1.Items.Add(3); DropDownList1.Items.Add(4); DropDownList1.Items.Add(5); DropDownList1.Items.Add(6); } } protected void DropDownList1_SelectedIndexChanged(object sender EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); com = new SqlCommand(insert into test values(@id) con); com.Parameters.AddWithValue(@id DropDownList1.SelectedValue); com.ExecuteNonQuery(); com.Dispose(); con.Close(); int i = 0; i = DropDownList1.SelectedIndex; DropDownList1.Items.RemoveAt(i); } } } Thanks

MohanRaj C · Answer

Ya it working.....Thank u Ehtesham ....and also thanks trividi....

MohanRaj C · Answer

Web App..... I add values through Add list item in Drop down option

Jignesh Trivedi · Answer

hi Are you use web application or win form? An also I want to know how you fill dropdown first time?

MohanRaj C · Answer

How can i refill the dropdown after saved data? No need to bind dropdown values.... Just select one of values in dropdown and save data. Table have only 2 values one textbox one dropdown

Jignesh Trivedi · Answer

Hi Do one thing please refill Drop down after save sucussfully. Can please provide more info from where you bind dropdown and table structure? thnx.