How to save the selected value of dropdownlist in DB

Hi everyone!!

I am usin MVC 1.0 anc C#.

I want to use a dropdownlist to display some data, and select one of them, then press the button "Create" and the value goes to the DB.

i tried to do sth, but all what i did, is to display the data in the dropdownlist in the view, But for saving the selected value, i ally don't know how to proceed, am on this more than 6h today, i am totalled !!

Please if Some one has a simple solution, i am new developper in MVC, so dont be Harsh ;)

here is the code:

for the view :

<p>
                <label for="id_imputation">Imputations:</label>
                <%= Html.DropDownList("imputations", (IEnumerable<SelectListItem>)ViewData["imputations"])%>
                

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


    <% } %>


    <div>
        <%=Html.ActionLink("Back to List", "Index") %>
    </div>


</asp:Content>

and the COntroller :

        public ActionResult Create()
        {

           

            var impu = from im in _db.T_imputation select im.id_imputation;
            ViewData["imputations"] = new SelectList(impu.ToList());
            ViewData.Model = new T_Pointage_Materiel();
            return View();
        } 

        //
        // POST: /PointageMateriel/Create

        [AcceptVerbs(HttpVerbs.Post)]
        public ActionResult Create([Bind(Exclude = "id_pointage")] T_Pointage_Materiel PMACreer)
        {
            try
            {
                // TODO: Add insert logic here
                UpdateModel(PMACreer);
                //PMACreer.T_imputation.id_imputation = ;
                
                PMACreer.T_Materiel.Num_anael = "1";
                _db.AddToT_Pointage_Materiel(PMACreer);
                
                _db.SaveChanges();
                ViewData["rr"] = PMACreer.Compteur;
                return RedirectToAction("Index");
            }
            catch
            {
                return View();
            }
        }

Best regards !

and thanks a lot !

Re: How to save the selected value of dropdownlist in DB

T_Pointage_Materiel has a property named "imputations", like

<%= Html.DropDownList("imputations", (IEnumerable<SelectListItem>)ViewData["imputations"])%>

Re: How to save the selected value of dropdownlist in DB

When you're passing a model from a form to the controller, the dropdown will already have updated the class, providing the binding was done properly.

assuming your PMACreer class has a variable imputationsId, then that is what you should be naming your dropdown list.

<%= Html.DropDownList("imputationsId", (IEnumerable<SelectListItem>)ViewData["imputations"])%>

that is the desired method. While I admire your persistance, let's also not forget guys & gals that MVC is built on ASP.NET & HTML.

You could have done Request.Form["controlName"].ToString() to also get the value.

ControlId's need to be named the same as the Model attribute they bind to ...

Re: How to save the selected value of dropdownlist in DB

Hi !

i fixed some lines , the code :

the controller code :

public ActionResult Create()
        {
          

             IEnumerable<SelectListItem> items = _db.T_Materiel.Select(c => new SelectListItem
             {
                  Value = c.Num_anael.ToString(),
                  Text =  c.Libelle
             });
            ViewData["imputations"] = items;
           

            return View();
        }
         

        //
        // POST: /PointageMateriel/Create


        [AcceptVerbs(HttpVerbs.Post)]
        public ActionResult Create([Bind(Exclude = "id_pointage")] T_Pointage_Materiel PMACreer)
        {
            try
            {
                // TODO: Add insert logic here
                UpdateModel(PMACreer);
                _db.AddToT_Pointage_Materiel(PMACreer);
                _db.SaveChanges();
                return RedirectToAction("Index");
            }
            catch
            {
                return View();
            }
        }

the View Code:

...

<p>
                <label for="id_imputation">Imputations:</label>
                <%= Html.DropDownList("Num_anael", (IEnumerable<SelectListItem>)ViewData["imputations"])%>
                
                
            </p>
            <p>
                <input type="submit" value="Create" />
            </p>
        </fieldset>

    <% } %>

    <div>
        <%=Html.ActionLink("Back to List", "Index") %>
    </div>

</asp:Content>

BUT , and there is always this #!§,% "but" , this returns an error:

<<L'exception System.NotSupportedException n'a pas été gérée par le code utilisateur Message="LINQ to Entities ne reconnaît pas la méthode « System.String ToString() », et cette dernière ne peut pas être traduite en expression de magasin." Source="System.Data.Entity" StackTrace: à System.Data.Objects.ELinq.ExpressionConverter.MethodCallTranslator.DefaultTranslator.Translate(ExpressionConverter parent,MethodCallExpression call) à System.Data.Objects.ELinq.ExpressionConverter.MethodCallTranslator.TypedTranslate(ExpressionConverter parent, MethodCallExpression linq) à System.Data.Objects.ELinq.ExpressionConverter.TypedTranslator`1.Translate(ExpressionConverter parent, Expression linq) à System.Data.Objects.ELinq.ExpressionConverter.TranslateExpression(Expression linq) à System.Data.Objects.ELinq.ExpressionConverter.MemberInitTranslator.TypedTranslate(ExpressionConverter parent, MemberInitExpression linq) à System.Data.Objects.ELinq.ExpressionConverter.TypedTranslator`1.Translate(ExpressionConverter parent, Expressionlinq) à System.Data.Objects.ELinq.ExpressionConverter.TranslateExpression(Expression linq) ...

<div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Data.Objects.ELinq.ExpressionConverter.TranslateLambda(LambdaExpression lambda, DbExpression input)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Data.Objects.ELinq.ExpressionConverter.TranslateLambda(LambdaExpression lambda, DbExpression input, DbExpressionBinding& binding)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Data.Objects.ELinq.ExpressionConverter.MethodCallTranslator.OneLambdaTranslator.Translate(ExpressionConverter parent, MethodCallExpression call, DbExpression& source, DbExpressionBinding& sourceBinding, DbExpression& lambda)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Data.Objects.ELinq.ExpressionConverter.MethodCallTranslator.SelectTranslator.Translate(ExpressionConverter parent, MethodCallExpression call)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Data.Objects.ELinq.ExpressionConverter.MethodCallTranslator.SequenceMethodTranslator.Translate(ExpressionConverter parent, MethodCallExpression call, SequenceMethod sequenceMethod)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Data.Objects.ELinq.ExpressionConverter.MethodCallTranslator.TypedTranslate(ExpressionConverter parent, MethodCallExpression linq)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Data.Objects.ELinq.ExpressionConverter.TypedTranslator`1.Translate(ExpressionConverter parent, Expression linq)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Data.Objects.ELinq.ExpressionConverter.TranslateExpression(Expression linq)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Data.Objects.ELinq.ExpressionConverter.Convert()</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Data.Objects.ELinq.ELinqQueryState.GetExecutionPlan(Nullable`1 forMergeOption)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.Mvc.Html.SelectExtensions.SelectInternal(HtmlHelper htmlHelper, String optionLabel, String name, IEnumerable`1 selectList, Boolean allowMultiple, IDictionary`2 htmlAttributes)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.Mvc.Html.SelectExtensions.DropDownList(HtmlHelper htmlHelper, String name, IEnumerable`1 selectList)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à ASP.views_pointagemateriel_create_aspx.__RenderContent2(HtmlTextWriter __w, Control parameterContainer) dans c:\Documents and Settings\Administrateur\Mes documents\Visual Studio 2008\Projects\DSSCOLAS2\DSSCOLAS2\Views\PointageMateriel\Create.aspx:ligne 54</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Control.Render(HtmlTextWriter writer)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Control.RenderControl(HtmlTextWriter writer)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à ASP.views_shared_site_master.__Render__control1(HtmlTextWriter __w, Control parameterContainer) dans c:\Documents and Settings\Administrateur\Mes documents\Visual Studio 2008\Projects\DSSCOLAS2\DSSCOLAS2\Views\Shared\Site.Master:ligne 72</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Control.Render(HtmlTextWriter writer)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Control.RenderControl(HtmlTextWriter writer)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Control.RenderChildren(HtmlTextWriter writer)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Page.Render(HtmlTextWriter writer)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.Mvc.ViewPage.Render(HtmlTextWriter writer)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Control.RenderControl(HtmlTextWriter writer)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> à System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)</div> <div style="position: absolute; left: -10000px; top: 1038px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> InnerException: </div> <div></div>

What is the problem here ? wow , i think that this framework was not a good deal, even a dropdowlist is so difficult to put on ! What about using textbox instead of dropdownlist, can u pleasegive me the solution, i am lacking time !

thanks for the help !

Re: How to save the selected value of dropdownlist in DB

sjfs00
Value = c.Num_anael.ToString(),

There are some clr methods that are not supported(http://msdn.microsoft.com/en-us/library/bb738681.aspx) ... like

sjfs00
Value =c.Num_anael

you can do like this - by creating new list

var items = _db.T_Materiel.Select(c).ToList< Put here type of c>;
IEnumerable<SelectListItem> itemsSelect =new List<SelectListItem>
foreach(var item in items)
{itemsSelect .Add(new SelectListItem
{
Value = c.Num_anael.ToString(),
Text = c.Libelle
});
}

Re: How to save the selected value of dropdownlist in DB

i did as you said :

public ActionResult Create()
        {
          

            var  items = _db.T_Materiel.Select(c).ToList<T_Materiel >;
            IEnumerable<SelectListItem> itemsSelect =new List<SelectListItem>
            foreach(var item in items)
            {itemsSelect.Add(new SelectListItem
                {
                 Value = c.Num_anael.ToString(),
                 Text =  c.Libelle
                });
            }

BUT : it says that it doesn't recognize "c"

and "foreach iz underligned" it says: "Une expression new exige que type soit suivi de (), [] ou {}" translation: "an expression new demand type to be followed by (), [] ou {}"

IMAGE:

Re: How to save the selected value of dropdownlist in DB

sorry , encore 4 modifs :

var items = _db.T_Materiel.Select(c=>c).ToList<T_Materiel >;

IEnumerable<SelectListItem> itemsSelect =new List<SelectListItem> ;

Value = item.Num_anael.ToString(),

Text = item.Libelle

Re: How to save the selected value of dropdownlist in DB

Still got problems, here is thescreenshot ... if you can show me what to do, because at this level i am just followig what you say ! :D

Re: How to save the selected value of dropdownlist in DB

sjfs00

Still got problems, here is thescreenshot ... if you can show me what to do, because at this level i am just followig what you say ! :D

And I apologize for the errors :

var items = _db.T_Materiel.Select(c).ToList<T_Materiel >();

List<SelectListItem> itemsSelect =new List<SelectListItem>;

Re: How to save the selected value of dropdownlist in DB

Hi, good morning !

I adjusted the code as you said, and know nothing is underlined in the controller, accohererding to the intellisense, it's perfect.

But i think there is something missing, you didn't use the Viewdata to grap information, and then send it to the dropdownlist.

And when i hit F5, there is an error when trying to use the action "Create" , it says something about Viewdata:

just for information, even if it s too late. : The field we want to access using the drop downlist, is a foreign key.

Thanks a lot for your interest Sir !!

Re: How to save the selected value of dropdownlist in DB

did you put

ViewData["imputations"] =itemsSelect ;

Re: How to save the selected value of dropdownlist in DB

Thanks a lot sir !

it seems to work , but actually not @ 100%

the code is perfect for view & 1/2 controller,

the dropdownlist, loads data and i can view the values i want, but when i click on the "Create Button" an error appears on the browser:

i think it's due to the POST Action !

Because i didn't mention anything concerning the 2 fields : (imputation + materiel)

here is the code Of the entire Action (Get + POST)

public ActionResult Create()
        {
          

            var  items = _db.T_imputation.Select(c=>c).ToList<T_imputation>();
           

            List<SelectListItem> itemsSelect =new List<SelectListItem>();
            foreach(var item in items)
            {itemsSelect.Add(new SelectListItem
                {
                 Value = item.id_imputation.ToString(),
                 Text =  item.Libelle
                });
            }
            ViewData["imputations"] = itemsSelect;






            var items2 = _db.T_Materiel.Select(c => c).ToList<T_Materiel>();


            List<SelectListItem> items2Select = new List<SelectListItem>();
            foreach (var item in items2)
            {
                items2Select.Add(new SelectListItem
                {
                    Value = item.Num_anael.ToString(),
                    Text = item.Libelle
                });
            }
            ViewData["Materiel"] = items2Select;
            

           

            return View();
        }
         

        //
        // POST: /PointageMateriel/Create


        [AcceptVerbs(HttpVerbs.Post)]
        public ActionResult Create( T_Pointage_Materiel PMACreer)
        {
            try
            {
                

                UpdateModel(PMACreer);
                _db.AddToT_Pointage_Materiel(PMACreer);
                _db.SaveChanges();
                return RedirectToAction("Index");
            }
            catch
            {
                return View();
            }
        }

Thanks e lot Sir for your Help !

Re: How to save the selected value of dropdownlist in DB

sjfs00
i think it's due to the POST Action !

Yes- but this is another error, related to routes, not to the dropdown.

What's the code for submit button and what's the code for the form ?

Re: How to save the selected value of dropdownlist in DB

I confess not understanding anything about what u ve just said , Routes?! i taught i was near :(

euh , okay , you asked me to show you the code for the submit button:

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">


    <h2>Create</h2>


    <%= Html.ValidationSummary("Create was unsuccessful. Please correct the errors and try again.") %>


    <%--<% using (Html.BeginForm()) {%>--%>
    <% using (Html.BeginForm("<create>", "<PointageMateriel>")) {  %>


        <fieldset>
            <legend>Fields</legend>
            <p>
                <label for="id_pointage">id_pointage:</label>
                <%= Html.TextBox("id_pointage") %>
                <%= Html.ValidationMessage("id_pointage", "*") %>
            </p>
            <p>
                <label for="Quantite">Quantite:</label>
                <%= Html.TextBox("Quantite") %>
                <%= Html.ValidationMessage("Quantite", "*") %>
            </p>
            <p>
                <label for="Compteur">Compteur:</label>
                <%= Html.TextBox("Compteur") %>
                <%= Html.ValidationMessage("Compteur", "*") %>
            </p>
            <p>
                <label for="Date_Pointage">Date_Pointage:</label>
                <%= Html.TextBox("Date_Pointage") %>
                <%= Html.ValidationMessage("Date_Pointage", "*") %>
            </p>
            <p>
                <label for="Tarif_Applique">Tarif_Applique:</label>
                <%= Html.TextBox("Tarif_Applique") %>
                <%= Html.ValidationMessage("Tarif_Applique", "*") %>
            </p>
            <p>
                <label for="Abattement_Applique">Abattement_Applique:</label>
                <%= Html.TextBox("Abattement_Applique") %>
                <%= Html.ValidationMessage("Abattement_Applique", "*") %>
            </p>
            <p>
                <label for="Bloque">Bloque:</label>
                <%= Html.TextBox("Bloque") %>
                <%= Html.ValidationMessage("Bloque", "*") %>
            </p>
            <p>
                <label for="id_imputation">Imputations:</label>
                <%= Html.DropDownList("imputations")%>
                

                

            </p>
            

            <p>
                <label for="num_anael">Matériel concerné:</label>
                <%= Html.DropDownList("Materiel")%>
                

                

            </p>
            

            

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


    <% } %>


    <div>
        <%=Html.ActionLink("Back to List", "Index") %>
    </div>


</asp:Content>

----------------------------------------------------------------

is there any file you d like to see ?

euh i don't have any idea about what are the routes for ...

thanks again and again sir for your valuable help .

can i suggest you a page where there is an example of saving a dropdownlist value in DB:

http://www.mikesdotnetting.com/Article/109/ASP.NET-MVC-Entity-Framework-One-to-Many-and-Many-to-Many-INSERTS

in this blog, they added some code lines in the POST, i "think" that we are missing this in my code...

thanks Sir !

Re: How to save the selected value of dropdownlist in DB

sjfs00
using (Html.BeginForm("<create>", "<PointageMateriel>"))

using (Html.BeginForm("create", "PointageMateriel"))

Re: How to save the selected value of dropdownlist in DB

hum hum , it becomes embarassing, sorry Sir for that .

but now with using (Html.BeginForm("create", "PointageMateriel")) the submit button click tries to do sth, but an error occurs saying: there is no viewdata item with key "..." .... here is the screen shot:

the code in the controlleris as followeing:

public ActionResult Create()
        {
          

            var  items = _db.T_imputation.Select(c=>c).ToList<T_imputation>();
           

            List<SelectListItem> itemsSelect =new List<SelectListItem>();
            foreach(var item in items)
            {itemsSelect.Add(new SelectListItem
                {
                 Value = item.id_imputation.ToString(),
                 Text =  item.Libelle
                });
            }
            ViewData["imputations"] = itemsSelect;






            var items2 = _db.T_Materiel.Select(c => c).ToList<T_Materiel>();


            List<SelectListItem> items2Select = new List<SelectListItem>();
            foreach (var item in items2)
            {
                items2Select.Add(new SelectListItem
                {
                    Value = item.Num_anael.ToString(),
                    Text = item.Libelle
                });
            }
            ViewData["Materiel"] = items2Select;
            

           

            return View();
        }
         

        //
        // POST: /PointageMateriel/Create


        [AcceptVerbs(HttpVerbs.Post)]
        public ActionResult Create( T_Pointage_Materiel PMACreer)
        {
            try
            {
                

                UpdateModel(PMACreer);
                _db.AddToT_Pointage_Materiel(PMACreer);
                _db.SaveChanges();
                return RedirectToAction("Index");
            }
            catch
            {
                return View();
            }
        }

and the view :

<%@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage<DSSCOLAS2.Models.T_Pointage_Materiel>" %>

<asp:Content ID="Content1" ContentPlaceHolderID="TitleContent" runat="server">
	Create
</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

    <h2>Create</h2>

    <%= Html.ValidationSummary("Create was unsuccessful. Please correct the errors and try again.") %>

   
    <% using (Html.BeginForm("create", "PointageMateriel")) {  %> 

        <fieldset>
            <legend>Fields</legend>
            <p>
                <label for="id_pointage">id_pointage:</label>
                <%= Html.TextBox("id_pointage") %>
                <%= Html.ValidationMessage("id_pointage", "*") %>
            </p>
            <p>
                <label for="Quantite">Quantite:</label>
                <%= Html.TextBox("Quantite") %>
                <%= Html.ValidationMessage("Quantite", "*") %>
            </p>
            <p>
                <label for="Compteur">Compteur:</label>
                <%= Html.TextBox("Compteur") %>
                <%= Html.ValidationMessage("Compteur", "*") %>
            </p>
            <p>
                <label for="Date_Pointage">Date_Pointage:</label>
                <%= Html.TextBox("Date_Pointage") %>
                <%= Html.ValidationMessage("Date_Pointage", "*") %>
            </p>
            <p>
                <label for="Tarif_Applique">Tarif_Applique:</label>
                <%= Html.TextBox("Tarif_Applique") %>
                <%= Html.ValidationMessage("Tarif_Applique", "*") %>
            </p>
            <p>
                <label for="Abattement_Applique">Abattement_Applique:</label>
                <%= Html.TextBox("Abattement_Applique") %>
                <%= Html.ValidationMessage("Abattement_Applique", "*") %>
            </p>
            <p>
                <label for="Bloque">Bloque:</label>
                <%= Html.TextBox("Bloque") %>
                <%= Html.ValidationMessage("Bloque", "*") %>
            </p>
            <p>
                <label for="id_imputation">Imputations:</label>
                <%= Html.DropDownList("imputations")%>
                
                
            </p>
            
            <p>
                <label for="num_anael">Matériel concerné:</label>
                <%= Html.DropDownList("Materiel")%>
                
                
            </p>
            
            
            <p>
                <input type="submit" value="Create" />
            </p>
        </fieldset>

    <% } %>

    <div>
        <%=Html.ActionLink("Back to List", "Index") %>
    </div>

</asp:Content>

I hope you re not bored by my case ...

i really need this to work.

Kind Regards !

Re: How to save the selected value of dropdownlist in DB

I suggest the following for

[AcceptVerbs(HttpVerbs.Post)]

public ActionResult Create( T_Pointage_Materiel PMACreer)

try

{

UpdateModel(PMACreer);

_db.AddToT_Pointage_Materiel(PMACreer);

_db.SaveChanges();

return RedirectToAction("Index");

}

catch(Exception ex)

{

ModelState.AddModelError("", ex.Message);

//copy the code to fill ViewData["imputations"] = itemsSelect; and ViewData["Materiel"] = items2Select;

//or,better ,put in a function

return View();

}

Re: How to save the selected value of dropdownlist in DB

Thank you first of all for your interest to my case, and for being so helpful, and to be the only one who cared so much

I put the code you told me in the POST,

but the :

[AcceptVerbs(HttpVerbs.Post)]
        public ActionResult Create( T_Pointage_Materiel PMACreer)
        {
            try
            {
                

                UpdateModel(PMACreer);
                _db.AddToT_Pointage_Materiel(PMACreer);
                _db.SaveChanges();
                return RedirectToAction("Index");
            }
            catch
            {


                //ModelState.AddModelError("",Ex.message);




                var items = _db.T_imputation.Select(c => c).ToList<T_imputation>();
           

                List<SelectListItem> itemsSelect = new List<SelectListItem>();
                foreach (var item in items)
                {
                    itemsSelect.Add(new SelectListItem
                    {
                        Value = item.id_imputation.ToString(),
                        Text = item.Libelle
                    });
                }
                ViewData["itemsSelect"] = itemsSelect;






                var items2 = _db.T_Materiel.Select(c => c).ToList<T_Materiel>();


                List<SelectListItem> items2Select = new List<SelectListItem>();
                foreach (var item in items2)
                {
                    items2Select.Add(new SelectListItem
                    {
                        Value = item.Num_anael.ToString(),
                        Text = item.Libelle
                    });
                }
                ViewData["Materiel"] = items2Select;
                return View();
            }
        }

Re: How to save the selected value of dropdownlist in DB

for help : i read in a forum that they put this in the post :

var articleTypeId = Request.Form["ArticleTypeID"];
  var categoryId = Request["CategoryID"];

to get the selected values from the view, and store them for exampl in a variable, and then put them in the model or sth like this ...

am nnot sure of what i say ..

Thanks !

Re: How to save the selected value of dropdownlist in DB

sjfs00

but the :

ModelState.AddModelError("", Ex.message);

You did not put, instead of

cath

the source :

catch (Ex as Exception)

And this is the cause that you do not see any error on

sjfs00
when i click on "Creat" button, it relods the page with the data i entred, but , nothing happens to the DB.