ASP.NET MVC using jquery

Y G

9y1.1k

Can anyone please tell

1. How to bind the values of two database tables that are in relation(parent child relationship) to a single html table using ASP.NET MVC

2. first name : textbox

last name : textbox

full Name: ?????

Can anyone please tell me when the end user enter the firstname and last name those values must be binded and displayed on the screen as full name(user should not enter the full name)

2 Replies

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

Mobeen Rashid9y ago
Follow below simple steps
1. Create View Model class that contains public properties with names same as the column names that your both tables have, you can choose whatever the name you like.
2. Create a view (.cshtml) and strongly type that to view model.
3. Now read your values from your tables and fill them in a view model object.
4. Pass view model object to view through controller and your job is done
Now ASP.NET MVC default model binder will bind your view model object to Model property in view where you can access it.

“Make sure you strongly type the view with your view model otherwise nothing will be binded to view”
Manas Mohapatra9y ago
Find your solution below:

1. Create a custom entity type and then bind data to the entity from Database. And pass the entity object to view to display it. Follow below link:

http://www.c-sharpcorner.com/article/display-multiple-tables-data-in-single-view-from-database-in/

2. Use below javascript code to display your full name:
$(document).ready(function(){
   //attachwiththeidofnames
   $("#txtFirstName").bind("change", DisplayFullName);
   $("#txtLastName").bind("change", DisplayFullName);
});
functionDisplayFullName(){
   $("#txtFullName").val($("#txtFirstName").val() +" "+ $("#txtLastName").val());
}