How to Store Data into a table of SQL in MVC without model

Question

How can i store data from a form created in mvc razor view without a model class and entity framework , I have wrote a simple method but as in razor view i have

@Html.TextBox("txtPrice", null, new { @class = "form-control valid", @data_val = "true", @data_val_required = "Property Price is required" })

How to get this textbox value in my c# code either i have to use Query String or what else is the technique i am good with web forms and i web forms we have runat="Server" attribute to access the text box but in razor i do not know how to achieve this.

Mayank · Answer

[HttpPost] public ActionResult Index(string txtPrice) { return View(); }

Manas Mohapatra · Answer

You are getting 404 error(File not found) because SaveRecords() method returns return View(). It means it looks for SaveRecords.cshtml file as view. So better to provide the view name when you returns. return View(MyView); http://stackoverflow.com/questions/26359192/how-to-return-actionresult-with-specific-view-not-the-controller-name If it helps you please accept the answer.

Mangesh Gaherwar · Answer

[HttpPost] public ActionResult Create(FormCollection collection) { try { if (collection != null) { string userName = collection[txtdetails].ToString(); } // TODO: Add insert logic here return View(); } catch(Exception ex) { return View(); } } View ================================== @{ ViewBag.Title = Create; } Create @using (Html.BeginForm(Create Sample)) { @Html.TextBox(txtid111); }

Mark Tabor · Answer

I have that method present check the screen shot

Salman · Answer

Requested URL: /Property/SaveRecords i think In Property Controller there is no action method  SaveRecords  present. So please check at your end whethere SaveRecords method is present in Property Controller or not. thanks.

Mark Tabor · Answer

[HttpPost] when i add the httppost attribute above my method then it does not come to this method while i debug application it just say it did not come to my SaveRecords Method if i omit the httppost then i comes to debug point The resource cannot be found. Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed had its name changed or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly. Requested URL: /Property/SaveRecords Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.6.1055.0

Mark Tabor · Answer

i have checked that public ActionResult SaveRecords(FormCollection form) { if(form != null) { string principle = form[title].ToString(); } string Title=Request.QueryString[title]; String connectionString = Data Source=ASPKCO-DANISH\SQLEXPRESS1;Initial Catalog=PakeezaSodagran;Integrated Security=True;; SqlConnection conn = new SqlConnection(connectionString); conn.Open(); SqlCommand comm = new SqlCommand(insert into PropertyPosts(title) values( + Request.QueryString[title] conn); try { comm.ExecuteNonQuery(); // Request.QueryString[text] = null; } catch (Exception) { // MessageBox.Show(Not Saved); } finally { conn.Close(); } return View(); } and it is still null  i also checked the Request[title].toString(); it also null weather i and putting text in textbox and id is also same title

Mangesh Gaherwar · Answer

Hey Mark You can do something Like this string txtValue= Request[  txtPrice  ].ToString() And I am Hoping Your controller ACTION to be Like this [HttpPost] public ActionResult SaveRecords (FormCollection form) { string pricee= form[  txtPrice ].ToString(); }

Manas Mohapatra · Answer

You have different to get the values from views to controller. Try to use FormCollection object like below code: public ActionResult CalculateSimpleInterestResult(FormCollection form) { if(form != null) { string principle = form[title].ToString()); } } http://www.c-sharpcorner.com/UploadFile/3d39b4/getting-data-from-view-to-controller-in-mvc/

Mark Tabor · Answer

Dear Manas Mohapatra it did not solve the issue below is my code @using Prototyping.Ipsum @using Prototyping.Placeholdit @*@model IEnumerable *@ @using BusinessApplicationTemplate.Models @model BusinessApplicationTemplate.ViewModel.viewModelVm @{ Layout = ~/Views/Shared/_Layout.cshtml; } .nav-tabs a .nav-tabs a:hover .nav-tabs a:focus { outline: 0; } input[type=text] { border: 1px solid #CCC; width: 250px; padding: 5px 0px 5px 2px; -webkit-border-radius: 4px; -moz-border-radius: 4px; border-radius: 4px; display: inline-block; } .errorText { color: #cc0000; } .container { width: 100%; } .align-left { float: left; width: 50%; } .align-right { float: right; width: 50%; } @using (Html.BeginForm(SaveRecordsPropertyFormMethod.Post)) { Personal Employment Type and Purpose Purpose: Sale: @Html.RadioButton(type Sale new { @checked = true }) Rent: @Html.RadioButton(type Rent) Required : @Html.RadioButton(type Required) Property Type: @Html.DropDownListFor(x => x.PropertyTypes Model.PropertyTypes --Select-- new { @id = ddlPropertyTypes @class = dropdown1 @style = Width:100px; }) Property Detail Property Title @Html.TextBox(title null new { @class = form-control valid @data_val = true @data_val_required =  Property Title is required }) Price (in PKR) @Html.TextBox(txtPrice null new { @class = form-control valid @data_val = true @data_val_required = Property Price is required }) Plot/Land Area @Html.TextBox(txtArea null new { @class = form-control valid @data_val = true @data_val_required =  Plot/Land Area is required }) Unit Sq. Feet Sq. Yard Sq. Meter Acre Marla Kanal Covered Area @Html.TextBox(txtCoveredArea null new { @class = form-control valid @data_val = true @data_val_required = Covered Area is required }) Unit Sq. Feet Sq. Yard Sq. Meter Acre Marla Kanal Description Only 3500 characters remaining Property Location City: @Html.DropDownListFor(x => x.cities Model.cities --Select-- new { @id = ddlState @class = dropdown1 }) Contact Information Full Name * @Html.TextBox(txtFullName null new { @class = form-control valid @data_val = true @data_val_required = Full Name is required }) @* *@ Phone * +92 - @Html.TextBox(txtPhoneAdd null new { @class = form-control valid @data_val = true @data_val_required =  Phone is required }) @* *@ Fax @Html.TextBox(txtfax null new { @class = form-control valid @data_val = true @data_val_required =  Fax is required }) Mobile * +92 Code 321 322 323 300 301 302 303 304 314 315 320 - @* @Html.TextBox(txtCoveredArea6 null new { @class = form-control }) *@ @Html.TextBox(txtMobile null new { @class = form-control valid @data_val = true @data_val_required =  Mobile is required }) @* @Html.ActionLink(Submit submit Property)*@ @* @Html.ActionLink(Submit Now submit Property)*@ @* *@ @* *@ This is Employment Information Tab @Html.ValidationSummary() @* @Html.ActionLink(Create Create property)*@ @* *@ @* *@ } and my controller method is public ActionResult SaveRecords() { String connectionString = Data Source=ASPKCO-DANISH\SQLEXPRESS1;Initial Catalog=PakeezaSodagran;Integrated Security=True;; SqlConnection conn = new SqlConnection(connectionString); conn.Open(); SqlCommand comm = new SqlCommand(insert into PropertyPosts(title) values( + Request.QueryString[title]  conn); try { comm.ExecuteNonQuery(); // Request.QueryString[text] = null; } catch (Exception) { // MessageBox.Show(Not Saved); } finally { conn.Close(); } return View(); }

Manas Mohapatra · Answer

Follow below link that may help you: http://stackoverflow.com/questions/13162819/adding-additional-parameter-to-form-submit Note: If it doesn't resolve your problem provide the sample how you are submitting the form.

Mark Tabor · Answer

Property Title @Html.TextBox( title  null new { @class = form-control valid @data_val = true @data_val_required =  Property Title is required }) here is my code SqlCommand comm = new SqlCommand(insert into PropertyPosts(title) values( + Request.QueryString[title]  conn); this always gets null even in textbox i am typing something like sdfsdf

Mark Tabor · Answer

I want to get the textbox value in my code behind file  i have to use Text box instead of hidden field or other .

Salman · Answer

You can use hidden field or use a session and can use that same in controller.thanks.