dropdownlist selected value is not saved in the database

Question

In run mode as follows

Name textbox1

Designation Courseofficer (Dropdownlist)
Prinicpal
Director

Save(Buuton)
in the designation column three values are there in the dropdownlist

When user type the name ram in textbox1 and select the designation from the dropdownlist.
Suppose i am selecting the Courseofficer from the dropdownlist and click Save button records are saved.

but i am selecting the courseofficer from the dropdownlist only. But in database
last value Director is saved in the database.

Save button code as follows
Sql = "insert into Designations values('" + txt_name.Text + "','" + ddldesg.SelectedValue.ToString() + "')";
SCon.ExecSql(Sql);
LblErr.Text = "Record Inserted Successfully";
SCon.Con.Close();

In database records as follows
ID Name Designations
1 Ram Director

please help me what is the problem in my above code.

Munesh Sharma · Answer

http://www.aspsnippets.com/Articles/Save-Insert-DropDownList-Selected-Value-to-Database-in-ASPNet-using-C-and-VBNet.aspx

Rakesh · Answer

ddldesg.SelectedValue.ToString() Replace with ddldesg.SelectedItem

Upendra Pratap Shahi · Answer

Hello Try this code snipt- protected void btnSave_Click( object sender EventArgs e) { string strQry = insert into tbl_test values(' + txt_name.Text .ToString() + '' + ddldesg. SelectedItem . Text . ToString() . ToString() + ') ; SqlConnection con = new SqlConnection(  ); SqlCommand cmd = new SqlCommand(insertquery con); con.Open(); int i = Convert .ToInt32(cmd.ExecuteNonQuery()); con.Close(); if (i > 0) { LblErr.Text = Record Inserted Successfully ; } }

Rajeesh Menoth · Answer

Hi Put a break point and check which value you present in the dropdownlist and how to fetch the dropdown values like PrinicpalDirector ? that's mean it's dynamically added in your dropdown or directly added ?

Dipankar Biswas · Answer

Hi check this link to help.. http://www.aspsnippets.com/Articles/Save-Insert-DropDownList-Selected-Value-to-Database-in-ASPNet-using-C-and-VBNet.aspx

Raja T · Answer

Hi try like this protected void Button1_Click(object sender EventArgs e) { string insertquery = insert into tbl_test values(' + TextBox1.Text + '' + DropDownList1.SelectedItem.Value + '); SqlConnection con = new SqlConnection(); SqlCommand cmd = new SqlCommand(insertquery con); con.Open(); int i = Convert.ToInt32(cmd.ExecuteNonQuery()); con.Close(); if (i > 0) { Label3.Text = Record Inserted Successfully; } }