c#, MVC 4 asp.Net, SQL

Kunal Gupta

10y758Learn iOS Programming

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

5 Replies

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

Kunal Gupta10y ago
and then value get save in Role_Master_Table
whereRole_Master_Table contains three coloumns
a. Role_Id(Identity,Primary key)
b. Role_Desc
c. Status
Kunal Gupta10y ago
Two tables are there

1. Status_Master
a. Status_Id(Identity,Primary key)
b. Status_Desc.
c. Remarks
2. Role Master
a. Role_Id(Identity,Primary key)
b. Role_Desc
c. Status (wants for Dropdown list)

Here Model is [Status_Master_Model] Here Modelis [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 Srivastava10y ago
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 Gupta10y ago
not working sir...this is for drop down list value selected + other two coloumn is also there
Bikesh Srivastava10y ago
Hi Kunal,
You are doing something wrong.
Please use this code.like this.
privatevoidinsertData()
{
//HereTestEntitiesistheclasswhichisgivenfrom"Saveentityconnectionsettinginweb.config"
TestEntitiescontext=newTestEntities();
//Createanewemployee
EmployeeobjEmployee=newEmployee();
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/