Asp.net MVC functionality that edits multiple records with one field.

Question

2.00/5 (2 votes)

See more:

I want to create a functionality in my Asp.net MVC website that enables users to tick a checkbox on the index page where records are listed and it redirects them to a page, where they can type in a surname in one text box and when they click on the submit button, all selected records are updated with that same surname.

I haven't got a clue as to how this can be implemented. I would really appreciate it if someone could give me a few pointers.

Thanks :)

What I have tried:

I have implemented the checkbox on the view, but I don't know how to get multiple ids from the checkboxes and to use them in another view

Posted 14-Sep-20 20:18pm

Member 13029506

Add a Solution

Comments

F-ES Sitecore 15-Sep-20 5:31am

ids aren't submitted as part of the form. One way of doing this is to make sure the checkboxes all have the same "name" and the "value" of the checkbox will be the id of the record it represents. When you submit the form the value of the checkbox field will be all the ids comma separated, so "1,2,3,4". Store these values in the Session so you can recall them on your update page. If you can't get model binding to convert the comma list to an array of ids automatically you can do it yourself with the string.Split function. For each id execute an update statement, or you can keep the ids comma separated and use the "IN" SQL clause to batch update them;

update [table] set [surname] = 'name' where ID in (1,2,3,4)

[no name] 15-Sep-20 10:07am

It's up to you; i.e. you write code. You have the selections and the name; you write the update query using the (database) keys of the selections.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)