Insert multiple rows into a table in asp.net MVC

Question

Hi I have a the following scenario

Table - Items
    id int (PK),
    name varchar(100)

Table - Category
    id int (PK),
    name varchar(100)

Table - Category_item
    category_id int (FK),
    item_id int (FK)

I'm using Asp.Net MVC and Entitydatamodel. In the view I have a dropdown list to show the categories and a check boxes to display item.

I want to insert into the Table - Category_item when i select the category and curresponding items. How can i do it? How can I pass the values from the view to the controller?

Sonia · Accepted Answer · 2011-03-10 13:10:49Z

1

The anwser is that it depends. But the general case is (RAZOR)

@Html.DropDownList(category, db.Categories.Select(cat => new SelectListItem() {Text = cat.Name, Value = cat.Id, Selected = (false/true) }).ToList());

You can use Html.DropDownListFor and then the Save action will already be bounded with correct value. 'db' is the model context.

answered Mar 10, 2011 at 13:10

Sonia

1,0542 gold badges13 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mukesh Over a year ago

For Items I cant use dropdown because it is a one - many relation. I'm using checkbox for showing items. How can i get those values in the view?

Sonia Over a year ago

In that case you should use Html.CheckBox("categories", [true/false] , new { value = category.id}) for each category and on the controller side have a parameter named "categories" of type IList<[idtype]> Where idtype is the type of the id e.g. int.

Collectives™ on Stack Overflow

Insert multiple rows into a table in asp.net MVC

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related