• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Display data using Razor syntax

Example to Display data of a table using Razor syntax

Create  a new view page  using with Razor engine

         

Write the following code

 

@ using system Data;
@using system Data.Sqlclient;
@ { layout = null ;
Sql connection  con = new sql connection (“”);
String s= “select * from emp details “;
Sql data adapter da = new sql data adapter (s, con);
Data set ds = new data set ();
Da.fill (ds,’x’);
}
<! Doctype html>
<html>
<head>
<title> Sample 1 </title>
</head>
<body>
<h2>Satya tech </h2>
<div>
<form action = “” Method = “Post”>
<table border = “2” align = ‘center’>
<tr>
<th>EMP id </th> <th> E name </th> <th> E sal </th>
</tr>
@ foreach (Data row R in ds. Tables [0]. Rows)
{
<tr>
<td>@ R[0]</td> <td>@ R[1]</td><td>@ R[2]</td>
</tr>
</table>
</div>
</body>
</html>

Create new view page with the name (Samples)

Learn the core features of ASP.NET Training and become master with our expertise tutorials.

14

 

Write the following code

@using system. Data;
@using system. Data. Sqlclient;
@ { layout = null;
Var r = “”;
If (is post)
{
String s = “insert in to EMP Values  (”+ Request [“txt EMP id”] + “,”+Request [“txt E name”] “+”Request [txt E Sal]” +);
SQL connection = new sql connection (“”);
SQL command cmd = new dql command (s, con)
Con.open ();
Int i = cmd. Execute non query ();
Con. Close ();
R = I +”Record s inserted”
}
}
<body>
<h2>satya  technologies </h2>
<div>
<form action = ‘’ method = ‘post’>
<table border = ‘2’ align = ‘center’>
<tr>
<td>Enter EMP id </td> <td> <input type = ‘text’ name = ‘txt emp id’> </td>
</tr>
<tr>
<td>Enter E name </td> <td> <input type = ‘text’ name = ‘txt e name’> </td>
</tr>
<tr>
<td>Enter EMP Salary </td> <td> <input type = ‘text’ name = ‘txt emp  salary’> </td>
</tr>
<tr>
<td> @ R </td>  <td> <input type  = “submit ”  name = ‘B1 value = ‘’Insert’/>  </td>
</tr>
</table>
<tr>
<td>Enter Emp salary </td> <td> <Input type= “test” name= “txt emp sal”> </td>
 </tr>
<td> @</td><td><input type = “submit”name =”Bi”,value =”insert”></td>
</tr>
</table>

For indepth understanding click on

Summary
Review Date
Reviewed Item
Display data using Razor syntax
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Display data using Razor syntax"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.