Team,I have following requirement.I have 2 tablesStudentID(PK), Name, Gender(FK), Stream(FK) ( FK are referenced to Options table)OptionsID(PK), Name, ValueSample ValuesOptionsID Name Value1 Gender Male2 Gender Female3 Stream MCA4 Stream MBAStudentID Name Gender Stream1 ABC 1 32 DEF 1 43 GHI 2 34 JKL 2 4I have 2 pages1) 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.