vb.net - Is there an alternative method to using 15 If statements? -

-

i have 15 items in combobox , when user selects item want present different in textbox.

at moment have:

if cb_dropdown.selectedindex = 0     rtb_sql.text = "update access set accessdesc = 'less 5' accessid < '5'" else     if cb_dropdown.selectedindex = 1         rtb_sql.text = "update access set accessdesc = 'more 5' accessid > '5' , < '10' "     else         if cb_dropdown.selectedindex = 2             rtb_sql.text = ""

etc....

is there nicer , more methodical way approach looks quite scruffy?

yes, called select.

select case cb_dropdown.selectedindex     case 0 4         rtb_sql.text = "update access set accessdesc = 'less 5' accessid < '5'"     case 5         rtb_sql.text = [...]     case else         rtb_sql.text = [...] end case

although in case think looking < (less than) , > (greater than).

if cb_dropdown.selectedindex < 5     rtb_sql.text = "update access set accessdesc = 'less 5' accessid < '5'" elseif cb_dropdown.selectedindex < 10     rtb_sql.text = "update access set accessdesc = 'more 5' accessid > '5' , < '10' " end if

not sure trying though. maybe if explain in more detail can provide better answer. let me take wild guess:

dim n integer = cb_dropdown.selectedindex * 5 rtb_sql.text = "update access set accessdesc = 'more " + n + "' accessid > '" + n + "' , < '" + (n+6) + "' "

this give following result based on selectedindex:

  • 0 = 1 including 5
  • 1 = 6 including 10
  • etc...

if want shift down 1 (include 0 , not 5 in first batch) change > >= , 6 5.


Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5); ...
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:...
Read more