how to bind drpdownlist from the oracle db in mvc ?

Anjali Khan

9y931.NET

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

3 Replies

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

Suvendu Shekhar Giri9y ago
Accepted answer
So what is the problem here?
What have you tried so far?
Amit Kumar9y ago
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 Khan9y ago
here m not able to bind dropdown list