how to assign value to dropdownlist based on selection

Question

how to assign a value for dropdownlist based on selection.

Feeback page Design as follows

To What extent equipment is uptodate Dropdownlist1(Excellent/good/Fair)
To what extent equipment is user friendly Dropdownlist2(Excellent/good/Fair)
To What extent were the practicals Realistic Dropdownlist3(Excellent/good/Fair)

for example in Dropdownlist1 if user select the Excellent means 1 value to be store in the database.
similarily, in Dropdownlist2 if user select the good means 2 value to be store in the database.
similarily, in Dropdownlist3 if user select the Fair means 3 value to be store in the database.

for example in run mode as follows

To What extent equipment is uptodate Dropdownlist1 (Excellent)

if user select the Excellent in dropdownlist1 means the value 1 has to be stored in the database.

Output as follows in database

To What extent equipment is uptodate

1

For that how can i do in asp.net using csharp

regards,
narasiman P.

Satyapriya Nayak · Answer

Untitled Page onselectedindexchanged=DropDownList1_SelectedIndexChanged> onselectedindexchanged=DropDownList2_SelectedIndexChanged> onselectedindexchanged=DropDownList3_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_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(Choose); DropDownList1.Items.Add(Excellent); DropDownList1.Items.Add(Good); DropDownList1.Items.Add(Fair); DropDownList2.Items.Add(Choose); DropDownList2.Items.Add(Excellent); DropDownList2.Items.Add(Good); DropDownList2.Items.Add(Fair); DropDownList3.Items.Add(Choose); DropDownList3.Items.Add(Excellent); DropDownList3.Items.Add(Good); DropDownList3.Items.Add(Fair); } } protected void DropDownList1_SelectedIndexChanged(object sender EventArgs e) { if (DropDownList1.SelectedItem.Text == Excellent) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = insert into employee(status) values('1'); com = new SqlCommand(str con); com.ExecuteNonQuery(); con.Close(); } else if (DropDownList1.SelectedItem.Text == Good) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = insert into employee(status) values('2'); com = new SqlCommand(str con); com.ExecuteNonQuery(); con.Close(); } else { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = insert into employee(status) values('3'); com = new SqlCommand(str con); com.ExecuteNonQuery(); con.Close(); } } protected void DropDownList2_SelectedIndexChanged(object sender EventArgs e) { if (DropDownList2.SelectedItem.Text == Excellent) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = insert into employee(status) values('1'); com = new SqlCommand(str con); com.ExecuteNonQuery(); con.Close(); } else if (DropDownList2.SelectedItem.Text == Good) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = insert into employee(status) values('2'); com = new SqlCommand(str con); com.ExecuteNonQuery(); con.Close(); } else { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = insert into employee(status) values('3'); com = new SqlCommand(str con); com.ExecuteNonQuery(); con.Close(); } } protected void DropDownList3_SelectedIndexChanged(object sender EventArgs e) { if (DropDownList3.SelectedItem.Text == Excellent) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = insert into employee(status) values('1'); com = new SqlCommand(str con); com.ExecuteNonQuery(); con.Close(); } else if (DropDownList3.SelectedItem.Text == Good) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = insert into employee(status) values('2'); com = new SqlCommand(str con); com.ExecuteNonQuery(); con.Close(); } else { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = insert into employee(status) values('3'); com = new SqlCommand(str con); com.ExecuteNonQuery(); con.Close(); } } } }