combobox

Abiather Hore

Hello,

Please help. I have a drop down menu from january to december using a combobox. I would like January to be read as 1, February as 2 and so on depending on the selection as my filtering in my database reads the month as the integer symbol. How may i be able to have the combobox string value be interpreted as the equated numeric value.

6 Replies

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

Jaipal Reddy11y ago
ddlDesignation.Items.Clear();
DataSet ds = new DataSet();
ds = new BL_Month().GetMonthLIST();
if (ds.Tables.Count > 0 && ds != null && ds.Tables[0].Rows.Count > 0)
{
ddl.DataSource = ds;
ddl.DataValueField = "MonthId";
ddl.DataTextField = "MonthName";
ddl.DataBind();
ddl.Items.Insert(0, "Select");
}
0
theLizard11y ago
int j = -1;
string[] m = { "January", "February", "March", "April" ... };

for (int i = 0; i < 12; i++)
{
if (m[i] == comboBox1.Items[comboBox1.SelectedIndex])
{
j = i + 1;
break;
}
}
Keep it simple.
0
Upendra Pratap Shahi11y ago
private void Form1_Load(object sender, EventArgs e)
{

var month= new Dictionary < string, string > ();
month["1"] = "January";
month["2"] = "February";
month["3"] = "March";
month["4"] = "April";
month["5"] = "May";
month["6"] = "June";
month["7"] = "July";
month["8"] = "August";
month["9"] = "September";
month["10"] = "October";
month["11"] = "November";
month["12"] = "December";
comboBox1.DataSource = new BindingSource(month, null);
comboBox1.DisplayMember = "Value";
comboBox1.ValueMember = "Key";

}
0
Pankaj Kumar Choudhary11y ago
hello @Abiather you can use Dictionary for this
Dictionary month = new Dictionary

month["January"] = 1;
month["February"] = 2;
month["March"] = 3;
month[ "April"] =4;
month[ "May"] =5;
month["June"] = 6;
month["July"] = 7;
month["August"] = 8;
month["September"] = 9;
month["October"] = 10;
month["November"] = 11;
month["December"] = 12;

comboBox1.DataSource = new BindingSource(month, null);
comboBox1.DisplayMember = "Key";
comboBox1.ValueMember = "Value";
0
Sujeet Suman11y ago
Abiather please try following code once-

private void Form1_Load(object sender, EventArgs e)
{

      var month= new Dictionary < string, string > ();

      month["1"] = "January";
      month["2"] = "February";
      month["3"] = "March";
      month["4"] = "April";
      month["5"] = "May";
      month["6"] = "June";
      month["7"] = "July";
      month["8"] = "August";
      month["9"] = "September";
      month["10"] = "October";
      month["11"] = "November";
      month["12"] = "December";

      comboBox1.DataSource = new BindingSource(month, null);
      comboBox1.DisplayMember = "Value";
      comboBox1.ValueMember = "Key";
}
0

Bhushan Bhasme11y ago

hi abiather ,

you need tobind your combobox like

dropdownlist1.datasource = DT;
 dropdownlist1.datatextfield = "MonthName";
 dropdownlist1.datavaluefield = "MonthId";
 dropdownlist1.databind()