Show default value in dropdown list from database

sunny kumar

I am saving dropdown list values to database , but when i am trying to retrieve the value saved in the database to dropdown, the dropdown default value shows different value

using (SqlConnection con = new SqlConnection(st))

{

con.Open();

SqlCommand cmd = new SqlCommand("spGetUploadedImage", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@PId", Convert.ToInt32(ddproject.SelectedValue.ToString()));

SqlDataReader rd = cmd.ExecuteReader();

if (rd.Read())

{

txtuserdomain.Text = rd["P_user_domain"].ToString();

txtawards.Text = rd["P_awards"].ToString();

txtcoverage.Text = rd["P_functional_coverage"].ToString();

txtfeatures.Text = rd["P_feature"].ToString();

txtimplementation.Text = rd["P_implementation"].ToString();

ddimportance.DataValueField = rd["Importance"].ToString();

}

13 Replies

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

Jignesh Kumar7y ago
Hi,

Please change values for ddimportance.DataValueField = rd["Importance"].ToString();
ddimportance.Items.FindByValue( rd["Importance"].ToString()).Selected = true;
0
Salman Beg7y ago
What value you are getting in this rd["Importance"].tostring(); just paste here. thanks
0
sunny kumar7y ago
when i am writing
lblimportance.text=rd["Importance"].tostring();

it is showing the value which i want in the label
0
Salman Beg7y ago
Can you check what value you are getting here in this, rd["Importance"].tostring(); by putting debugger. Thanks
0
sunny kumar7y ago

I have used like this in dropdown
0
Salman Beg7y ago
First you need to bind the drop-down and after that you can select the value in it. You can follow this article to first bind the drop-down, https://www.aspsnippets.com/Articles/Set-Default-value-in-ASPNet-DropDownList-in-Code-Behind-using-C-and-VBNet.aspx After that bind your value in it. Thanks
0
sunny kumar7y ago
when i use "findbyvalue" it shows object parameter not set to an instance of an object. and when i use "findbytext" it show cannot have multiple items selected in a dropdown list
0
Salman Beg7y ago
Ddlimportance.Items.FindByText(value). Selected=true; Can you try this? thanks
0
sunny kumar7y ago
i m saving the value of the dropdown list in the database, and when i am calling that value in label it showing fine, but not in dropdown list as the default value. and i tried

ddimportance.selectedvalue=rd["Importance"].tostring();

but not working
0
Salman Beg7y ago
Can you do like this, Ddl.SelectedValue=value; One more thing check that in that Dr value is coming or not. Thanks
0
sunny kumar7y ago
Bro salman, i used this but still not working

using (SqlConnection con = new SqlConnection(st))
{
con.Open();
SqlCommand cmd = new SqlCommand("spGetUploadedImage", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PId", Convert.ToInt32(ddproject.SelectedValue.ToString()));
SqlDataReader rd = cmd.ExecuteReader();
if (rd.Read())
{
txtuserdomain.Text = rd["P_user_domain"].ToString();
txtawards.Text = rd["P_awards"].ToString();
txtcoverage.Text = rd["P_functional_coverage"].ToString();
txtfeatures.Text = rd["P_feature"].ToString();
txtimplementation.Text = rd["P_implementation"].ToString();
ddimportance.Items.FindByValue(rd["Importance"].ToString()).Selected = true;
0
Salman Beg7y ago
Hi. You need to use like this, Ddlimportance.ClearSelection(); Ddlimportance.Items.FindByValue(value). Selected=true; Thanks
0
Sanwar Ranwa7y ago
Check these Links sunny it may help you

https://stackoverflow.com/questions/24203424/how-to-add-dropdown-list-default-value

https://www.aspsnippets.com/Articles/Set-Default-value-in-ASPNet-DropDownList-in-Code-Behind-using-C-and-VBNet.aspx

https://www.youtube.com/watch?v=EZsOAGYmKcs

https://nimblegecko.com/how-to-set-default-selected-value-on-drop-down-list-from-database/
-1