dropdownlist selected value is not saved in the database

narasiman rao

11y1.3kC#

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.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Munesh Sharma11y ago
http://www.aspsnippets.com/Articles/Save-Insert-DropDownList-Selected-Value-to-Database-in-ASPNet-using-C-and-VBNet.aspx
Rakesh11y ago
ddldesg.SelectedValue.ToString() Replace with ddldesg.SelectedItem
Upendra Pratap Shahi11y ago
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 Menoth11y ago
Hi,

Put a break point and check which value you present in the dropdownlist and how to fetch the dropdown values like Prinicpal,Director ? that's mean it's dynamically added in your dropdown or directly added ?
Dipankar Biswas11y ago
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 T11y ago
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";
}
}