I want to pass a value in a combo box as a param to a SQL statement. The Winforms combobox gives me several options for retrieving the value, namely SelectedItem, SelectedText, and SelectedValue. Which one is best/safest to use in this scenario?
SelectedValue is probably the best one to use
SelectedText will give you the selected text of the editable portion, Selected Item will return you the object and selected index will return you the index. Usually for applications SelectedValue is extracted and used.
Check out Combobox from MSDN
SelectedIndex Gets or sets the index specifying the currently selected item. (Overrides ListControl.SelectedIndex.)
SelectedItem Gets or sets currently selected item in the ComboBox.
SelectedText Gets or sets the text that is selected in the editable portion of a ComboBox.
SelectedValue Gets or sets the value of the member property specified by the ValueMember property. (Inherited from ListControl.)
if (comboBox1.DropDownStyle == DropDownStyle.DropDown ||
comboBox1.DropDownStyle == DropDownStyle.Simple)
{
return comboBox1.Text;
}
Text
is probably the best one to use. This gets whatever is the currently selected text from the ComboBox as a string.
if (comboBox1.DropDownStyle == DropDownStyle.DropDownList)
{
return comboBox1.GetItemText(comboBox1.SelectedItem);
}
For this style, you cannot get the text from the ComboBox
. This returns the string from the item at the currently SelectedIndex
instead.
SelectedValue is probably the best one to use
SelectedText will give you the selected text of the editable portion, Selected Item will return you the object and selected index will return you the index. Usually for applications SelectedValue is extracted and used.
Check out Combobox from MSDN
SelectedIndex Gets or sets the index specifying the currently selected item. (Overrides ListControl.SelectedIndex.)
SelectedItem Gets or sets currently selected item in the ComboBox.
SelectedText Gets or sets the text that is selected in the editable portion of a ComboBox.
SelectedValue Gets or sets the value of the member property specified by the ValueMember property. (Inherited from ListControl.)
It depends on 3 things 1. Mode 2. DropDownStyle 3. Required Value
On ComboBox.SelectedIndexChanged
Unbound Mode
a. DropDownStyle = DropDown
- SelectedItem will return = SelectedText
- SelectedValue will return = ""
SelectedText will return = SelectedText
b. DropDownStyle = DropDownList
- SelectedItem will return = SelectedText
- SelectedValue will return = ""
- SelectedText will return = ""
Use Data Bound Mode (Means you are populating your ComboBox from some data source i.e SQL Server Table) You will select a Column of the table as DisplayMember and the same or another column as ValueMember.
a. DropDownStyle = DropDown
- SelectedItem will return = System.Data.DataRowView (Prompt)
- SelectedValue will return = Value of ValuMemeber
SelectedText will return = SelectedText (Value of DisplayMember)
b. DropDownStyle = DropDownList
- .SelectedItem will return = System.Data.DataRowView (Prompt)
- .SelectedValue will return = Value of ValueMember
- .SelectedText will return = ""
Note: You can also use .Text that will return = Text of ComboBox
Conclusion:
Unboud Mode
- .SelectedItem is the best choice
Data Bound Mode
a. ValueMember is required
.SelectedValue is the best choice
b. DisplayMember is required
- .Text is the best choice
Microsoft suggest using this for value
ComboBox1.SelectedItem.ToString()
SelectedItem seems to be a safe choice.
I had this code:
NRBQConsts.currentSiteNum = listBoxSitesWithFetchedData.SelectedValue.ToString();
...which crashed with an NRE.
After changing it to this:
NRBQConsts.currentSiteNum = listBoxSitesWithFetchedData.SelectedItem.ToString();
...it works fine.
© 2022 - 2024 — McMap. All rights reserved.