how to bind drpdownlist from the oracle db in mvc ?

Question

hi frnds

i have a fields in data base like

USER_ID VARCHAR2(100 CHAR)

USER_NAME VARCHAR2(250 CHAR)

ROLE_ID NUMBER(38,0) No

and some data filled in data base .

now i want bind dropdown list from the data base and dropdown should be display data

dont want to use entity framework.here we can use procedure in oracle

so please help on this how to do this in mvc

Suvendu Shekhar Giri · Answer

So what is the problem here? What have you tried so far?

Amit Kumar · Answer

Hi First Create a model with these two filed. public class BindDropdown { //Get dropdown selected values public int SelectedUserId{set;get;}; //Dropdown bind variables public int UserId{set;get;}; public string UserName{set;get;}; } Suppose you list name is bindUserName If you want to bind USER_NAME and USER_ID in dropdown then select these two fileds from datatbase using procedure. After getting data in datatable from procedure then bind it (using for or foreach loop) in list of BindDropdown class and return it view. In View : @Html.DropDownListFor(x => x.SelectedUserId new SelectList(Model.bindUserName UserId UserName new { @style = width:99% })

Anjali Khan · Answer

here m not able to bind dropdown list