ASp.netMVC Validations

umair mohsin

9y877.NET

how to perform validations in mvc if there is no database attached only ado.net coding is there.

e.g.

if a textbox is empty then no record should inserted and error message appears how to do that

6 Replies

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

Nilesh Shah9y ago
Hi,
I just created a view based on your class
and it works fine
please check my attached project and see what you are doing different.
0
umair mohsin9y ago
Here is my controller coding

[HttpPost]
public ActionResult Create(ProductsModel PM)
{
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(Constr))
{
conn.Open();
SqlCommand cmd = new SqlCommand("insert into Products values(@ProductName,@Price,@Count)", conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ProductName",PM.ProductName);
cmd.Parameters.AddWithValue("@Price", PM.Price);
cmd.Parameters.AddWithValue("@Count", PM.Count);
cmd.ExecuteNonQuery();

}
return RedirectToAction("Index");
}

Here is my model logics
Public class ProductsModel
{
public int Id { get; set; }
[Display(Name = "Product Name:")]
[Required]
public string ProductName { get; set; }

[Display(Name = "Price:")]
public decimal Price { get; set; }

[Display(Name = "Count:")]
public int Count { get; set; }

}

Here is my view
@model ProductsMVC.Models.ProductsModel
@{
ViewBag.Title = "Create";
}
Create
@using (Html.BeginForm()) {
@Html.AntiForgeryToken()
@Html.ValidationSummary(true)

ProductsModel

@Html.LabelFor(model => model.ProductName)

@Html.EditorFor(model => model.ProductName)
@Html.ValidationMessageFor(model => model.ProductName)

@Html.LabelFor(model => model.Price)

@Html.EditorFor(model => model.Price)
@Html.ValidationMessageFor(model => model.Price)

@Html.LabelFor(model => model.Count)

@Html.EditorFor(model => model.Count)
@Html.ValidationMessageFor(model => model.Count)

}
@Html.ActionLink("Back to List", "Index")
0
Nilesh Shah9y ago
can you post your code what you have written?
0
Puneet Kankar9y ago
check this link http://www.c-sharpcorner.com/UploadFile/13048b/model-validation-in-Asp-Net-mvc909/
0
umair mohsin9y ago
nothing happens i have tried what you said.
i will make you clear
i am created a function for insert establish all things in it and add required attribute to my model but nothing happens.if i left textbox empty then code error said parameterized query except the parameter "@SomePara" which was not supplied but no validation is working.my vs version is 2013
0
Nilesh Shah9y ago
What you want is input validation, it's irrespective of your code in database side.
Input validation in MVC is super easy, it's done via Required attribute which is placed on top of your class's property (view model class).
Just create a new MVC project in VS 2015 or VS 2017, go to register page, it has example of how to do input required validation for email and password and how to show validation summary message as well.
This is what you write in view to show validation message:
@Html.ValidationSummary("", new { @class = "text-danger" })

This is what you write in your class:
[Required]
       [EmailAddress]
       [Display(Name = "Email")]
       public string Email { get; set; }
0

ASp.netMVC Validations

Create