Need help on MVC without EDM

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.

3 Replies

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

Jaganathan Bantheswaran12y ago
Did you checked this link?
http://www.c-sharpcorner.com/tags/1/MVC
SIVA12y ago
Jaganathan, I tried by taking reference in net. But no use. So I need to step by step procedure or else project for my reference.
Jaganathan Bantheswaran12y ago
First create a project & try yourself. If you have any question then ask again.

To get started,

http://www.c-sharpcorner.com/tags/1/MVC