Adding a record into data base using MVC
21 September, 2018
Related Blogs
Add a new record into a data base table using MVC
Emp display .aspx
|
Link button1
|
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
↓
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 
Select generate from D/B 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 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:-
Go 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
About Author
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 .