How to save textborfor value in sql using c#

mohaammed talha

How to save textboxfor value in sql using c#

Query in the below:

View:


    @{
        var SbTotal = OutOfhund + OutOfhundBeh + OutOfhundFun;
    }
    @Html.DisplayFor(item => SbTotal)
    @Html.TextBoxFor(item => item.Total, new { @Value = SbTotal, @readonly = "readonly" })         
    @*@(OutOfhund + OutOfhundBeh + OutOfhundFun)*@

Controller:

string query3 = "insert into AssesmentModelDetail(Total=)values('"+item.Total+"')"

2 Replies

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

Sachin Singh5y ago
You can send the values from view to controller either with Form or Ajax, you have not specified how are you sending the value and whether you are getting the value or not?
Considering that your Action Method is receiving the value
public ActionResult Save(string Total)
{
using(SqlConnection con= new SqlConnection("your connection string")){

SqlCommand cmd= new SqlCommand("insert into AssesmentModelDetail values(@Total)");
cmd.parameters.AddWithValue("@Total",Total);
con.Open();
cmd.ExecuteNonQuery();


}

return Json("Data Saved Successfully");

}
Jignesh Kumar5y ago
Hi,
= sign not require in insert statement.
string query3 = "insert into AssesmentModelDetail(Total)values('"+item.Total+"')"
Please refer this link,
https://www.c-sharpcorner.com/UploadFile/francissvk/crud-operations-in-Asp-Net-mvc-using-ado-net/