How add data in asp.net mvc?

Question

If I add data to table witch has no relationships, it's all good: data is adding. But if table have relationships, this is something wrong

Here is my project, what i mean is, for example AddSt in RouteController. http://zalil.ru/32249903 Here is controller:

[HttpGet]
    public ActionResult AddSt(int RouteId)
    {
        var routeDetails = (from rd in db.Route
                            join rdd in db.RouteDetail
                            on rd.RouteId equals rdd.Route.RouteId  ///check
                            where rd.RouteId == RouteId
                            select rdd).FirstOrDefault();
        return View(routeDetails);
    }

    [HttpPost]
    public ActionResult AddSt(RouteDetail rd)
    {
        try
        {

            if (ModelState.IsValid)
            {
            db.AddToRouteDetail(rd);
            db.SaveChanges();
            return RedirectToAction("Index");
            }
        }
        catch (Exception e)
        {
            ModelState.AddModelError("Error!", e);
        }
        return View();
    }

and view:

 <% using (Html.BeginForm("AddSt","Route")) {%>
    <%= Html.ValidationSummary(true) %>

    <fieldset>
        <legend>Fields</legend>



        <div class="editor-label">

        </div>
        <div class="editor-field">
            <%= Html.TextBoxFor(model => model.Route.RouteId)%>
            <%= Html.TextBoxFor(model => model.Station)%>
        </div>

        <p>
            <input type="submit" value="Create" />
        </p>
    </fieldset>

<% } %>

Why I can't write model => model.RouteId ???? What's wrong? Why TrainSheduleDBEntities table RouteDetail doesn't generate field RouteID ?

1. ModelState.AddModelError("Error!", e); // security risk 2. Why are you using L2S, use EF. 3. Go thru Creating an Entity Framework Data Model for an ASP.NET MVC Application By Tom Dykstra to understand relationships. 4. Use Razor — RickAndMSFT
– RickAndMSFT, Commented Dec 12, 2011 at 17:03

Tony Hopkinson · Accepted Answer · 2011-12-12 13:07:48Z

1

You are only selecting RouteDetail (rdd)

So you want model.RouteId

Just stick a debug on the addst action. Have a look what's in rd.

I'm guessing that there's no valid routeid in it.

edited Dec 12, 2011 at 13:07

answered Dec 11, 2011 at 18:31

Tony Hopkinson

20.4k3 gold badges35 silver badges40 bronze badges

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

6 Comments

DPS Over a year ago

[HttpPost] public ActionResult AddSt(RouteDetail rd) you must see THIS! it's not working when i insert in db!

Tony Hopkinson Over a year ago

So RouteDetail has a property of type Route then does it, and is populated when. Only going by the code you've posted, and then havinga bit of guess from at what might be in what you haven't. As in the RouteDetail class. Did you try my suggestion?

Tony Hopkinson Over a year ago

Post the basics of RouteDetail class, especially the bit that says public Route Route....

DPS Over a year ago

sorry, i don't understand what you are saying. i'mm russian, i didn't know english well(

DPS Over a year ago

I'm using Ado.net autogenerating model from DB

|

Collectives™ on Stack Overflow

How add data in asp.net mvc?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related