Emp display .aspx
|
Link button1
|
Link Button
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
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.
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>
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
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
1/15
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 in the market.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox