update data using foreach loop MVC

Question

I have a update stored proc that updates the DisplayTestimonials field in the database based on what the users checks on the form. How would I update the checked field in the database in my controller? I guess i would have to use controller to call that update stored procedure, right? I am not sure how would i pass the values from a foreach loop in a controller. Any help?

This is my View.

@model Models.SurveyTestimonials

@{
    Layout = "~/CustomViews/cap/Shared/_DealerLayout.cshtml";
}
@section Tags {

        @Html.UserControl("Header", new { id = Model.Channel.ChannelId })

}

@section Menu {
    @Html.ActionLink("Premier Dealer", "Index", "Premier", new { area = "Apps" }, new { })
}      
<h2>Manage Survey Testimonials</h2>
@using (Html.BeginForm())
{
<div>
<table>
    <thead>
        <tr>
            <td>Select</td>
            <td>First Name</td>
            <td>Last Name</td>
            <td>Testimonial</td>
        </tr>
    </thead>
@foreach (var testimonials in Model.Testimonials)
{
    <tr>
        <td>@Html.CheckBox("" + testimonials.DisplayTestimonials)
            @Html.Hidden(testimonials.ResponseId.ToString())
        </td>
        <td>@Html.Label(testimonials.FirstName)</td>
        <td>@Html.Label(testimonials.LastName)</td>
        <td>@Html.Label(testimonials.Question5Answer)</td>
    </tr>   
}
<tr>
    <td colspan="3">
        <input type="submit" id="Submit" value="Save" class="PremireButton" />
    </td>
</tr>
</table>
</div>
}

Kuvalda.Spb.Ru · Accepted Answer · 2011-02-21 15:05:34Z

1

To bind collections to your model and pass it to controller you need index values in html-form. Read this blogposts for example: Phil Haack - Model Binding To A List and nmarun - ASP.NET MVC 2 Model Binding for a Collection.

answered Feb 21, 2011 at 15:05

Kuvalda.Spb.Ru

5434 silver badges6 bronze badges

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

Comments

Dmitry S. · Accepted Answer · 2011-02-21 15:04:20Z

0

You did not show the Html.BeginForm("MyMethod", "MyController") view code so I am going to use generic names.

You would need a controller action method as such:

public ActionResult MyMethod(MyModel model)
{
    foreach (var t in model.Testimonials)
    {
       if (t.DisplayTestimonials)
       {
           // do update logic
       }
    }
}

answered Feb 21, 2011 at 15:04

Dmitry S.

8,5532 gold badges41 silver badges53 bronze badges

2 Comments

bladerunner Over a year ago

I get an error on the foreach loop.System.NullReferenceException: Object reference not set to an instance of an object.

bladerunner Over a year ago

Also, i have updated my post to include the full code for View.

Collectives™ on Stack Overflow

update data using foreach loop MVC

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related