mobileNavlogo
headerlogo

Adding a record into data base using MVC

21 September, 2018

Ratings

Related Blogs

Add a new record into a data base table using MVC

Emp display .aspx

EMP ID EName Address Salary
101      
102      
103      
Technologies   Add name Employee

                 3  Link button1

Enter EmpID  
Enter Ename  
Enter Design  
Enter DOJ  
Enter salary  
Enter Dept  
    Save
Technologies   Back to EmpDetails

         3 Link Button

Step1:

Creating the data model

       ↓

Crate a new MVC application with the name (Example 4)

       ↓

Go to solution explorer

       ↓

Select the folder model

       ↓3

Click with RM button

       ↓

Click on add

       ↓

Click on new item

       ↓

Select data from visual C# in installed template

       ↓

Select ADO.net entity data model template

       ↓

Type the name (Employee.EDMX)

       ↓

Click on add 2Select generate from D/B  2 click on next

       ↓

Click on new connection button

       ↓

Type the server name as (.:)

       ↓

Select radio button use SQL server authentication

       ↓

Type username, password (“sa”,”abc”)

       ↓

Activate the checkbox save my password

       ↓

Select the D/B employee

       ↓

Click on ok

       ↓

Activate radio button (yes include sensitive data)

       ↓

Click on next

       ↓

This will retrieve all data base table

       ↓

Select Emp details table]

       ↓

Click on finish  

Step2: 

Creating action method in home controller for Emp display

Go to home controller.cs

       ↓

Write the following code Using example. Models  -->  name space Public action result Emp display () { Employee entities.obj=new employee entities (); Return view (obj.empdetailes.to list ()); }

Desired to gain proficiency on ASP.Net?
Explore the blog post on ASP.Net training to become a pro in ASP.Net.

Step3: 

Creating view page for employee display:

Go to solution explorer

       ↓

Select the home folder from views

       ↓

Click with RM button

       ↓

Click on add

       ↓

Click on view

       ↓

Type the view page name (emp display)

       ↓

Note: Do not activate select master page

       ↓

Click on add 2 Go to source of emp display.aspx

       ↓

Write the following code <%@ import name space = “examples.models”%> <body> <h2>satya technologies</h2> <div> <table border =“2” align = “center” > <tr> <th>Emp id </th><th>Ename</th><th>Designation</th><th>DOJ</th><th>salary</th><th>Deptno</th> </tr> <% for each (var x in (Enumerable<Emp detail>) model) { %> <tr> <td><%=HTML.Encode(x.Emp Id)%></td> <td><%=HTML.Encode(x.Ename)%></td> <td><%=HTML.Encode(x.designation)%></td> <td><%=HTML.Encode(x.DOJ)%></td> <td><%=HTML.Encode(x.salary)%></td> <td><%=HTML.Encode(x.Deptno)%></td> </tr> <%}%> </table> </div> </body>   Step4: Creating view for adding a new record i.e. addnew.aspx Go to solution explorer

       ↓

Select home folder from views

       ↓

Click on add

       ↓

Click on view

       ↓

Type the view name (add new)

       ↓

Activate the check box strongly typed view

       ↓

Select the view data class as “example.models.emp detailes” Uncheck the check box Select the master page Click on add Go to source and write the following code <h2> welcome to sathya technologies</h2> <dir> <%HTML.begin.form();%> <Field set> <table align=”center”border=”2”> <tr> <td><label for=”EmpId”>Enter EmpId</label></td> <td><%=HTML.textbox(“EmpId”)%></td> </tr> <tr> <td><Label for =”Ename”>enter Emp name</Label> </td> <td><%=HTML.textbox (“Empname”)%></td> </tr> <tr> <td><label for =(”designation”)>enter designation</label> </td> <td><%=HTML.textbox(“Designetion”)%></td> </tr> <tr> <td><label for= “DOJ”>enter DOJ</label></td> <td><%=HTML.textbox (“DOJ”)%></td> </tr> <tr> <td><label for= “salary”>enter salary</label></td> <td><%=HTML.textbox (“salary”)%></td> </tr> <tr> <td><label for= “Deptno”>enter Deptno</label></td> <td><%=HTML.textbox (“Deptno”)%></td> </tr> <tr> <td></td> <td><input type=”submit” value=”save”></td> </tr> </field set> <%HTML End form();%> <%=HTML.actionlink (“back to Emp details ”,”Emp display”)%> </div> </body>  

Step5:

Writing code for adds new action method:-

2Go to home controller.cs

       ↓

Write the following code for action methods Public action result add new () { Return value(); } [Accept verbs (http verbs.post)] Public action result add new([bind]Emp details.obj add) { Employee entities.obj=new employee entities (); Obj.add to emp details (obj add); Obj.save changes (); Return redirect to action (“Emp display”); } Run the application end check

For indepth understanding click on

 

About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .