c# MVC 4 asp.Net SQL

Question

Not able to save value in a database..please correst this code

Kunal Gupta · Answer

and then value get save in Role_Master_Table where Role_Master_Table contains three coloumns a. Role_Id(IdentityPrimary key) b. Role_Desc c. Status

Kunal Gupta · Answer

Two tables are there 1. Status_Master a. Status_Id(IdentityPrimary key) b. Status_Desc. c. Remarks 2. Role Master a. Role_Id(IdentityPrimary key) b. Role_Desc c. Status (wants for Dropdown list) Here Mode l is [ Status_Master_Model ] Here Model is [ Role_Master_Model ] Question is in [Role_Master_Model] view i have to us Dropdown for column c i.e (Status) and bind the value from [Status_Master_Model] for column b i.e (Status_Desc.) Help me with codes

Bikesh Srivastava · Answer

Hi This is simple example how to insert value in database using entity framework. Please let me know complete logic whatever you want do.

Kunal Gupta · Answer

not working sir...this is for drop down list value selected + other two coloumn is also there

Bikesh Srivastava · Answer

Hi Kunal You are doing something wrong. Please use this code.like this. private void insertData() { //HereTestEntitiesistheclasswhichisgivenfromSaveentityconnectionsettinginweb.config TestEntitiescontext= new TestEntities(); //Createanewemployee EmployeeobjEmployee= new Employee(); objEmployee.name= EmployeeFour ; objEmployee.address= AddressFour ; //AddthecreatedEmployeeobjecttocontext. context.AddToEmployee(objEmployee); context.SaveChanges(); } If you are not understanding follow this link :- http://www.c-sharpcorner.com/UploadFile/8911c4/fetch-insert-update-and-delete-data-with-database-first-mode/

c#, MVC 4 asp.Net, SQL