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

Mark Tabor

9y3.7k.NET

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.

14 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mayank9y ago
[HttpPost]
public ActionResult Index(string txtPrice)
{
return View();
}
Manas Mohapatra9y ago
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 G9y ago
[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("txtid","111");

}
Mark Tabor9y ago
I have that method present check the screen shot
Salman Beg9y ago
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 Tabor9y ago
```
[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 Tabor9y ago
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 G9y ago

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 Mohapatra9y ago
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 Tabor9y ago
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";

}
@using (Html.BeginForm("SaveRecords","Property",FormMethod.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

Covered Area

@Html.TextBox("txtCoveredArea", null, new { @class = "form-control valid", @data_val = "true", @data_val_required = "Covered Area is required" })

Unit

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

@* @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 Mohapatra9y ago

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 Tabor9y ago

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 Tabor9y ago

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 Beg9y ago

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

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

Create

The resource cannot be found.