c# - Update Values in Database - MVC -

im using sortable jquery plugin, because want user can choice order of images showing in view.

for have controller sends data partialview.

how can make post controller update table in database?

note: in moment controller don´t receive data. haven´t figured out wrong

someone can me this?

thanks in advance:

here code:

in partialview:

@(html.beginform("updateorder", "admin", formmethod.post)){             <div id="order">                 <ul id="sortable">                      @foreach (var p in viewbag.images)                     {                                    <li id="@html.attributeencode(p.filename)">                             <img src="~/files/@p.filename"/>                         </li>                      }                 </ul>             </div>          } 

controller:

if (modelstate.isvalid) {     using (sqlconnection cn = new sqlconnection(system.configuration.configurationmanager.connectionstrings["defaultconnection"].connectionstring))     {          sqlcommand cmd;          system.text.stringbuilder sql = new system.text.stringbuilder();          sql.append("update image set myfilename=??? order asc");           cn.open();          cmd = new sqlcommand(sql.tostring(), cn);          cmd.parameters.add(??????????).value = ;           cmd.executenonquery();           cn.close();      } }       return view(); 

are looking this?

sqlcommand comm = new sqlcommand("update customers set name=@name id=@id", con; comm.parameters.addwithvalue("@name", "john"); comm.parameters.addwithvalue("@id", id); 

for passing data view controller take @ following links:
asp.net mvc 3 razor: passing data view controller
asp.net mvc passing multiple parameters view

i have created backend website, e.g. can add, edit, delete events. snippet in view events looks this:

<div id="tabs-2" class="ui-widget-content">     <h2>         events</h2>     <p>         @html.actionlink("create new event", "eventcreate")     </p>     <table id="tableevent">         <tr>             <th>                 event             </th>             <th>                 date             </th>             <th>                 day of week             </th>             <th>             </th>         </tr>         @foreach (var e in viewbag.events)         {             <tr id="@e.eventid">                 <td>                     <h4>@e.eventname</h4>                 </td>                 <td>                     <h4>@string.format("{0:d}", e.datum)</h4>                 </td>                 <td>                     <h4>@e.tag</h4>                 </td>                 <td>                     @html.actionlink("löschen", "eventdelete", new { id = e.eventid })                 </td>             </tr>         }     </table> </div> 

i pass id controller in actionlink , call eventdelete:

[authorize] public actionresult eventdelete(int id) {     repevent.delete(id);     return redirecttoaction("main"); } 

now have id of event , can whatever want. (in case, delete event associated id.

public void delete(int id) {     using (kigadbentities db = new kigadbentities())     {         event event = db.event.singleordefault(e => e.eventid == id);         if (event != null)         {             db.event.remove(event);             db.savechanges();         }     } } 

i hope helps you!