3
Reply

Need help on MVC without EDM

SIVA

SIVA

Feb 4 2014 4:27 AM
1.1k
Team,

I have following requirement.
I have 2 tables
Student
ID(PK), Name, Gender(FK), Stream(FK) ( FK are referenced to Options table)
Options
ID(PK), Name, Value

Sample Values
Options
ID     Name         Value
1      Gender       Male
2      Gender       Female
3      Stream       MCA
4      Stream       MBA
Student
ID    Name    Gender    Stream
1     ABC        1              3
2     DEF        1              4
3     GHI        2              3
4     JKL         2              4

I have 2 pages
1) Add New Record
- For Gender & Stream will have dropdowns and values will be loaded from database.
2) Search
- Filter panel with data in Grid below.
- Filter panel contains Name(Textbox), Gender (DDlist), Stream(DDlist). When user select the proper search criteria and say search the grid will updated with corresponding records.
This is needed without EDM 
Please provide me code sample for this.

Answers (3)