C# MVC SQL database

Question

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

Kunal Gupta · Answer

u mean...dc.savechanges() is not required?

Nitin Sontakke · Answer

Possible to post code of dc.SaveChanges()?

Kunal Gupta · Answer

Thanks Nitin...but still sir i m getting an error in saving....i hv understood ur point but could not able to get out from this query

Nitin Sontakke · Answer

Notice the commented line above. That was returning SelectList but now it is return List that's why the error. The listOfDiscs must be of data type List . That's what the error means!

Kunal Gupta · Answer

can i show u Model view controller of my application

Kunal Gupta · Answer

[This is the error] The ViewData item that has the key 'Status_Description' is of type 'System.Collections.Generic.List`1[[System.String mscorlib Version=4.0.0.0 Culture=neutral PublicKeyToken=b77a5c561934e089]]' but must be of type 'IEnumerable '.

Kunal Gupta · Answer

this is the source code of my application..

Nitin Sontakke · Answer

What is the error?

Nitin Sontakke · Answer

Possible to post code of dc.SaveChanges()?

Kunal Gupta · Answer

thanku sir....but i am not able to save the value in a database..error is coming..so what should i do now....for that i am showing u the codes that i am trying to do...so that where i m doing mistake..should get clearify...

Nitin Sontakke · Answer

What do you mean by I have codes? Do you have a source code? There is no need to get confused. It is very simple. Just remember one thing everything (front-end database etc.) has it's own area of control. It doesn't care how things are represented out-side it's control area. Thisis what is calledABSTRACTION. So SQL Server doesn'tcare how objects are represented and front-end doesn't care if data is coming from SQL Server or Oracle or WebService.

Kunal Gupta · Answer

See this:

Kunal Gupta · Answer

see this code...not able to save values in a database..please make it correct

Kunal Gupta · Answer

frankly saying...i m confused now...i have a codes...can u please explain me with that codes

Nitin Sontakke · Answer

Try not to get confused between the object model and db model. You can have StatusMasterModel as a property of RoleMasterModel. While saving send entire RoleMasterModel instance to aprocedure. There you can retrieve all the information from these models and pass as a parameters to the stored procedure. For example you can get status from RoleMasterModel.StatusMasterModel.Status_Id Hope it helps. If not please let us know.

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