Select dropdown menu by session user

Question

User-1901014284 posted

I am looking to select an option from my dropdown menu by the user session that has signed into the system, please see below the code for my dropdown menu.

SqlConnection sqlConnection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
SqlCommand cmd = new SqlCommand();
Visit_Call_OtherDropDownList.Items.Add(new ListItem("--Please Select--", ""));
Visit_Call_OtherDropDownList.AppendDataBoundItems = true;
string strQuery = "Select ID, Visit_Call_Other from Visit_Call_Other";
cmd.Connection = sqlConnection;
cmd.CommandType = CommandType.Text;
cmd.CommandText = strQuery;
sqlConnection.Open();
Visit_Call_OtherDropDownList.DataSource = cmd.ExecuteReader();
Visit_Call_OtherDropDownList.DataTextField = "Visit_Call_Other";
Visit_Call_OtherDropDownList.DataValueField = "ID";
Visit_Call_OtherDropDownList.DataBind();
sqlConnection.Close();

I have been thinking it to be along the lines of:

if (Session["jobRole"].ToString() == "3")
{

Dropdownmenu.Text = "2";

}

Any help would be greatly appreciated.

Regards

Jonny

Answer 1

User475983607 posted

Use the SelectedValue property of the DropDownList server control.

https://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.listcontrol.selectedvalue(v=vs.110).aspx

Answer 2

User2103319870 posted

You could also Try setting the value to Dropdownlist by using  FindItembyText method to find the particular item and set the selected index like given below

 if (Session["jobRole"].ToString() == "3")
                {

                    //Set an value in dropdownlist
                    Dropdownmenu.SelectedIndex = Dropdownmenu.Items.IndexOf(Dropdownmenu.Items.FindByText("2"));

                }

 

Answer 3

User-1901014284 posted

Thank you for your quick response, I have tried this and had no luck. I entered the code in the Page_Load of the C# page and amended where required. I have also tried using the ID and the Value as below still with no luck. 

Dropdownmenu.Items.FindByText("2"))

Dropdownmenu.Items.FindByText("Call"))

Answer 4

User-1901014284 posted

Thanks for your help, I have resolved it by using the below code.

if (Session["jobRole"].ToString() == "3")
{
Visit_Call_OtherDropDownList.SelectedValue = "2";
}

Again thank you for all your help greatly appreciated.

Kind Regards

Jonny