{"id":4578,"date":"2023-02-20T12:21:03","date_gmt":"2023-02-20T12:21:03","guid":{"rendered":"https:\/\/isophal.com\/?p=4578"},"modified":"2023-02-20T12:21:06","modified_gmt":"2023-02-20T12:21:06","slug":"ado-net-mvc-example","status":"publish","type":"post","link":"https:\/\/isophal.com\/news\/2023\/02\/20\/4578.html\/","title":{"rendered":"ADO.NET MVC Example"},"content":{"rendered":"\n

MVC (Model View Controller) is a web application design pattern that is widely used in application development. Here, we are creating an MVC application that connects to the SQL Server with the help of ADO.NET framework.<\/p>\n\n\n\n

This application contains a Model, a View and a Controller file. Following are the source codes of the application.<\/p>\n\n\n\n

Model<\/h3>\n\n\n\n

\/\/ Student.cs<\/strong><\/p>\n\n\n\n

    \n
  1. using<\/strong> System;  <\/li>\n\n\n\n
  2. using<\/strong> System.ComponentModel.DataAnnotations;  <\/li>\n\n\n\n
  3. namespace<\/strong> Ado.NetMvcApplication.Models  <\/li>\n\n\n\n
  4. {  <\/li>\n\n\n\n
  5.     public<\/strong> class<\/strong> Student  <\/li>\n\n\n\n
  6.     {  <\/li>\n\n\n\n
  7.         public<\/strong> int<\/strong> ID { get<\/strong>; set<\/strong>; }  <\/li>\n\n\n\n
  8.         \/\/ — Validating Student Name  <\/li>\n\n\n\n
  9.         [Required(ErrorMessage = “Name is required”)]  <\/li>\n\n\n\n
  10.         [MaxLength(12)]  <\/li>\n\n\n\n
  11.         public<\/strong> string<\/strong> Name { get<\/strong>; set<\/strong>; }  <\/li>\n\n\n\n
  12.         \/\/ — Validating Email Address  <\/li>\n\n\n\n
  13.         [Required(ErrorMessage = “Email is required”)]  <\/li>\n\n\n\n
  14.         [EmailAddress(ErrorMessage = “Invalid Email Address”)]  <\/li>\n\n\n\n
  15.         public<\/strong> string<\/strong> Email { get<\/strong>; set<\/strong>; }  <\/li>\n\n\n\n
  16.         \/\/ — Validating Contact Number  <\/li>\n\n\n\n
  17.         [Required(ErrorMessage = “Contact is required”)]  <\/li>\n\n\n\n
  18.         [DataType(DataType.PhoneNumber)]  <\/li>\n\n\n\n
  19.         [RegularExpression(@”^\\(?([0-9]{3})\\)?[-. ]?([0-9]{3})[-. ]?([0-9]{4})$”, ErrorMessage = “Not a valid Phone number”)]  <\/li>\n\n\n\n
  20.         public<\/strong> string<\/strong> Contact { get<\/strong>; set<\/strong>; }  <\/li>\n\n\n\n
  21.     }  <\/li>\n\n\n\n
  22. }  <\/li>\n<\/ol>\n\n\n\n

    View<\/h3>\n\n\n\n

    \/\/ Index.cshtml<\/strong><\/p>\n\n\n\n

      \n
    1. @model Ado.NetMvcApplication.Models.Student  <\/li>\n\n\n\n
    2. @{  <\/li>\n\n\n\n
    3.     ViewBag.Title = “Index”;  <\/li>\n\n\n\n
    4. }  <\/li>\n\n\n\n
    5. <<\/strong>h2<\/strong>><\/strong>Index<\/<\/strong>h2<\/strong>><\/strong>  <\/li>\n\n\n\n
    6. @using (Html.BeginForm(“Save”, “Students”))  <\/li>\n\n\n\n
    7. {  <\/li>\n\n\n\n
    8.     @Html.AntiForgeryToken()  <\/li>\n\n\n\n
    9.       <\/li>\n\n\n\n
    10.     <<\/strong>div<\/strong> class=”form-horizontal”><\/strong>  <\/li>\n\n\n\n
    11.         <<\/strong>h4<\/strong>><\/strong>Student<\/<\/strong>h4<\/strong>><\/strong>  <\/li>\n\n\n\n
    12.         <<\/strong>hr<\/strong> \/><\/strong>  <\/li>\n\n\n\n
    13.         @Html.ValidationSummary(true, “”, new { @class = “text-danger” })  <\/li>\n\n\n\n
    14.         <<\/strong>div<\/strong> class=”form-group”><\/strong>  <\/li>\n\n\n\n
    15.             @Html.LabelFor(model =><\/strong> model.Name, htmlAttributes: new { @class = “control-label col-md-2” })  <\/li>\n\n\n\n
    16.             <<\/strong>div<\/strong> class=”col-md-10″><\/strong>  <\/li>\n\n\n\n
    17.                 @Html.EditorFor(model =><\/strong> model.Name, new { htmlAttributes = new { @class = “form-control” } })  <\/li>\n\n\n\n
    18.                 @Html.ValidationMessageFor(model =><\/strong> model.Name, “”, new { @class = “text-danger” })  <\/li>\n\n\n\n
    19.             <\/<\/strong>div<\/strong>><\/strong>  <\/li>\n\n\n\n
    20.         <\/<\/strong>div<\/strong>><\/strong>  <\/li>\n\n\n\n
    21.         <<\/strong>div<\/strong> class=”form-group”><\/strong>  <\/li>\n\n\n\n
    22.             @Html.LabelFor(model =><\/strong> model.Email, htmlAttributes: new { @class = “control-label col-md-2” })  <\/li>\n\n\n\n
    23.             <<\/strong>div<\/strong> class=”col-md-10″><\/strong>  <\/li>\n\n\n\n
    24.                 @Html.EditorFor(model =><\/strong> model.Email, new { htmlAttributes = new { @class = “form-control” } })  <\/li>\n\n\n\n
    25.                 @Html.ValidationMessageFor(model =><\/strong> model.Email, “”, new { @class = “text-danger” })  <\/li>\n\n\n\n
    26.             <\/<\/strong>div<\/strong>><\/strong>  <\/li>\n\n\n\n
    27.         <\/<\/strong>div<\/strong>><\/strong>  <\/li>\n\n\n\n
    28.         <<\/strong>div<\/strong> class=”form-group”><\/strong>  <\/li>\n\n\n\n
    29.             @Html.LabelFor(model =><\/strong> model.Contact, htmlAttributes: new { @class = “control-label col-md-2” })  <\/li>\n\n\n\n
    30.             <<\/strong>div<\/strong> class=”col-md-10″><\/strong>  <\/li>\n\n\n\n
    31.                 @Html.EditorFor(model =><\/strong> model.Contact, new { htmlAttributes = new { @class = “form-control” } })  <\/li>\n\n\n\n
    32.                 @Html.ValidationMessageFor(model =><\/strong> model.Contact, “”, new { @class = “text-danger” })  <\/li>\n\n\n\n
    33.             <\/<\/strong>div<\/strong>><\/strong>  <\/li>\n\n\n\n
    34.         <\/<\/strong>div<\/strong>><\/strong>  <\/li>\n\n\n\n
    35.         <<\/strong>div<\/strong> class=”form-group”><\/strong>  <\/li>\n\n\n\n
    36.             <<\/strong>div<\/strong> class=”col-md-offset-2 col-md-10″><\/strong>  <\/li>\n\n\n\n
    37.                 <<\/strong>input<\/strong> type=”submit” value=”Create” class=”btn btn-default” \/><\/strong>  <\/li>\n\n\n\n
    38.             <\/<\/strong>div<\/strong>><\/strong>  <\/li>\n\n\n\n
    39.         <\/<\/strong>div<\/strong>><\/strong>  <\/li>\n\n\n\n
    40.     <\/<\/strong>div<\/strong>><\/strong>  <\/li>\n\n\n\n
    41. }  <\/li>\n\n\n\n
    42. @section Scripts {  <\/li>\n\n\n\n
    43.     @Scripts.Render(“~\/bundles\/jqueryval”)  <\/li>\n\n\n\n
    44. }  <\/li>\n<\/ol>\n\n\n\n

      Controller<\/h3>\n\n\n\n

      \/\/ StudentsController.cs<\/strong><\/p>\n\n\n\n

        \n
      1. using<\/strong> System.Web.Mvc;  <\/li>\n\n\n\n
      2. using<\/strong> Ado.NetMvcApplication.Models;  <\/li>\n\n\n\n
      3. using<\/strong> System.Data.SqlClient;  <\/li>\n\n\n\n
      4. namespace<\/strong> Ado.NetMvcApplication.Controllers  <\/li>\n\n\n\n
      5. {  <\/li>\n\n\n\n
      6.     public<\/strong> class<\/strong> StudentsController : Controller  <\/li>\n\n\n\n
      7.     {  <\/li>\n\n\n\n
      8.         \/\/ GET: Students  <\/li>\n\n\n\n
      9.         public<\/strong> ActionResult Index()  <\/li>\n\n\n\n
      10.         {  <\/li>\n\n\n\n
      11.             return<\/strong> View();  <\/li>\n\n\n\n
      12.         }  <\/li>\n\n\n\n
      13.         [HttpPost]  <\/li>\n\n\n\n
      14.         public<\/strong> ContentResult Save(Student student)  <\/li>\n\n\n\n
      15.         {  <\/li>\n\n\n\n
      16.             string<\/strong> status = “”;  <\/li>\n\n\n\n
      17.             \/\/ Creating Connection  <\/li>\n\n\n\n
      18.             using<\/strong> (SqlConnection con = new<\/strong> SqlConnection(“data source=.; database=student; integrated security=SSPI”))  <\/li>\n\n\n\n
      19.             {  <\/li>\n\n\n\n
      20.                 \/\/ Insert query  <\/li>\n\n\n\n
      21.                 string<\/strong> query = “INSERT INTO student(name,email,contact) VALUES(@name, @email, @contact)”;  <\/li>\n\n\n\n
      22.                 using<\/strong> (SqlCommand cmd = new<\/strong> SqlCommand(query))  <\/li>\n\n\n\n
      23.                 {  <\/li>\n\n\n\n
      24.                     cmd.Connection = con;  <\/li>\n\n\n\n
      25.                     \/\/ opening connection  <\/li>\n\n\n\n
      26.                     con.Open();  <\/li>\n\n\n\n
      27.                     \/\/ Passing parameter values  <\/li>\n\n\n\n
      28.                     cmd.Parameters.AddWithValue(“@name”, student.Name);  <\/li>\n\n\n\n
      29.                     cmd.Parameters.AddWithValue(“@email”, student.Email);  <\/li>\n\n\n\n
      30.                     cmd.Parameters.AddWithValue(“@contact”, student.Contact);  <\/li>\n\n\n\n
      31.                     \/\/ Executing insert query  <\/li>\n\n\n\n
      32.                     status = (cmd.ExecuteNonQuery() >= 1) ?  “Record is saved Successfully!” : “Record is not saved”;  <\/li>\n\n\n\n
      33.                     status += “<br\/>”;  <\/li>\n\n\n\n
      34.                 }  <\/li>\n\n\n\n
      35.                     \/\/ Executing select command  <\/li>\n\n\n\n
      36.                 using<\/strong> (SqlCommand cmd = new<\/strong> SqlCommand(“select * from student”))  <\/li>\n\n\n\n
      37.                 {  <\/li>\n\n\n\n
      38.                     cmd.Connection = con;  <\/li>\n\n\n\n
      39.                     \/\/ Retrieving Record from datasource  <\/li>\n\n\n\n
      40.                     SqlDataReader sdr = cmd.ExecuteReader();  <\/li>\n\n\n\n
      41.                     \/\/ Reading and Iterating Records  <\/li>\n\n\n\n
      42.                     while<\/strong> (sdr.Read())  <\/li>\n\n\n\n
      43.                     {  <\/li>\n\n\n\n
      44.                         status += “<b>name:<\/b> “+sdr[“name”]+”<br\/> <b>Email:<\/b> “+sdr[“email”]+”<br> <b>Contact:<\/b> “+sdr[“contact”];  <\/li>\n\n\n\n
      45.                     }  <\/li>\n\n\n\n
      46.                 }  <\/li>\n\n\n\n
      47.                 return<\/strong> Content(status);  <\/li>\n\n\n\n
      48.             }  <\/li>\n\n\n\n
      49.         }  <\/li>\n\n\n\n
      50.     }  <\/li>\n\n\n\n
      51. }  <\/li>\n<\/ol>\n\n\n\n

        Output:<\/p>\n\n\n\n

        \"ADO<\/figure>\n\n\n\n

        After submitting, it stores and fetches data from the SQL Server database and produce the following result to the browser.<\/p>\n\n\n\n

        \"ADO<\/figure>\n\n\n\n

        <\/p>\n","protected":false},"excerpt":{"rendered":"

        MVC (Model View Controller) is a web…<\/p>\n","protected":false},"author":1,"featured_media":4579,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[189,140],"tags":[578,191,577],"class_list":["post-4578","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-asp-net","category-programming","tag-ado-net","tag-asp-net","tag-mvc"],"_links":{"self":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/4578","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/comments?post=4578"}],"version-history":[{"count":1,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/4578\/revisions"}],"predecessor-version":[{"id":4580,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/posts\/4578\/revisions\/4580"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media\/4579"}],"wp:attachment":[{"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/media?parent=4578"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/categories?post=4578"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/isophal.com\/news\/wp-json\/wp\/v2\/tags?post=4578"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}