Remote Validation at Client Sode

Question

Hi How to use Remote Validation at Client side if ID Exists or not. If exists then message should be displayed. Thanks

Sachin Singh · Answer

That's what I said, play with true/false, means interchange the conditions. if (count > 0) { return Json( false , JsonRequestBehavior.AllowGet); } else { return Json( true , JsonRequestBehavior.AllowGet); }

Sachin Singh · Answer

for ado.net do as shown below Also, play with true/false as per requirement. public JsonResult IsExist( int Id) { using (SqlConnection con= new SqlConnection( "yr connection string" )) { SqlCommand cmd= new SqlCommand( "select count(Id) from table" ,con); con.Open(); int count= Convert.ToInt32(cmd.ExecuteScalar()); if (count>0) { return Json( true , JsonRequestBehavior.AllowGet); } else { return Json( false , JsonRequestBehavior.AllowGet); } } }

Sachin Singh · Answer

create a method in the controller as public JsonResult IsExist( int Id) { return Json(!context.Locations.Any(u => u.Id== Id), JsonRequestBehavior.AllowGet); } decorate the property with the attribute as public class YourClass { [Remote( "IsExist" , "ControllerName" , ErrorMessage = "Id exists" )] public int Id{ get; set; } }

Ramco Ramco · Answer

Hi Sachin I have written below code . Value also in count is 1 . Message not getting displayed public JsonResult IsExist(string Id) { using ( SqlConnection con = new SqlConnection(Common.Con)) { SqlCommand cmd = new SqlCommand("select count(Id) from Location where Id = '" +Id + "'", con); con.Open(); int count = Convert.ToInt32(cmd.ExecuteScalar()); if (count > 0) { return Json(true, JsonRequestBehavior.AllowGet); } else { return Json(false, JsonRequestBehavior.AllowGet); } } } ************************************** [Key] [Display(Name = "Id")] [Remote("IsExist", "Location", ErrorMessage = "Id exists")] public string Id { get; set; } Thanks

Ramco Ramco · Answer

Hi Sachin I am suing Ado.net then what should be the code. Secondly how the Class will be accessed. Below is the class public class Location { //private string _isactive = "Y"; public Location() { } [Key] [Display(Name = "Id")] public string Id { get; set; } [Display(Name = "Description")] [Required(ErrorMessage = "Location cannot be Blank. Max length should be less than or equal to 25"), MaxLength(25)] public string Description { get; set; } } public JsonResult IsExist( int Id) { return Json(!context.Locations.Any(u => u.Id== Id), JsonRequestBehavior.AllowGet); } Thanks