Skip to main content

Insert Details into Database using MVC



Introduction :
  Hi, In this tutorial you will look how to insert the data into database. using MVC. you can follow the below steps for this tutorial

Step 1 : Select  MVC  web application


Step 2 : Select Empty template with Razor view Engine.


Step 3 : Create the Database,Table for Which you are going to insert


Step 4 : Right Click on model folder add a class file to it.




Step 5 : Give the name to the class file created in Model folder. 


Step 6 : Start writing code to model.
  1. Create Property class for the details to insert.
  2. Create function for inserting details( DB Layer Coding )
Your model coding looks as below.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;
using System.Data;
using System.Data.SqlClient;

namespace MVC_1_InsertData.Models
{
public class RegistrationDetails
{

//creatinng property class for the details to insert
public string Name { get; set; }
public string EmailID { get; set; }
public string Mobilenumber { get; set; }
public string Address { get; set; }

SqlConnection con = new SqlConnection("Your connection string");
SqlCommand cmd = new SqlCommand();

//Creating function to insert details
public string InsertRegDetails(RegistrationDetails obj)
{
cmd.CommandText = "Insert into [Table] values('" + obj.Name + "','" + obj.EmailID + "'," + Convert.ToInt64(obj.Mobilenumber) + ",'" + obj.Address + "')";
cmd.Connection = con;
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return "Success";
}
catch (Exception es)
{
    throw es;
}
}
}
}

Step 7 : Right Click on Controller folder and create new Controller.


Step 8: Give name to the controller followed by the text 'Controller'


Step 9 : Your basic controller Structure 


Step 9 : Write coding to your Controller

Your controller code looks as below

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using MVC_1_InsertData.Models;

namespace MVC_1_InsertData.Controllers
{
 public class RegController : Controller
  {
   // Calling when we first hit controller.
     public ActionResult InsertDetails()
       {
        return View();
       }
   // Calling on http post (on Submit)
     [HttpPost]
     public ActionResult InsertDetails(RegistrationDetails obj)
      {
       RegistrationDetails objreg = new RegistrationDetails();
       string result = objreg.InsertRegDetails(obj);
       ViewData["result"] = result;
       ModelState.Clear();
      return View();
     }
  }
}

Step 10 : Create view by placing your cursor near your ActionResult name as below.


Step 11 : Keep View name as it looks.  check strongly typed view select your model.


Step 12 : Your View Firstly looks like below.



Step 13 : Add the below code to the view.

@model MVC_1_InsertData.Models.RegistrationDetails

@{
    Layout = null;
}

<!DOCTYPE html>

<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>InsertDetails</title>
</head>
<body>
    <div>
@using (Html.BeginForm())
{
    <table>
        <tr>
        <td>Name</td>
        <td>@Html.TextBoxFor(x => x.Name)</td>
        </tr>
        <tr>
        <td>Email ID</td>
        <td>@Html.TextBoxFor(x => x.EmailID)</td>
        </tr>
        <tr>
        <td>Mobile Number</td>
        <td>@Html.TextBoxFor(x => x.Mobilenumber)</td>
        </tr>
        <tr>
        <td>Address</td>
        <td>@Html.TextAreaFor(x => x.Address)</td>
        </tr>
        <tr>
        <td></td>
        <td><input id="Submit" type="submit" value="submit" /></td>
        </tr>
        </table>
    }
        @{
            if (ViewData["result"] != "" && ViewData["result"] != null)
            {
                ViewData["result"] = null;
                <script type="text/javascript" language="javascript">
                    alert("Details saved Successfully");
                </script>
            }
        }

    </div>
</body>
</html>

Your Coding part is completed. Now Run your Application,you will find an error that 'resource Cannot be find' Now Change your URL As 'http://localhost:60622/Reg/InsertDetails' to get Output.

To avoid this doing manually later tutorials you will see Routing concepts.

Comments

  1. Can't we insert without models in mvc

    ReplyDelete
  2. mvc iyidir öğren yiğenim. Emrullah Musa TİLKİ İZMİR

    ReplyDelete
  3. I think choosing a time to look for an apartment is less priority. From this post, I Know that we have to focus on the time to look for the new apartment.
    Flats for sale in Vadapalani
    Apartments for sale in Adyar
    Premium apartments in Chennai
    New apartments in OMR
    Luxury homes in Chennai

    ReplyDelete
  4. This is an awesome post.Really very informative and creative contents.
    Wordpress Development company in Chennai

    ReplyDelete
  5. Thanks for giving an Excellent Blog, it's very useful information to us, keep on it doing like this, I eagerly waiting for your updates, Thank you So much...
    Best Aviation Academy in Chennai

    ReplyDelete
  6. Thanks for sharing an informative blog keep rocking bring more details.I like the helpful info you provide in your articles. I’ll bookmark your weblog and check again here regularly. I am quite sure I will learn much new stuff right here! Good luck for the next!
    Web Design Training in Chennai | Web Designing Training and Placement
    Web Designing Classes in Chennai | Web Designing Institute in Chennai
    mobile application development training course in chennai
    data science course in chennai

    ReplyDelete

Post a Comment