Databases
StackOverflow2013
Postsdbo
POsaving text box string value to database c#
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POsaving text box string value to database c#
    primarykey
    data
    text
    <p>I have a textbox in which the user can enter their desired username and save it. Once they save it and they happen to revisit their profile page that textbox should be populated with the last username they saved to display and the user will still have the ability to change it and resave. I am fairly new to this and not sure how to start this properly. I am using vs 2012 asp.net mvc 4 c#. Here is my code so far: </p> <pre><code> @model School.Models.StudentNameModel @using (Html.BeginForm("_StudentNamePartial", "Profile")) { @Html.AntiForgeryToken() @Html.ValidationSummary() &lt;fieldset&gt; &lt;ol&gt; &lt;li&gt; @Html.LabelFor(m =&gt; m.StudentName) @Html.DisplayFor(m =&gt; m.StudentName) @Html.TextBoxFor(m=&gt;m.StudentName) &lt;button type="button" value="save" /&gt; &lt;/li&gt; &lt;/ol&gt; &lt;/fieldset&gt; </code></pre> <p>}</p> <p>This is my Model: </p> <pre><code> public class StudentNameModel { [Display(Name = "Student Name")] public string StudentName{ get; set; } } </code></pre> <p>My controller:</p> <p>GET - To get the student name from database if one exists. </p> <pre><code>[HttpPost] public ActionResult _StudentNamePartial(int id) { id = WebSecurity.CurrentStudentId; var model = new StudentNameModel(); using (var db = new StudentsDataContext()) { var result = (from u in db.Students where u.ID == id select u.StudentName).FirstOrDefault(); if(result != null) model.StudentName= result; } return View(model); } </code></pre> <p>POST - This is where i want to save the new username for the student</p> <pre><code>[HttpPost] public ActionResult _StudentNamePartial(StudentNameModel model) { if (ModelState.IsValid) { using (var db = new StudentDataContext()) { try { } catch (Exception) { throw; } } return RedirectToAction("ProfileAccount"); } return View(model); } </code></pre> <p>Also i am having trouble that when i am displaying the username it is not hitting my <code>Action</code> method and it always reports that the Object reference is null. Any help will be great. Thanks :D</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. US072et
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POsaving text box string value to database c#
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POsaving text box string value to database c#
      1. This table or related slice is empty.
      1. VTDownMod
    1. COYou have the `HttpPost` attribute on your controller action where you say it's a `GET`. Also, you shouldn't be using the `Html.DisplayFor` since you're not using a template.
      singulars
      1. POsaving text box string value to database c#
      1. USCAbbott
    2. CO@CAbbott - i removed the `HttpPost` but i am still not getting a value to show. Also instead of `Html.DisplayFor` what should i be using? I tried `@(Model.StudentName)` but i always get the error of the object being null. Why isn't it hitting my Action method?
      singulars
      1. POsaving text box string value to database c#
      1. US072et
    3. CO@CAbbott I have this as a partial view so that the part of the username is in a view called `@Html.Partial("_StudentNamePartial")` and then it displays the model and getting the name by `@using(Html.BeginForm("_StudentNamePartial", "Profile")) {..}`
      singulars
      1. POsaving text box string value to database c#
      1. US072et
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload