combobox

Question

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.

Jaipal Reddy · Answer

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); }

theLizard · Answer

int j = -1; string[] m = { January February March April ... }; for (int i = 0; i { if (m[i] == comboBox1.Items[comboBox1.SelectedIndex]) { j = i + 1; break; } } Keep it simple.

Upendra Pratap Shahi · Answer

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; }

Pankaj Kumar Choudhary · Answer

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;

Sujeet Suman · Answer

Abiather please try following code once- private void Form1_Load(object sender EventArgs e) { var month= new Dictionary (); 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; }

Bhushan Bhasme · Answer

hi abiather  you need tobind your combobox like dropdownlist1.datasource = DT; dropdownlist1 .datatextfield = MonthName; dropdownlist1 .datavaluefield = MonthId ; dropdownlist1 .databind()