CRUD Operations in MVC4

Riddhi Valecha

8y1.2k.NET

CRUD Operations in MVC4

1. Connection String in web.config file.
2. Class - DBConnections.cs - In Model Folder.
3. Use MVC1.Models in Controller - HomeController
4. Bind data from database in datatable.
5. Load it in Dropdownlist. (Html Helper)
6. Make DDL - Searchable and Single Selection
6. On selection of the value of DDL1, the other dropdownlist will populate.
7. Insert all values on submit button to database.
8. There are 3 Dropdownlists, 4 textboxes, and 2 jquery dates.

Please guide me to complete this.

I need to do this is ASPX Engine.

4 Replies

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

Riddhi Valecha8y ago
Hi.. Also.. For all server-side controls like button, checkbox, textbox, how do we write events in MVC ?
E.G - I have a checkbox - <%= HTML.Checkbox("chkbx") %> (ASPX Engine)..
Now, say I have to write a code on Checkbox_SelectChangeIndex ..
Say - If a user selects the checkbox,then I want 3 controls to be disabled.
How do I do that?
Also..For other events - Textbox_TextChangedEvent, Dropdownlist - SelectIndexChange Event, how to write events in MVC Controls ?
Please guide.
Jignesh Trivedi8y ago
Hi,
Hope you doing good.

Please refer following links for casecade dropdown
https://www.c-sharpcorner.com/UploadFile/4d9083/creating-simple-cascading-dropdownlist-in-mvc-4-using-razor/

and following link to save to data in to database

https://www.c-sharpcorner.com/UploadFile/009464/how-to-save-selected-data-of-dropdown-list-to-database-in-as/

Hope this will help you
Riddhi Valecha8y ago
Hi,
I had visited this link before posting the post for MVC4.
I have a model class - DBClass.

I have functions returning the datatable.

I need to bind 2 dropdownlists in one view.

I also have JSON Results from where I can populate the dropdownlists.

Please Guide... Its Very IMP and URGENT For me ..

How do I do it?

In the RouteConfig.cs file, we can put just one controller as default.

Just like in ASP.NET 3 tire, we could bind multiple dropdownlists on page load, same way I need to bind 3 dropdownlist on one view.

I have to create a simple registration page.

-----------

I have a DBClass.cs file in Model -> with 2 methods -

public datatable GetUsers(); public datatable GetSubjects(); - Data loaded from sql server.
Working perfectly right.

In Views, I have - GetUsers -> Empty View ->

Here I need to populate 2 dropdownlists - Users, and Subjects.

In Controller -
I have 2 methods -
public ActionResult GetUsers(DBClass dbc) { return view} ; public ActionResult GetSubjects(DBClass dbc) {return view};
------------------
In RouteConfig - Default action is - GetSubjects()

Hello all... Please help me out....

Its really urgent and imp..
Piyush Pansuriya8y ago
Hello,
Please go through the below link:
https://www.pluralsight.com/guides/asp-net-mvc-populating-dropdown-lists-in-razor-views-using-the-mvvm-design-pattern-entity-framework-and-ajax